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

Like (0) Share

Report

Posted on 29 Feb 2024 04:05:46 by Sriram_S18

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.

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

Categories:

Entities

All responses (2)

Answers (0)

Sriram_S18 11 on 01 Mar 2024 at 17:14:55

Like (0)

Report

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 17 Super User 2025 Season 1 on 29 Feb 2024 at 09:12:00

Like (1)

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