How to store and load JSON in PowerApps

PowerApps allows you to store and load JSON data within SharePoint lists or any other source. To store JSON data, create a multiple lines of text column in SharePoint and convert the collection into JSON using the JSON() function. Then, use the Patch() function to store the JSON in the SharePoint list. To read the JSON data in PowerApps, parse the JSON using the ParseJSON() function and convert it into a table. Loop through the table and recreate a collection with the JSON data. Finally, store the data in a new collection. This allows you to have more flexibility with the data structure and work with complex data objects. However, it is not necessary for all solutions and should be used when the database becomes too complicated or when working with dynamic inputs.

Article 14m Tom Riha

---

Login now to access my digest by 365.Training

Login