cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
humanshield
Level: Power Up

Re: How to populate controls by values from a JSON formatted string?

Hi guys, I was monitoring this thread for info as I have a similar use case. Figured it out and posted solution here:

 

https://powerusers.microsoft.com/t5/Creating-Apps/Parse-JSON-in-PowerApps/td-p/168884

I haven't yet worked through pushing the collection back to JSON > SharePoint field (presume Concat, or the JSON function), but will post that step once I have. If anyone wants to jump in, that'd be great!

Re: How to populate controls by values from a JSON formatted string?

Hi @humanshield ,

Could you please share your approach in this thread? Not sure why, but when I  click on the link it gives an access denied message.

 

Highlighted
SPDaniel
Level: Powered On

Re: How to populate controls by values from a JSON formatted string?

I get the same access denied - hope this is not just a tease. 🙂

TiagoFreire
Level 8

Re: How to populate controls by values from a JSON formatted string?

AFAIK there is not yet a Parse JSON command in PowerApps. 

But there is one in Power Automate (formerly Microsoft Flow).

 

It will give you a layer of indirection, but you will get a structured response. 

 

You can call a Power Automate command that:

1) reads from your SP list items that have JSON data,
2) Parse JSON on your list items of interest

3) Builds the return value to PowerApps with a HTTP Response that contains a valid schema for your data. 

 

This will let you Collect() information with a nested object structure in PowerApps.

 

Be aware that depending on the amount of data, including nested objects, you might have an expensive/slow Collection, and that may require you to do strategies to cache and update only the changed rows, instead of ClearCollect()ing every time. 

 

Depending on the amount of data, if you find that the performance is suffering, it may be necessary to bring in a more powerful DB, like Cosmos DB. The same steps above would also be necessary to treat CosmosDB data to be consumed by PowerApps. 

 

Helpful resources

Announcements
thirdimage

Power Apps Super User Class of 2020

Check it out!

thirdimage

New Badges

Check it out!

thirdimage

Power Apps 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

SecondImage

Difinity Conference

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

Top Solution Authors
Top Kudoed Authors
Users online (4,803)