Answered

Initialize variable inside a Apply to Each loop

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I have a flow with a JSON array I get via Http call.

{
 "NAVN": "",
 "NAVN 2": "",
 "ADRESSE": "",
 "ADRESSE 2": "",
 "KONTAKTNAVN": "",
 "POSTNR": "",
 "BY": "",
 "Email": "",
 "Mobil": "",
 "FIRMA/PERSON": "",
 "Indmeldelseskilde": "",
 "ABONNEMENT": "",
 "Beløb": ""
 }

The array can have 1 or many lines.
What I need is to change the JSON names into some else, and for each item in the array.
Up until now I have just used Initialize Variable action to change the names in the JSON since there was only one line.
Now I have an array and I need to Initialize each item.
I tried to do it in a Apply to each but get a "The operation 'Initialize variable' can only be used at top level.".
Maybe it's just me but not being able to initialize inside the loop seems weird.

Is there a work around or another way to do this properly?

Edit:
When I try to make an Initialize Variable to the JSON array Power Automate automatically makes an Apply to Each action and then says it can't be done.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Hardesh15 7,087 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Anonymous Variable initialization can only be done at top level. You can not initialize variable inside Apply to each. Please initialize variable at top and use 'Set Variable' action inside apply to each loop.

Please 'Thumbs Up' the posts that helped you and 'Mark as Solution' if my post answered your question.

@Hardesh /Gopenly.in

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

I've found a Solution to my problem.

All I had to do was add a Data Operation Action, and in there choose the Select data operation.
This allowed me to rename the data in a single action without have to do it for every data row in the JSON array and then simple add the body (from the "Select - Setup JSON data name" action) into an Apply for Each loop. From there the loop would choose each item in the array and I can then choose what do to with it. Here I'm using it to send the data to an API.

Was this reply helpful? Yes No