Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Pages - Power Apps Portals
Answered

How to parse JSON in PowerApps?

(0) ShareShare
ReportReport
Posted on by 13

Hello Everyone,

 

I have stored JSON data in SharePoint online list multi line and text column. I need to update that column in Power Apps form.

 

Can anyone help me for how to parse / stringfy the JSON data in Power Apps without using Flow?

Thanks & Regards,
Meet

  • MeetBhatt Profile Picture
    13 on at
    Re: How to parse JSON in PowerApps?

    Hi Everyone,

    i have some queries in PowerApps Component Framework. I have added 2 posts in Microsoft Forum. But, no one replies me on that posts. Hope you help me on the same.

    Kindly refer below links of my forum posts
    https://powerusers.microsoft.com/t5/Building-Power-Apps/Unable-to-add-PCF-Component-in-PowerApps/m-p/868051#M275856

    https://powerusers.microsoft.com/t5/Power-Apps-Ideas/Custom-PowerApps-Components-and-integrate-with-SharePoint/idi-p/866877

    Thanks & Regards,
    Meet Bhatt

  • timl Profile Picture
    35,193 Super User 2025 Season 1 on at
    Re: How to parse JSON in PowerApps?

    Thanks @askondo - I appreciate that! It's a pleasure to help out where I can.

  • askondo Profile Picture
    on at
    Re: How to parse JSON in PowerApps?

    @timl Thank you for always participating in the forum and for your valid answers.

  • Verified answer
    timl Profile Picture
    35,193 Super User 2025 Season 1 on at
    Re: How to parse JSON in PowerApps?

    Hi @MeetBhatt 

    Here's an example of how to do this with string substitution functions.

    https://powerusers.microsoft.com/t5/Building-Power-Apps/Collect-JSON-data/td-p/683712

     

  • MeetBhatt Profile Picture
    13 on at
    Re: How to parse JSON in PowerApps?

    Hi @timl 

    Thanks for your response

    This question is related to canvas app. The SharePoint field data represents in record structure.

    I need to show that JSON data into Power Apps List Screen.

     

    Kindly refer below screenshot.

  • timl Profile Picture
    35,193 Super User 2025 Season 1 on at
    Re: How to parse JSON in PowerApps?

    Hi @MeetBhatt 

    Just to confirm, does your question relate to a portal app or to a canvas app? From how I read this, you have JSON data in a SharePoint field that represents a record or table structure, and you would like to modify this and to update the SharePoint field from a canvas app.

    If that is the case, there is unfortunately no simple way to do this. There is however a post in the ideas forum with this suggestion, and you can vote for it here.

    https://powerusers.microsoft.com/t5/Power-Apps-Ideas/Parse-JSON-in-PowerApps/idi-p/359563

    Flow would be the best approach because the alternative would involve manually parsing the JSON data with regex or other string functions.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Pages

#1
Lucas001 Profile Picture

Lucas001 60 Super User 2025 Season 1

#2
Fubar Profile Picture

Fubar 55 Super User 2025 Season 1

#3
surya narayanan Profile Picture

surya narayanan 35