how to display in gallery or data table the json format

(0) Share

Report

Posted on by cha143

how can i display to the gallery separated by id, transactiondate, time in and time out.

this is the sample of json from the powerautomate respond

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

v-xiaochen-msft on at

Like (0)

Report

Hi @cha143 ,

Please try to use parsejson function.

https://learn.microsoft.com/en-us/power-platform/power-fx/reference/function-parsejson

Best Regards,

Wearsky

Was this reply helpful? Yes No
anandm08 1,936 Super User 2024 Season 2 on at

Like (0)

Report
Hi @cha143 ,
I assume there is a JSON string:
Set(jsnString,"[{""Column1"":""1"",""Column2"":""1"",""Column3"":""1"",""Column4"":""1""}]");
The code should be:
Set(jsnString,"[{""Column1"":""1"",""Column2"":""1"",""Column3"":""1"",""Column4"":""1""}]"); Set(myJSONObject, ParseJSON(jsnString)); ClearCollect( coljson, ForAll( Table(myJSONObject), { Column1:Text(ThisRecord.Value.Column1), Column2:Text(ThisRecord.Value.Column2), Column3:Text(ThisRecord.Value.Column3), Column4:Text(ThisRecord.Value.Column4) }));

Was this reply helpful? Yes No
cha143 55 on at

Like (0)

Report

hi, the json is from powerautomate powerapps respond. i dont have exact json string values they are all from the response of powerautomate

and this is the value of the response

{"resultType":"JsonValue","value":[{"id":"1309","transactiondate":"2022-06-08","timein":"2022-06-08T08:35:42.18","timeout":"2022-06-08T18:21:27"},{"id":"1309","transactiondate":"2022-08- 09","timein":"2024-04-09T10:14:15","timeout":"2024-04-09T21}]

Was this reply helpful? Yes No
Verified answer

v-xiaochen-msft on at

Like (1)

Report
Hi @cha143 ,

Try this

ForAll(var.value,{id:Text(ThisRecord.id),transactiondate:Text(ThisRecord.transactiondate),timein:Text(ThisRecord.timein),timeout:Text(ThisRecord.timeout)})

Best Regards,

Wearsky

Was this reply helpful? Yes No
cha143 55 on at

Like (0)

Report

thank you so much. this solved my problem

Was this reply helpful? Yes No
cha143 55 on at

Like (0)

Report

one thing , how can i filter the transaction data that can only see the date only the current yr. ( all transaction data will be year 2024 only) and can i convert the value as text so i can display it on textbox?

Was this reply helpful? Yes No
cha143 55 on at

Like (0)

Report

hi sir @v-xiaochen-msft, maybe you could help me regarding this one. My data table displayed the whole month i just need the current date of the year and previous date . Here is the view of my datatable.

and here is the code you give me:
SortByColumns(ForAll(vaa.value,
{ pmsid:Text(ThisRecord.pmsid),
transactiondate:Text(ThisRecord.transactiondate),
year:Text(ThisRecord.transactiondate),
timein:Text(ThisRecord.timein),
timeout:Text(ThisRecord.timeout)}),
"transactiondate", SortOrder.Descending)

please help me thank you

Was this reply helpful? Yes No