Answered

How to extract field from 3-levels Nested json on PowerApps.

(0) Share

Report

Posted on by AL-23070108-0

Json String:

[
{
"Cells": {
"results": [
{
"__metadata": {
"type": "SP.KeyValue"
},
"Key": "WorkId",
"Value": "39041547530843714",
"ValueType": "Edm.Int64"
},
{
"__metadata": {
"type": "SP.KeyValue"
},
"Key": "Title",
"Value": "Titls-1",
"ValueType": "Edm.String"
}
]
},
{
"Cells": {
"results": [
{
"__metadata": {
"type": "SP.KeyValue"
},
"Key": "WorkId",
"Value": "39041547530854781",
"ValueType": "Edm.Int64"
},
{
"__metadata": {
"type": "SP.KeyValue"
},
"Key": "Title",
"Value": "Titls-2",
"ValueType": "Edm.String"
}
]
}
]

I want to extract and show fields on gallery of PowerApps like that.

Line1 : WorkId, Title

Line2 : WorkId, Title

....

I t

Categories:

Using Apps Using Formulas

All responses (3)

Answers (1)

AL-23070108-0 on at

Like (0)

Report

Re: How to extract field from 3-levels Nested json on PowerApps.

Thank you for your reply.
Verified answer

v-jefferni on at

Like (0)

Report
Re: How to extract field from 3-levels Nested json on PowerApps.

Hi @Alucard_0079 ,

First of all, the JSON string you provided is incorrect. I modified it as follows (added two "}" for each "Cells"):

[ { "Cells": { "results": [ { "__metadata": { "type": "SP.KeyValue" }, "Key": "WorkId", "Value": "39041547530843714", "ValueType": "Edm.Int64" }, { "__metadata": { "type": "SP.KeyValue" }, "Key": "Title", "Value": "Titls-1", "ValueType": "Edm.String" } ] } }, { "Cells": { "results": [ { "__metadata": { "type": "SP.KeyValue" }, "Key": "WorkId", "Value": "39041547530854781", "ValueType": "Edm.Int64" }, { "__metadata": { "type": "SP.KeyValue" }, "Key": "Title", "Value": "Titls-2", "ValueType": "Edm.String" } ] } } ]

Secondly, note that the WorkId and Title are all in Key column, so the result will be different from what you may think:

ClearCollect( var_result, ForAll( Ungroup( ForAll( Table(ParseJSON(TextInput1.Text)) As AA, {results: Table(AA.Value.Cells.results)} ), "results" ), {Key: Text(ThisRecord.Value.Key)} ) )

Best regards,
AL-23070108-0 on at

Like (0)

Report

Re: How to extract field from 3-levels Nested json on PowerApps.

I tried to use PowerFx ,but failed.
Set(
var_result,
ForAll(
Table(ParseJSON(Label2.Text)),
{
Cells: ForAll(
RenameColumns(
Table(
Index(
Table(Value.Cells),
1
).Value
),
"Value",
"SubValue"
),
{
Key: ForAll(
Table(SubValue),
{Key1: Text(SubValue.results)}
)
}
)
}
)
)