Array - Apply to each

(0) Share

Report

Posted on by Mattpst

203

Hi All!

I'm having a really frustrating time with Power Automate arrays and Apply to each, and could do with some sanity! I have a simple task. I want to take a section of text, split it into an array using a delimiter and then loop through the array to check each element.

So far, I've initialised the variable as and array, stored my sample text into a Compose action, set my array value using split to generate my array elements. The next step uses "Apply to Each" to loop through each element. This is where I am having problems - Power Automate always skips this and stops. I tried to simplify the steps by manually creating an array but still get the same issue:

It's driving me bonkers! If someone could point out the obvious, I would be eternally grateful!!!

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (0)

Sort by

Suggested answer

Pstork1 69,556 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Is the Set Variable in the screenshot the way you are creating the array? That's not the way you describe it in the text, but I think that is the problem. I don't think the flow is recognizing your array as an array. That's why the apply to each is being skipped. Try actually using Split() and a string to initialize the array.

split('Test1, Test2, Test3', ',')

----------------------------------------------------------------------------------
If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

Paul Papanek Stork, MVP
Blog: https://www.dontpapanic.com/blog

Was this reply helpful? Yes No
Mattpst 203 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Pstork1,

I was using the "manual" approach to creating the array for testing - trying to keep it simple and followed this article to troubleshoot:

https://digitalmill.net/2023/07/12/using-loops-and-accessing-array-elements-in-power-automate/#:~:text=In%20Power%20Automate%2C%20loops%20provide,through%20all%20the%20array%20elements.

I used the split function previously and get the same error.

Was this reply helpful? Yes No
Pstork1 69,556 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

I just tried it using Split and it works for me. Looking at your screenshots you are using a Set Variable action. Did you use the Initialize Variable earlier in the flow? That is requried.

----------------------------------------------------------------------------------
If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

Paul Papanek Stork, MVP
Blog: https://www.dontpapanic.com/blog

Was this reply helpful? Yes No
Mattpst 203 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Pstork1,

Yep, I have an initialise:

I've tried us the Do...Until action and get the same problem.

Was this reply helpful? Yes No
Pstork1 69,556 Most Valuable Professional on at

Like
a
(2)

Report
Copy link

Link copied!

Then you don't need the Set Variable in your screenshot. As I said the flow I posted, which should look like yours, works fine. If you are doing exactly the same I'm not sure why it doesn't work for you.

----------------------------------------------------------------------------------
If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

Paul Papanek Stork, MVP
Blog: https://www.dontpapanic.com/blog

Was this reply helpful? Yes No
Mattpst 203 on at

Like
a
(0)

Report
Copy link

Link copied!

Yes, I know that I don't need the Set when I am initialising the variable with the same data - as I said, this was just for testing whilst I was playing around trying to work out why something as simple like an Apply to each wasn't working.

Was this reply helpful? Yes No