Showing results for 
Search instead for 
Did you mean: 
Level 8

Get JSON from flow into collection in PowerApps without Premium actions

Hi Guys,


I currently Parse a JSON with the Response action in Flow to get it as a collection in PowerApps.

Unfortunately the Response action has become Premium, and starting in 2020 I won't be able to use it anymore (and as this is used by over 200 people, the cost of the licenses is too big for just this one action).
In the 'Respond to a PowerApp or flow' action I can return the entire JSON as text to PowerApps, but I'm struggling to transform this into a collection.
Has anyone else managed this or have some insights?

Dual Super User
Dual Super User

Re: Get JSON from flow into collection in PowerApps without Premium actions

Hi @Sofie_D 


The Text that gets returned would need to be having delimiters which then you would have to split in PA and do a lot of work to make it into a collection


Another option would be for Flow to write the generated data into a SP list (hidden temp data list) and once it creates item in the SP List just pass the ID of the created item back to PA


Then in PA you can query the list item and get the object/collection you need



Reza Dorrani


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Helpful resources


Power Apps Super User Class of 2020

Check it out!


Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!


Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020


Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (5,102)