
Announcements
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
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