04-17-2023 17:35 PM
This PowerApps video is an Introduction to the NEW ParseJSON Power Fx function in Power Apps.
Use the ParseJSON function to parse data in JSON format.
JSON stands for JavaScript Object Notation. JSON is a text format for storing and transporting data.
JSON Payload and Power Apps can now work better together with the introduction of the new Parse JSON function. ParseJSON will parse a valid JSON string and convert it into an Untyped Object.
Use the dot operator and the Index function to navigate an Untyped Object. Use the Table function to convert JSON arrays into Tables. Use the Value, Text, and Boolean functions to restore the type of primitive data. Convert Untyped strings into typed objects.
Untyped object can hold any data structure complex or simple. Fields in untyped object can be accessed using the dot notation however the existence of fields is verified at runtime.
You will learn all about the ParseJSON function, Parse JSON payloads (simple and complex) in PowerApps, how to return data from flow to Power Apps in the form of a string Array using Standard Connector, how to retrieve JSON Array data and showcase in Galleries or load into collections, etc.
ParseJSON syntax:
ParseJSON( JSON String )
JSON String is the JSON structure in the form of string.
watch?v=FqfLiJDdC3Q
Hi @RezaDorrani , I have a json repsonse from flow in the below format . I tried reading the notAllowedInfo Array into an collection in canvas app . Tried parsing the Json using Table(ParseJson(Text(ThisRecord.notAllowedInfo))) but unable to get correct data . I tried retrieving status value which is a text and it worked . Can you help here please