You’re offline. This is a read only version of the page.
35
hi Team,
I have column Title. I need to find out if Title CONTAINS {"City","Right","Fuel","Person"} keywords. If yes then do operations.
how do i compare multiple keywords at a time.
Regards,
Hi @Narendra90 ,
Contains can only be used once in a FilterQuery of [List rows present in a table]
Please use [Filter array] after [List rows present in a table]
Choose "Edit in advanced mode"
Set the value:
@and(contains(item()?['Title'], 'City'),contains(item()?['Title'], 'Right'),contains(item()?['Title'], 'Fuel'),contains(item()?['Title'], 'Person'))
Here is a link for your reference:
Power Automate Filter Array + Examples - EnjoySharePoint
Best Regards
Cheng Feng
datasource is excel file located on sharepoint. It contains all the keywords.
Hi @Narendra90 ,
Could you please tell me what is the data source?
Here is a test about share point list
Please try Filter Query
Share
Report
All responses (
Answers (
substringof('City', Title) or substringof('Right', Title) or substringof('Fuel', Title) or substringof('Personl', Title)
Here is a link for your reference:
Power Automate OData filter query with examples - SPGuides
If this post helps, then please consider Accept it as the solution to help the other members find it.
Best Regards
Cheng Feng
Hey @Narendra90
So, you are checking if the title contains one of these???
Then you can do something like this:
Click on the add and click on add a row
And then click above and click on OR.
I hope this was you were looking for. 🙂
