web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Pages / How to parse JSON in P...
Power Pages
Answered

How to parse JSON in PowerApps?

(0) ShareShare
ReportReport
Posted on by MeetBhatt 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

Categories:
Power Apps portals
  • timl Profile Picture
    timl 37,287 Super User 2026 Season 2 on at

    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.

  • MeetBhatt Profile Picture
    MeetBhatt 13 on at

    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.

    SS.PNG
  • Verified answer
    timl Profile Picture
    timl 37,287 Super User 2026 Season 2 on at

    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

     

  • askondo Profile Picture
    askondo Microsoft Employee on at

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

  • timl Profile Picture
    timl 37,287 Super User 2026 Season 2 on at

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

  • MeetBhatt Profile Picture
    MeetBhatt 13 on at

    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

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

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Pages

#1
M Bilal Khan Profile Picture

M Bilal Khan 139

#2
Mohsin Ali Profile Picture

Mohsin Ali 41

#3
11manish Profile Picture

11manish 21 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Solution to LinkedIn Authentication in Power Apps Portals
Welcome to the Power Pages forum!

Product updates

Microsoft Power Platform Community release plans