cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Sofie_D
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?

1 REPLY 1
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

 

Regards,

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

Announcements
thirdimage

Power Automate Community User Group Member Badge

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

sixthImage

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

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 200 members 5,298 guests
Please welcome our newest community members: