web

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

News and Announcements icon

Power Platform CommunityForums Power Automate Iteration through the ...

Power Automate

Answered

Iteration through the union

(0) Share

Report

Report

Posted on by 5ar94

10

Hi guys, I haven't been able to solve this problem for a long time.

I extract unique numbers from the excel file with the union and I want to iterate through it.

But the length of my union is always 1 (instead of 4 as it should be in the example)

Example:

Result:

Why is the array length not 4?

Categories:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

Expiscornovus 33,872 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi @5ar94,

In your last screenshot it looks like your array value has two [[ characters and ]] instead of just one [ and ]. So, it is kind of a nested array.

You could use this expression:

length(variables('ArrayNumber')[0])

Or alternatively remove the extra [] from your value.

Was this reply helpful? Yes No
5ar94 10 on at

Like (0)

Report
Copy link

Link copied!
Thank you so much bro! length(variables('ArrayNumber')[0]) solved the problem.

Was this reply helpful? Yes No

Join the conversation