Check array values and return the index of specific value

(0) Share

Report

Posted on by OmarSaleh

Hi,

Can anyone please help me with this?

I'm trying to check an array in Power Automate whether it has a number or not, and return its index. The array is received from powerapps as a string and the number of elements is not fixed, but it could have one numeric value.

some examples of the arrays the flow might receive from powerspps

["","","200",""]

["","",""]

["","400",""].

The flow I need to make should check first if the array has a numeric value or not, and if it does, the flow should return its index and a variable.

any thoughts?

Categories:

Business Process Flows

All responses (1)

Answers (0)

Matthy79 4,178 Super User 2024 Season 1 on at

Like (1)

Report
Re: Check array values and return the index of specific value

Hello @OmarSaleh

This is what the flow could look like:

Use json function to transform your parameter into an array.

Use select to create your index. index = item() and value =

outputs('Compose_string_array')[item()]

Use filter array to only get those elements that has a numeric value

Respond to your app using this formulas:

if(empty(body('Filter_index')), false, true)

coalesce(first(body('Filter_index'))?['value'], -1)