Skip to main content

Notifications

Topic Creation & Management
Unanswered

How to search a array of values in filter array - Power Automate

Posted on by 11

Hi, can I know how to search a array of values in filter array in Power Automate.

For example - user input in PVA was - name1, name2 . I have split this input by comma. 

Sriram_S18_0-1709179311574.png  

Sriram_S18_1-1709179395465.png


How can I search these values in filter array without using for each loop?

 

Categories:
  • Sriram_S18 Profile Picture
    Sriram_S18 11 on at
    Re: How to search a array of values in filter array - Power Automate

    Thanks for your answer. We don't know how many inputs we will get. Is there a way to search an array of user input values in a filter array without using loop?

  • VauBee Profile Picture
    VauBee 17 on at
    Re: How to search a array of values in filter array - Power Automate

    Hi @Sriram_S18 !  Assuming you’ve already split the user input by comma (as you mentioned), you should have an array of values, you can use Filter array action.

    • From: the array you want to search
    • Filter: use advanced mode -> contains to check if each item in the array contains any of the user input values

     

    @or(
    	contains(item()?['name'], 'name1'),
    	contains(item()?['name'], 'name2')
    )

     

    The output will contain only the items that match the search criteria & you can then process this filtered output as needed (e.g., store it in a variable, use it in subsequent actions, etc.)

     

    ------------------------------------------------------------------------------------------------------------------------------
    If I have answered your question / helped to solve your problem, please accept as solution and give me a Thumbs up. Thanks! - Remember: you can accept more than one post as a solution.

Helpful resources

Quick Links

Welcome to the Power Platform…

We are thrilled to unveil the newly-launched Power Platform Communities!…

Getting Started…

Welcome to the Power Platform Community! We appreciate your visit…

Welcome to the new Power Platform Community!…

We are excited to announce our new Copilot Cookbook Gallery in the Community…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 138,030

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,085

Leaderboard

Featured topics