Use Output of compose in get items filter query

(0) Share

Report

Posted on by ganeshn07

I need help in using filter query in get items from compose outputs.

Below is the output from compose

[

"First",

"Second"

]

I need to pass this in filter if the name matches in the list, but below is how I get the output

Please help how I can compare and get items from the list if it matches.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (2)

Rhiassuring 8,690 Moderator on at

Like (0)

Report

If you just want the First one, you can use the expression "first()" - in between the brackets you put the output from your Compose.

If you want to do it for each item in your Compose's output, you can use an "Apply to Each" and then point the Filter Query at the "Current Item" (it'll be at the very bottom of your dynamic content).

Like this:

Was this reply helpful? Yes No
Verified answer

v-liwei-msft on at

Like (0)

Report
Hi @ganeshn07

You can use or to connect two conditions in the filter query (note the single quotes).

Title eq 'A' or Title eq 'B'

Best Regards,

Levi

Was this reply helpful? Yes No
Verified answer

grantjenkins 11,063 Moderator on at

Like (0)

Report
Here's an example that should work with as many items in your array as you want. Effectively, it builds up the filter for each item separated by an or clause.

Full flow below. I'll go into each of the actions.

Compose contains your array of items.

Select will build up an array of individual conditions. The expression used here is:
concat('Title eq ''', item(), '''')

If I ran my flow now, I'd get the following output from my Select:
[ "Title eq 'First'", "Title eq 'Second'" ]

Join will join each of the items above, separated by ' or '.

The output from my Join would be:
Title eq 'First' or Title eq 'Second'

Get items can then use the output from the Join as the Filter Query we need.

Was this reply helpful? Yes No