web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / compare list with string
Power Automate
Answered

compare list with string

(0) ShareShare
ReportReport
Posted on by 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,

 

Categories:
I have the same question (0)
  • Sundeep_Malik Profile Picture
    6,497 on at

    Hey @Narendra90 

     

    So, you are checking if the title contains one of these???

     

    Then you can do something like this:

     

    Sundeep_Malik_0-1670313011739.png

     

    Click on the add and click on add a row

    Sundeep_Malik_1-1670313047222.png

    And then click above and click on OR.

    Sundeep_Malik_0-1670313514062.png

     

    I hope this was you were looking for. 🙂

     

     

  • v-chengfen-msft Profile Picture
    Microsoft Employee on at

    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)

    vchengfenmsft_1-1670313613917.png

     

     

    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

  • Narendra90 Profile Picture
    35 on at

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

  • Verified answer
    v-chengfen-msft Profile Picture
    Microsoft Employee on at

    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"

    vchengfenmsft_1-1670319403616.png

     

    Set the value:

    @and(contains(item()?['Title'], 'City'),contains(item()?['Title'], 'Right'),contains(item()?['Title'], 'Fuel'),contains(item()?['Title'], 'Person'))

    vchengfenmsft_0-1670319344852.png

     

     

    Here is a link for your reference:

    Power Automate Filter Array + Examples - EnjoySharePoint

     

     

    Best Regards

    Cheng Feng

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 286

#2
David_MA Profile Picture

David_MA 256 Super User 2026 Season 1

#3
Expiscornovus Profile Picture

Expiscornovus 225 Most Valuable Professional

Last 30 days Overall leaderboard