Answered

compare list with string

(0) Share

Report

Posted on by Narendra90

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,

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Sundeep_Malik 6,501 on at

Like (0)

Report
Copy link

Link copied!

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. 🙂

Was this reply helpful? Yes No
v-chengfen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Narendra90 ,
Could you please tell me what is the data source?
Here is a test about share point list
Please try Filter Query
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

Was this reply helpful? Yes No
Narendra90 35 on at

Like (0)

Report
Copy link

Link copied!

datasource is excel file located on sharepoint. It contains all the keywords.

Was this reply helpful? Yes No
Verified answer

v-chengfen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No