Skip to main content

Posts

Showing posts with the label #poweraddicts

PowerApps PowerFx ParseJSON Function

Today we start looking at another feature from the feature list called ParseJSON. We have already seen Named Formulas and Find and Replace in our previous blog(s). In today’s world where most of the solutions are shifting towards Restfull WebAPI’s receiving JSON responses and having a built-in parsing feature will be the cherry on the cake. PowerApps most recent release allows us to take JSON and extract properties from untyped objects. What is ParseJSON function? Use the ParseJSON function to parse data in the JSON format and create untyped objects. 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. Use the DateValue, DateTimeValue, TimeValue, ColorValue, and GUID functions to convert untyped strings into typed objects. How to enable ParseJSON feature? Assuming you have already created an app and you are using the