Hi guys, I was monitoring this thread for info as I have a similar use case. Figured it out and posted solution here:
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!
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.
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.
Check it out!
Check it out!
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
The largest Power BI, Power Platform, and Data conference in New Zealand