Get items filter query several columns help

[288088]

Hello!

I want to filter with several column, right now only "Title" works, how do I input more columns in the fitler Query?

[v-bacao-msft · Accepted solution]

Hi @288088 ,

You can try to use "and" to add multiple similar filter conditions.

Best Regards,

[288088]

@v-bacao-msft 

Hello

This still wont work for me, tried this:

substringof ('@{variables('varTextwords')}',Title and Author)

I get error:

Action 'Get_items' failed 

[v-bacao-msft]

Hi @288088 ,

Should be this : 

substringof ('@{variables('varTextwords')}',Title) and substringof ('@{variables('varTextwords')}',ColumnName)

Best Regards,

[288088]

@v-bacao-msft 

Hello!

I tried this but it wont work, it gives no errors but the body is blank [ ].

When I try with this query it works perfectly:

substringof ('@{variables('varTextwords')}',Title)

When I try this query it wont work and gives Body [ ]

substringof ('@{variables('varTextwords')}',Title) and substringof ('@{variables('varTextwords')}',Author)