Extract values from array without looping

(0) Share

Report

Posted on by fero

I have an array like this in a power automate flow:

[

{

"fileUri": "1YS000.xml"

{

"fileUri": "ZJBGF.xml"

}

]

I need to extract the value of each element so that the resulting output is ["1YS000.xml","ZJBGF.xml"]

I can do that using an 'apply to all' loop but that takes several minutes. Is there a better way to do this? I was trying to use Select, but I just got the exact same output.

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

Pstork1 68,697 Most Valuable Professional on at

Like (0)

Report

You can do that with a Data Select action if you switch its mapping into Text mode. You can then grab the value from that key and add it to the resulting array without a key.

Was this reply helpful? Yes No
fero 12 on at

Like (0)

Report

Apologies, but I'm not sure I understand the "grab the value from that key and add it to the resulting array without a key". Here's what I did originally. Do you mean that I take "item()?['fileUri']" and add it to an array variable?

Was this reply helpful? Yes No
Pstork1 68,697 Most Valuable Professional on at

Like (1)

Report

The Data Select will automatically return an array. So after switching to text mode just insert the fileUri dynamic content. You don't need any of the other JSON syntax you are using. Loop at Map in the data select screenshot I posted.

Was this reply helpful? Yes No
fero 12 on at

Like (0)

Report

Aha! I was missing half the picture you posted originally. This worked like a charm! Thanks so much @Pstork1 !

Was this reply helpful? Yes No