cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
omh Helper II
Helper II

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
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

4 REPLIES 4
Highlighted
Microsoft
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

Community Support
Community Support

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 Helper II
Helper II

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.

AnkitShah55 Advocate II
Advocate II

Re: Parse JSON string in Power APPS

@omh How did you succeed parsing JSON using flow? Can you share more details?

Helpful resources

Announcements
MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Apps Community!

Top Solution Authors
Top Kudoed Authors
Users online (7,055)