Showing results for 
Search instead for 
Did you mean: 
Power Apps
Power Apps

ParseJSON feedback

It’s been roughly two months since we released ParseJSON as an experimental feature in Power Apps. A lot of scenarios for makers have been unblocked with this feature, and we’ve seen great uptake even though it’s still considered experimental. We’re anxious to get this out of that experimental status. I wanted to take the opportunity to highlight a recent improvement, and address feedback with some of the future plans we have once we take ParseJSON (and untyped objects) out of the experimental phase.

Finally, and most importantly, I’m asking for your feedback. I will elaborate below but if you’re using ParseJSON I would love to hear from you. We’ve seen comparatively low feedback given the amount of usage. This is probably a good sign, but it makes us a little nervous pushing to preview or GA without making sure there aren’t any issues we just haven’t heard about.


Update since experimental launch

You can now use ForAll(), like Index(), directly on an untyped object. A JSON object array such as [ { “id”: 1, “Title”: “One” }, { “id”: 2, “Title”: “Two” } ] would previously require a Table(ParseJSON()) call before going to ForAll. This has the added drawback of resulting in a single-column table with untyped objects, so you would get something like:


ForAll( Table(untypedObject), { id: Value( )


requiring you to use the .Value field on ThisRecord for the single-column table. You can now pass untyped objects directly into ForAll, which no longer creates a single-column table requiring the use of the Value column. So the previous example becomes:


ForAll( untypedObject, { id: Value( )



Feedback so far

The feedback we’ve received so far is positive in that this feature unblocks many scenarios involving JSON. There are two recurring points of feedback we’ve heard from multiple customers:


  1. The feature is very “verbose” today due to the requirement of casting every field individually to a specific type. If you set a table of untyped objects as the Items source of a gallery, each use of a field requires Value(), Text() and other casting everywhere you wish to use the fields. For now you can consider using ForAll to type everything into a typed table first, as shown above, making field access easier. Our ultimate goal is to allow you to define your own type schemas and cast the whole JSON to it. We envision this feature to be used with the ParseJSON() function, where you pass in the JSON string as well as the type you defined, and the result of ParseJSON() would then be a typed object as opposed to an untyped object that requires casting. To be clear, we intend to GA ParseJSON with untyped objects first, and add the new typing features later on.


  1. Using ParseJSON() with connectors. If a column from a datasource contains a string with JSON, that is easy enough. But we’ve heard of scenarios where makers want to take the whole response message from a connector and manually parse the JSON when the app runs. The connector team is looking to build on top of our work with untyped objects, and beyond that also the previously mentioned type schema definitions to take connectors to a new level. The experimental Dynamic Schema feature is great but is missing some features and flexibility in Power Fx, and we’re starting to address those in Power Fx (with untyped objects and type definitions). There’s some short and long term work going on that I hope you will get to hear about soon.


If you have any feedback or concrete scenarios you’d like to share, I'd love it if you could comment on this thread. I would love to understand how you’re using ParseJSON or trying to use ParseJSON!


@Zanzaid1 I think it might depend on whether the app has been updated with a newer version. I found that apps that I had not changed recently could access the earlier version, but those that had been updated with later versions could not. So maybe some of the later versions introduce changes that cannot be reversed, so you pass a sort of invisible 'point of no return'.

Frequent Visitor

Any update on begin able to ParseJSON() directly from a connector?  This is driving me nuts.  I have the JSON but I can't do anything with it (can't parse it) because it is untyped.  Are there any workarounds??  I dump it into a variable but it is untyped so I can't ParseJSON it.  I can look at the variable value in Power Apps editor, copy it, paste it into a text box, and then ParseJSON the text box, but I can't ParseJSON the connector or variable because they are untyped.

Maybe the only thing to do is Parse it with Power Automate?  Not excited about the lag...

Advocate II
Advocate II

@VTBob, I'm not an expert, but you need to manually convert to the appropriate type. There is a guide somewhere in this thread. I have had over ten fields that I had to manually do myself (although ChatGPT would be helpful). It looks something like this: 

ClearCollect(colSitePages, ForAll( Table( ParseJSON(varJSONPages) ), { id: Value(, Title: Text(ThisRecord.Value.title), FileRef: Text(ThisRecord.Value.fileref), CanvasContent: Text(ThisRecord.Value.canvascontent) } ) ) )

What exactly are you trying to do? We have added automatic coercion for most scenarios quite a while ago, so you shouldn't even have to convert them to proper types. You can't get intellisense for them because they're untyped and undiscovered during development of your app, but everything should work. ParseJSON() takes a string and returns an untyped object, so that's not what you're looking for anyway.


Can you elaborate what you're trying exactly?

Frequent Visitor

I have a connection that returns a JSON string; or, actually, I guess it's an untyped object. I want to put the JSON data from the connection into a table, but I can't because it's not a string, it's an untyped object. 

Gotcha. In that case yes you will need to explicitly convert to typed fields... for example if you need to make a new record you would do something like:

Set( myNewRecord, { ID = Value(untypedjson.ID), Name = Text(untypedjson.Name) } )

In other areas you can use untypedjson.ID directly as Power Fx can know what type is expected and automatically convert, for example when you set it in a label. When you're trying to put it in a record things need to match perfectly so you need to explicitly convert them.

Also check out 


Hope this helps...

Frequent Visitor

I'm currently testing using ParseJSON to replace my Split/Concat method of storing a table in a multi line text column in SharePoint.

Reading the data is easy, manipulating and patching back was a bit of a struggle, but found a solution. Not sure if it's the best way, but seems to be working well.

By creating a collection of the Parsed JSON with the AddColumns:



I can then manipulate the Collection and patch it back to SharePoint using the IgnoreUnsupportedTypes to ignore the original UntypedObjects.


Patch(Database,LookUp(Database,ID = varSelected.ID,ThisRecord),


Not sure if this is the best method of doing it, but it feels better than having to use ForAll and Split to reconstruct collections.

Power Apps
Power Apps

You could also do ForAll( ParseJSON(..), { Item: Text(ThisRecord.Item), UOM: ..... } ) etc.

Super User
Super User


Thank you & the team soo much for adding this functionality. I have a couple example use-cases you may be interested in…


Large SharePoint List Delegation Eorkaround

This solution using ParseJSON helps resolve a Lonnggg standing issue common among users who couldn’t get the best functionality out of apps using SharePoint lists because of delegation limitations. It enables filtering, searching, & returning a lot more SharePoint items beyond the set 2000 delegation limit. It can even search multiple multiline text columns.




Secondly, I am using ParseJSON( ) to return JSON data extracted from many different documents with different formats from different suppliers from this flow template:


I find it is much more flexible, lower maintenance, & lower cost than other AI Builder methods in extracting data from many different documents.

So I actually put this all together in my app by returning the flow JSON as a string to a variable and an input field for each document, ex: InvoiceDocumentJSON. That way I can track which documents have been uploaded & data extracted during the current user session & still have the string JSON of past document extractions for files in previous user sessions. Then when the app registers a new document has been uploaded, it performs several comparisons on many fields & table rows to set several Yes|No|N/A fields to Yes or No. Once implemented it will effectively automate at least half the order document cross-checks for our procurement team.

The system effectively reads documents & completes most of any given review on its own!

Advocate IV
Advocate IV

It seems that ParseJSON() currently behaves differently in preview mode than in play mode.


Steps to recreate the issue:

1. Create a new Canvas app and add the "Accounts" table to it

2. Add a button to the screen and rename its caption to "Init"

3. Add the following code to OnSelect():





// load accounts into collection as stringified json
    Collect( colData, {
        id: CountRows(colData) +1, 
        entity: "account",
        record: JSON(ThisRecord, 
                    JSONFormat.IgnoreUnsupportedTypes &





4. Add a Text Label, set its BorderThickness to 1 and add the following code to the Text property:




Coalesce( Text( ParseJSON( First( Filter( colData, entity = "account")).record).name), "empty")





5. Preview the app and click the Init-Button

The first account name will be shown

ParseJSON Issue_1.png

Up to here the app behaves as expected.


6. Save the app and close the edit window

7. Play the app (in, Windows App or on Mobile)

8. Click the Init-Button

The Text Label shows "empty"

ParseJSON Issue_2.png


I have no idea why the app behaves this way in play mode. I have tested in 2 different tenants with different versions (3.23091,14, 3.23092.4, 3.23082,20).




After further testing I found out that the cause for this misbehavior has nothing to do with the ParseJSON(), nor the JSON() function, but with the app setting Explicit column selection.


Explicit column selection.png


If this setting is enabled (which is the case by default), only the columns specified in the code are transferred from supported data sources.

For the following code example only the accountid column is transferred in play mode, since no column is explicitly addressed.



// load accounts into collection as stringified json
    Collect( colData, {
        id: CountRows(colData) +1, 
        entity: "account",
        record: JSON(ThisRecord, JSONFormat.IndentFour & JSONFormat.IgnoreUnsupportedTypes & JSONFormat.IncludeBinaryData) 





 However, this only applies in play mode. In preview mode, the entire records will be transferred.





If the app setting Explicit column selection is deactivated, the entire record is transferred, even if no specific columns are addressed.

Why it behaves differently in preview mode than in play mode is beyond me. To avoid future confusion, I think the  preview mode behavior should be aligned with the play mode.


Helpful resources


Join Us for the First-Ever Biz Apps Community User Group Meeting: Live from MPPC23

  Join us for the first-ever the Biz Apps Community User Group meeting live from the Power Platform Conference! This one hour user group meeting is all about discovering the value and benefits of User Groups! Discover how you can find a group in your local area or about specific topics where you can learn new skills and meet like-minded people as a user group member.   Hear from User Group leaders about why they do what they do and what resources they receive to help them succeed as community ambassadors. If you have never attended a User Group meeting before, this will be a great introduction! We hope you are inspired to find a group that meets your unique interests!   October 5th at 2:15 pm Pacific time   If you're attending #MPPC23 in Las Vegas, join us in person! Find out more here:!/session/Biz%20Apps%20Community%20User%20Group%20Meeting%20-%20Live%20from%20MPPC/6172   Not at MPPC23? Attend vvirtually by registering here:    If you can't attend this meeting live, don't worry! We will record this meeting and share it with the Community at 

Back to Basics: Tuesday Tip #1: All About YOUR Community Account

We are excited to kick off our new #TuesdayTIps series, "Back to Basics." This weekly series is our way of helping the amazing members of our community--both new members and seasoned veterans--learn and grow in how to best engage in the community! Each Tuesday, we will feature new areas of content that will help you best understand the community--from ranking and badges to profile avatars, from Super Users to blogging in the community. Our hope is that this information will help each of our community members grow in their experience with Power Platform, with the community, and with each other!     This Week's Tips: Account Support: Changing Passwords, Changing Email Addresses or Usernames, "Need Admin Approval," Etc.Wondering how to get support for your community account? Check out the details on these common questions and more. Just follow the link below for articles that explain it all.Community Account Support - Power Platform Community (   All About GDPR: How It Affects Closing Your Community Account (And Why You Should Think Twice Before You Do)GDPR, the General Data Protection Regulation (GDPR), took effect May 25th 2018. A European privacy law, GDPR imposes new rules on companies and other organizations offering goods and services to people in the European Union (EU), or that collect and analyze data tied to EU residents. GDPR applies no matter where you are located, and it affects what happens when you decide to close your account. Read the details here:All About GDPR - Power Platform Community (   Getting to Know You: Setting Up Your Community Profile, Customizing Your Profile, and More.Your community profile helps other members of the community get to know you as you begin to engage and interact. Your profile is a mirror of your activity in the community. Find out how to set it up, change your avatar, adjust your time zone, and more. Click on the link below to find out how:Community Profile, Time Zone, Picture (Avatar) & D... - Power Platform Community (   That's it for this week. Tune in for more Tuesday Tips next Tuesday and join the community as we get "Back to Basics."

Power Platform Community Newsletter: September 2023

Welcome to our September 2023 Newsletter, where we highlight the latest news, product releases, podcasts, upcoming events, and the great work of our Power Platform Community members. As usual, please make sure you follow our News & Announcements in the Community to stay up to date. Another great way to connect is to join our Power Platform Community on LinkedIn. You can join our LInkedIn community here.   MPPC's Got Power - Submissions end September 28th! Are you ready to showcase your skills at the Microsoft Power Platform Conference in Las Vegas? Don't miss out on the "MPPC's Got Power" talent show, a grand celebration of connection, inspiration, and shared journeys. Whether you're a technical innovator, a talented storyteller, or have a hidden creative side, we want to see what you've got! With three categories to choose from, you have the chance to shine on stage and make your mark in the Microsoft Power Platform community.  Click the GIF to sign up by Thursday 28th September to be part of an unforgettable MPPC23 experience. Now is your time to shine!     Check Out the Low Code Approach Podcast Give the Low Code Approach Podcast a listen! Hosted by Sean Fiene, Wendy Haddad, and Kenric Auguillard, this innovative show shines a light on how Microsoft MVPs, product team members, and Community users are building exciting solutions using Microsoft Power Platform. Plus, with guests like Kartik Kanakasabesan, April Dunnam, Ricardo Duncan Jr., Sonja Gu, Phil Topness, Shane Young and more, this weekly show is a must for all you Business Applications enthusiasts out there. Click the image below to check it out!           COMMUNITY HIGHLIGHTS Check out the most active Community users for August 2023. These hardworking members are posting regularly, answering questions, writing blogs, giving kudos, and providing top solutions in their communities across Power Platform. Huge thanks to these amazing community members for their great contributions last month! trice602poweractivateLaurensMWarrenBelzAmikBCBuizerSamLedcreativeopinion timlExpiscornovusManishSolankiMattJimisonfernandosilvaMisterMarkPstork1saudali_25hafizsultan242Lucas001ragavanrajanp_doc   UPCOMING EVENT: 365 EDUCON CHICAGO Whether you're new to Microsoft 365, Power Platform and SharePoint, or an experienced power user, admin or developer, 365 EduCon has content designed to fit your experience level and area of interest. Their workshops and sessions are taught by Microsoft Certified Trainers, MVPs, Regional Directors, and Engineers. Find out more and register here: Home - Microsoft 365 EduCon Chicago - A Microsoft 365 Conference.  

Announcing the MPPC's Got Power Talent Show at #MPPC23

Are you attending the Microsoft Power Platform Conference 2023 in Las Vegas? If so, we invite you to join us for the MPPC's Got Power Talent Show!      Our talent show is more than a show—it's a grand celebration of connection, inspiration, and shared journeys. Through stories, skills, and collective experiences, we come together to uplift, inspire, and revel in the magic of our community's diverse talents. This year, our talent event promises to be an unforgettable experience, echoing louder and brighter than anything you've seen before.    We're casting a wider net with three captivating categories:  Demo Technical Solutions: Show us your Power Platform innovations, be it apps, flows, chatbots, websites or dashboards... Storytelling: Share tales of your journey with Power Platform. Hidden Talents: Unveil your creative side—be it dancing, singing, rapping, poetry, or comedy. Let your talent shine!    Got That Special Spark? A Story That Demands to Be Heard? Your moment is now!  🚀 Sign up to Showcase Your Brilliance:  🔥 Deadline for submissions: Thursday, Sept 28th    How It Works:  Submit this form to sign up:  We'll contact you if you're selected. Get ready to be onstage!  The Spotlight is Yours: Each participant has 3-5 minutes to shine, with insightful commentary from our panel of judges. We’re not just giving you a stage; we’re handing you the platform to make your mark.     Be the Story We Tell: Your talents and narratives will not just entertain but inspire, serving as the bedrock for our community’s future stories and successes.    Celebration, Surprises, and Connections: As the curtain falls, the excitement continues! Await surprise awards and seize the chance to mingle with industry experts, Microsoft Power Platform leaders, and community luminaries. It's not just a show; it's an opportunity to forge connections and celebrate shared successes.    Event Details:  📆 Date and Time: Wed Oct 4th, 6:30-9:00PM   📍 Location: MPPC23 at the MGM Grand, Las Vegas, NV, USA  

September User Group Success Story: Reading Dynamics 365 & Power Platform User Group

The Reading Dynamics 365 and Power Platform User Group is a community-driven initiative that started in September 2022. It has quickly earned recognition for its enthusiastic leadership and resilience in the face of challenges. With a focus on promoting learning and networking among professionals in the Dynamics 365 and Power Platform ecosystem, the group has grown steadily and gained a reputation for its commitment to its members!   The group, which had its inaugural event in January 2023 at the Microsoft UK Headquarters in Reading, has since organized three successful gatherings, including a recent social lunch. They maintain a regular schedule of four events per year, each attended by an average of 20-25 enthusiastic participants who enjoy engaging talks and, of course, pizza.     The Reading User Group's presence is primarily spread through LinkedIn and Meetup, with the support of the wider community. This thriving community is managed by a dedicated team consisting of Fraser Dear, Tim Leung, and Andrew Bibby, who serves as the main point of contact for the UK Dynamics 365 and Power Platform User Groups.   Andrew Bibby, an active figure in the Dynamics 365 and Power Platform community, nominated this group due to his admiration for the Reading UK User Group's efforts. He emphasized their remarkable enthusiasm and success in running the group, noting that they navigated challenges such as finding venues with resilience and smiles on their faces. Despite being a relatively new group with 20-30 members, they have managed to achieve high attendance at their meetings.   The group's journey began when Fraser Dear moved to the Reading area and realized the absence of a user group catering to professionals in the Dynamics 365 and Power Platform space. He reached out to Andrew, who provided valuable guidance and support, allowing the Reading User Group to officially join the UK Dynamics 365 and Power Platform User Groups community.   One of the group's notable achievements was overcoming the challenge of finding a suitable venue. Initially, their "home" was the Microsoft UK HQ in Reading. However, due to office closures, they had to seek a new location with limited time. Fortunately, a connection with Stephanie Stacey from Microsoft led them to Reading College and its Institute of Technology. The college generously offered them event space and support, forging a mutually beneficial partnership where the group promotes the Institute and encourages its members to support the next generation of IT professionals.   With the dedication of its leadership team, the Reading Dynamics 365 and Power Platform User Group is poised to continue growing and thriving! Their story exemplifies the power of community-driven initiatives and the positive impact they can have on professional development and networking in the tech industry. As they move forward with their upcoming events and collaborations with Reading College, the group is likely to remain a valuable resource for professionals in the Reading area and beyond.

A Celebration of What We've Achieved--And Announcing Our Winners

As the sun sets on the #SummerofSolutions Challenge, it's time to reflect and celebrate! The journey we embarked upon together was not just about providing answers – it was about fostering a sense of community, encouraging collaboration, and unlocking the true potential of the Power Platform tools.   From the initial announcement to the final week's push, the Summer of Solutions Challenge has been a whirlwind of engagement and growth. It was a call to action for every member of our Power Platform community, urging them to contribute their expertise, engage in discussions, and elevate collective knowledge across the community as part of the low-code revolution.   Reflecting on the Impact As the challenge ends, it's essential to reflect on the impact it’s had across our Power Platform communities: Community Resilience: The challenge demonstrated the resilience of our community. Despite geographical distances and diverse backgrounds, we came together to contribute, learn, and collaborate. This resilience is the cornerstone of our collective strength.Diverse Expertise: The solutions shared during the challenge underscore the incredible expertise within our community. From intricate technical insights to creative problem-solving, our members showcased their diverse skill sets, enhancing our community's depth.Shared Learning: Solutions spurred shared learning. They provided opportunities for members to grasp new concepts, expand their horizons, and uncover the Power Platform tools' untapped potential. This learning ripple effect will continue to shape our growth. Empowerment: Solutions empowered community members. They validated their knowledge, boosted their confidence, and highlighted their contributions. Each solution shared was a step towards personal and communal empowerment. We are proud and thankful as we conclude the Summer of Solutions Challenge. The challenge showed the potential of teamwork, the benefit of knowledge-sharing, and the resilience of our Power Platform community. The solutions offered by each member are more than just answers; they are the expression of our shared commitment to innovation, growth, and progress!   Drum roll, Please... And now, without further ado, it's time to announce the winners who have risen above the rest in the Summer of Solutions Challenge!   These are the top community users and Super Users who have not only earned recognition but have become beacons of inspiration for us all.   Power Apps Community:  Community User Winner: @SpongYe Super User Winner: Pending Acceptance Power Automate Community:  Community User Winner: @trice602 Super User Winner: @Expiscornovus  Power Virtual Agents Community: Community User Winner: Pending AcceptanceSuper User: Pending Acceptance Power Pages Community: Community User Winner: @OOlashyn Super User Winner: @ChristianAbata   We are also pleased to announced two additional tickets that we are awarding to the Overall Top Solution providers in the following communities:    Power Apps: @LaurensM   Power Automate: @ManishSolanki    Thank you for making this challenge a resounding success. Your participation has reaffirmed the strength of our community and the boundless potential that lies within each of us. Let's keep the spirit of collaboration alive as we continue on this incredible journey in Power Platform together.Winners, we will see you in Vegas! Every other amazing solutions superstar, we will see you in the Community!Congratulations, everyone!

Top Kudoed Authors
Users online (3,758)