Answered

Bind complex json to label and dropdown of gallery in canvas app.

Like (0) Share

Report

Posted on 26 Jan 2024 08:39:48 by Shubham_Koolwal

I have below json output
[
{
"moduelName": "test module",
"instructorinfo": [
{
"instructorName": "test test",
"instructorId": "1931dec0-c1ba-ee11-9078-6045bdd0ed08"
}
]
},
{
"moduelName": "test module1",
"instructorinfo": [
{
"instructorName": "test test",
"instructorId": "1931dec0-c1ba-ee11-9078-6045bdd0ed08"
},
{
"instructorName": "test test",
"instructorId": "1931dec0-c1ba-ee11-9078-6045bdd0ed08"
}
]
}
]
My requirement is On the gallery two control are there label and dropdown. On label I want to show each module name and on the dropdown I want to show the associate instructor name . for example for first module it will show the "test module" and only 1 instructor in dropdown and for other module it will show the "test module1" and 2 instructor in dropdown.

All responses (2)

Answers (1)

Shubham_Koolwal 15 on 27 Jan 2024 at 04:19:11

Like (1)

Report

Re: Bind complex json to label and dropdown of gallery in canvas app.

Yeah super, working as expected. Thank you so much.
Verified answer

BCBuizer 22,034 Super User 2025 Season 1 on 26 Jan 2024 at 12:13:53

Like (1)

Report
Re: Bind complex json to label and dropdown of gallery in canvas app.

Hi @Shubham_Koolwal ,

In a test I set your JSON string as the text in a Text Input control (TextInput1) so I could reference it.

Then I added a gallery and set its' Items property to:

Table(ParseJSON(TextInput1.Text))

Inside the gallery, I used the below for the Text property of a label to display the module:

Text(ThisItem.Value.moduelName)

And finally for the dropdown I set its' Items property to:

ForAll(ThisItem.Value.instructorinfo,{instructorName: Text(ThisRecord.instructorName), instructorId: Text(ThisRecord.instructorId)})

This gave me the below result:

For reference and credits: I used this article to get to this solution: https://devoworx.net/powerapps-parse-json-examples/