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.
@annajhaveriOk, it works as you stated. I managed to build a string with a comma separator.
Thanks
@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?
@annajhaveriI want to return data from SharePoint to PowerApps.
A row in SharePoint has this data (id, name, surname, age, location, etc)
@Anonymous what value you want to return in the Respond to a PowerApp or Flow?
@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.
@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.
WarrenBelz
146,518
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
65,692
Most Valuable Professional