Unanswered

How i can filter an Array using Formula inside a Select action

(0) Share

Report

Posted on by johnjohnPter

1,811 Super User 2024 Season 1

Inside Power Automate flow if i have a variable of type Array that stores ID-Title, as follow:-

[
"5-Open",
"9-Closed",
"3-With"
]

Now inside a Select action, which allow me to access the ID of a collection using:-

item()?['ID']

How i can get the title of the array item using the item()?['ID']? In other words how i can filter the array using formula? Can i benefit from XPath?

Thanks

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Gyllentid 894 on at

Like (0)

Report

I usually filter the array. Here you can use the item()?['ID'] (write this as an expression) as well. You can make three Filter arrays where you filter the with Contains Closed, With, and Open.

Does this help you?

Was this reply helpful? Yes No
johnjohnPter 1,811 Super User 2024 Season 1 on at

Like (0)

Report

@@sroo

Thanks for the reply. I know about the Filter array action,, but i want to filter the array inside the exsisting Select action,, so i need to filter it using formula.. i think this is possible using XPath

Was this reply helpful? Yes No