I have below output from flow to Power Apps.


How can I convert it into a collection?

  • How you fetched this data from flow to powerapps? Commented Jul 8, 2020 at 10:07
  • 1
    I used send Respond to PowerApps action and passed the above JSON Commented Jul 8, 2020 at 10:24

2 Answers 2


You need to use to use multiple Split functions in Power App in order to parse this string to JSON/collection variable.

It will be a complex logic and according to your data.

Check below link, it will help you to achieve what you want.

Respond Tabular Data from FLOW to PowerApps without Premium Response action

Split function in Power Apps


My data is different, I used

Clear(datas); ForAll(records,Collect(datas, MatchAll(Substitute(Result,"""",""), "ID:(?.),Start.Date of first donation:(?.),Email.First name:(?.),Surname:(?.),Postcode.Currency of donation:(?.),Regular donation amount:(?.*),The.Address 1:(?.),Freq.Address 2:(?.),")))

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.