Passing a parameter into a List query filter

(0) Share

Report

Posted on by gavinleung

216

Hi folks,

I'm using "Get Items" in the flow, in which I used Filter Query to narrow the records and do an update on all records in the set. In the filter, I filtered out the "country" of a record.

What I'm going to achieve is to have one single Flow but serves for multiple countries.

So can a parameter be passed to a Filter Query ?

Thanks,
Gavin

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (1)

yashag2255 24,769 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @gavinleung

Please take a look at the screenshot below:

Here, I am storing all the countries in an array variable and iterating over that array to get individual country in the filter query and finally updating items in the list returned from the filter query.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
gavinleung 216 on at

Like (0)

Report
Copy link

Link copied!

Hi @yashag2255 , this was absolutely great ! If the country list changes, the Flow needs to be changed too. So I think I shall use an Excel file to store the country list, so that the user or power user or the administrator can just change the file to get it running.

Let me try and let you know 🙂

Thanks,
Gavin

Was this reply helpful? Yes No
Verified answer

gavinleung 216 on at

Like (0)

Report
Copy link

Link copied!

@yashag2255 , thanks for giving me idea. In fact, I dont even need a variable to store the country list. Instead, I used a SP List to store the country list. First loop to get the list, and apply it into the Filter Query of another list.

Problem solved.

Thanks,
Gavin

Was this reply helpful? Yes No