Unanswered

How to parse JSON in PowerApps?

(0) Share

Report

Posted on by MeetBhatt

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

I have the same question (0)

All responses (6)

Answers (1)

timl 36,383 Super User 2025 Season 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
MeetBhatt 13 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

timl 36,383 Super User 2025 Season 2 on at

Like (1)

Report

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

Was this reply helpful? Yes No
askondo on at

Like (1)

Report

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

Was this reply helpful? Yes No
timl 36,383 Super User 2025 Season 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No
MeetBhatt 13 on at

Like (0)

Report

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

Was this reply helpful? Yes No