web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate How to look up value i...

Power Automate

Unanswered

How to look up value in a array ('select where' kind of)

(0) Share

Report

Report

Posted on by romankorchak2

125

Hi All

I have the following structure array:

[
{"ID":1,"name":"first item"},
{"ID":2,"name":"Second item"},
.......]

and I need to be able to find value of "name" by "ID" without ApplyToEach, type of "Lookup(Array,ID=1)" in PowerApps.

Is it possible at all in Power Automate?

Thanks

Categories:

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Manish Solanki 15,167 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @romankorchak2

You could use filter array action to perform the filter operation. Pass the input array to the action and using filter query get the resultant array. To get the single row, use an expression with first() function that return the first record from the output of filter array action just like lookup() function in power apps.

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

Was this reply helpful? Yes No

Join the conversation