Answered

JSON Array

(0) Share

Report

Posted on by DMum

Hello,

I hope you can help me with this. I have an SQL Server view (columns Status and Summary). The Status column has JSON array data in the column.

Status Summary

{ "ID": 1 , "StatusName": "Active"} Problem Description 1

{ "ID": 2 , "StatusName": "Closed"} Problem Description 2

{ "ID": 3 , "StatusName": "In Progress"} Problem Description 3

How can I get the data in this format in the collection, so I chart the data?

Status Summary

Active Problem Description 1

Closed Problem Description 2

In Progress Problem Description 3

Thank you so much!

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

Verified answer

RezaDorrani 12,145 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @DMum

PA does not understand JSON

You would have to play with strings
example:

Substitute(Substitute( Last(Split(Label.Text,":")).Result,"""",""),"}","")

Use AddColumns and accordingly update your collection (replace the label.text with the context of your column)

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.
DMum 61 on at

Like
a
(1)

Report
Copy link

Link copied!

thank you so much! worked!!
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hello,

I have been having issue with trying to write a valid JSON code on a APEND TO ARRAY VARIABLE, and I believe I have formatted it the right way but its still saying my code is not valid. Please can someone outline to me what I'm doing wrong. Thanks