web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Table(ParseJSON(String...

Power Apps

Answered

Table(ParseJSON(String)) not working

(0) Share

Report

Report

Posted on by romankorchak2

125

Hi All

I have following string

[{ "Name": "Heba Kamal" ,"Age": 22, "Active":false,"ReleaseDate" : "2022-09-01"},{ "Name": "samerKamal" ,"Age": 27, "Active":true,"ReleaseDate" : "2022-09-21"}]

which I am trying to convert to a Table via ParseJSON (Table( ParseJSON(Label3_1.Text)), as per https://devoworx.net/powerapps-parse-json-examples/ ) but its not working, I am just getting a table with one column "Value" and question mark for each row.

Any ideas what could be wrong here?

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @romankorchak2 ,

Please try:

ForAll( Table(ParseJSON(TextInput1.Text)), { Name:Text(ThisRecord.Value.Name), Age:Value(ThisRecord.Value.Age), Active:Value(ThisRecord.Value.Active)=1, ReleaseDate:DateValue(ThisRecord.Value.ReleaseDate) } )

Best Regards,

Bof

Was this reply helpful? Yes No
Verified answer

romankorchak2 125 on at

Like (0)

Report
Copy link

Link copied!
Found the way to use it in Concat
Concat(Table(ParseJSON(JsonString.Text)),Value.Name , ",")

Was this reply helpful? Yes No

Join the conversation