cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
omh
Level: Powered On

Parse JSON string in Power APPS

Hello,

 

Is there a way to parse a JSON string directly in PowerApps, and not in Flow? I have succeeded in parsing it in Flow, but I need to parse it in PowerApps directly.

 

Thank you.

Oana

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Microsoft RusselThomas
Microsoft

Re: Parse JSON string in Power APPS

Hi @omh ,

I spent some time looking at this a while ago, so if the answer has changed I'd like to know 🙂

But at the time, the answer was 'no' - or at least, 'not easily'.  The JSON function currently represents data structures in JSON, but I couldn't find an easy way to parse JSON coming in or convert it into a data structure on the fly.  

I started writing some pretty complicated formulas to do it, but as you end up literally having to write a JSON parser with expressions and regex matching, it ended up being way to laborious.

Would be more than happy to be proven wrong on this though - you can in the meantime UPVOTE the idea in the ideas form;

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

Kind regards,

RT

View solution in original post

3 REPLIES 3
Highlighted
Microsoft RusselThomas
Microsoft

Re: Parse JSON string in Power APPS

Hi @omh ,

I spent some time looking at this a while ago, so if the answer has changed I'd like to know 🙂

But at the time, the answer was 'no' - or at least, 'not easily'.  The JSON function currently represents data structures in JSON, but I couldn't find an easy way to parse JSON coming in or convert it into a data structure on the fly.  

I started writing some pretty complicated formulas to do it, but as you end up literally having to write a JSON parser with expressions and regex matching, it ended up being way to laborious.

Would be more than happy to be proven wrong on this though - you can in the meantime UPVOTE the idea in the ideas form;

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

Kind regards,

RT

View solution in original post

Microsoft v-siky-msft
Microsoft

Re: Parse JSON string in Power APPS

Hi @omh ,

 

As RusselThomas said, I'm afraid that PowerApps can't parse JSON directly right now.

You can provide the feedback to PowerApps Ideas Forum, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.

Please follow up this Idea, lots of people are pushing this forward.

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

 

Best regards,

Sik

omh
Level: Powered On

Re: Parse JSON string in Power APPS

Thank you @v-siky-msft , @RusselThomas . I have voted the idea. Let's hope that it will be implemented.

Helpful resources

Announcements
Better Together’ Contest Finalists Announced!

'Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Join THE global Microsoft Power Platform event series

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

thirdimage

Microsoft Business Applications Virtual Launch

Join us for the Microsoft Business Applications Virtual Launch Event on Thursday, April 2, 2020, at 8:00 AM PST.

thirdimage

Community Summit North America

Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (10,364)