Answered

Flow save failed with code 'InvalidVariableInitialization' and message 'The variable action 'Initialize_variable' of type 'InitializeVariable' cannot be nested in an action of type 'Apply_to_each'.'.

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi,

What does this error mean and how to solve it?

I want to get the info of a Sharepoint row and pass it back to Powerapps in order to do something with that data using Power automate.

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (1)

annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@Anonymous the error says that you cant add "Initialize Variable" action inside apply to each action. So add "Initialize Variable" action before the Apply to each action, and then add "Set Variable" action inside Apply to each action, to set the value of variable.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@annajhaveriI did what you suggest. It works without the respond to powerapps flow, but i need that flow to send that data to my powerapps.

Was this reply helpful? Yes No
annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@Anonymous what value you want to return in the Respond to a PowerApp or Flow?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@annajhaveriI want to return data from SharePoint to PowerApps.
A row in SharePoint has this data (id, name, surname, age, location, etc)

Was this reply helpful? Yes No
Verified answer

annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
@Anonymous using "Respond to a PowerApp or Flow" action you cant return an array, so i would suggest to change the type of variable to string. And instead of Set Variable use "Append to string variable" action and use concat expression to concat values of id, name surname, age, location, etc, example expression as below:

concat(items('Apply_to_each')?['ID'],', ',items('Apply_to_each')?['Title'],', ',items('Apply_to_each')?['Name'])

See how actions will be added in flow in screenshot below

Are you using filter query on Get Items to get specific item from list?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

@annajhaveriOk, it works as you stated. I managed to build a string with a comma separator.

Thanks

Was this reply helpful? Yes No