The video covers the use of Power Apps and JSON parsing, whereby complex JSON data is transformed into data that is usable in Power Apps. The focus is on dealing with different types of data ranging from simple key-value pairs to nested arrays and objects. The use of Power Apps functions such as ParseJson, Value, and Text is explained to manipulate the data types to get desired results. The tutorial extends its coverage to using Microsoft Flow to fetch JSON data from SharePoint and parse it in Power Apps.
A senior program manager at Power Apps, Joris de Gruyter, announces the experimental release of the ParseJSON function, which parses JSON strings into Power Fx objects and types. This new function aims to make working with JSON in Canvas apps much simpler. The ParseJSON function is perceived as both easier to read and more robust, tolerating reordered and additional fields.
JSON forms an essential part of a number of modern services and systems. Power Apps have multiple inbuilt connectors that communicate with these services via JSON. The ParseJSON function in Power Apps dramatically simplifies interacting with these services and further enhances the functionality of the apps. Power Apps aims to bridge the gap between static schema updates and handling dynamic scenarios with JSON strings, with the experimental release of ParseJSON serving as a crucial first step.
The text discusses how to use Power Apps to parse complex JSON data. Techniques for dealing with simple key-value pairs to nested arrays and objects are covered. Power Apps functions like ParseJson, Value, and Text are used to manipulate data types. The text also mentions the use of Microsoft Flow to fetch JSON data from SharePoint and parse it in Power Apps. The newly introduced ParseJSON function in Power Fx, which can parse JSON strings into Power Fx objects and types, is highlighted. This function significantly simplifies working with JSON in Canvas apps. In addition, a customer's use case of extracting information from a JSON string stored in a Dataverse table is presented.
Microsoft Power Apps tutorial, JSON parsing in Power Apps, Microsoft Flow SharePoint tutorial, Power Fx ParseJSON function, Manipulating data in Power Apps