web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / JSON object in collection
Power Apps
Unanswered

JSON object in collection

(0) ShareShare
ReportReport
Posted on by 8

Hello,

 

Does anyone know how to handle this?

 

I have a JSON output from a flow to a PowerApp. It´s a array with the structure of 1 integer and 1 object including 2 strings.

 

I would like to show it in a collection, but the object (labels) isn´t displaying anything. How do I access a JSON object to a collection?

 

I want my collection to look like this, 

1name1comment1
2name2comment2

 

Schema

{
    "type""array",
    "items": {
        "type""object",
        "properties": {
            "project_number": {
                "type""integer"
            },
            "labels": {
                "type""object",
                "properties": {
                    "name": {
                        "type""string"
                    },
                    "comment": {
                        "type""string"
                    }
                }
            }
        },
        "required": [
            "project_number",
            "labels"
        ]
    }
}

 

 

Categories:
I have the same question (0)
  • v-jefferni Profile Picture
    on at

    Hi @AlexanderC ,

     

    Could you please share more details about your scenario? Would you please share screenshots of you flow? I made a test with simple initialized variables and the Response action but everything works fine:

    vjefferni_0-1650871655136.png

    vjefferni_1-1650871719401.png

     

    Best regards,

    Community Support Team _ Jeffer Ni
    If this post helps, then please consider Accept it as the solution to help the other members find it

  • AlexanderC Profile Picture
    8 on at

    Hello,

     

    Thank you for your answer.

     

    Flow,

    AlexanderC_0-1650872337273.png

    AlexanderC_1-1650872397592.png

    Powerapp,

    AlexanderC_2-1650872583363.png

     

    The only fields that i can add to the collection is project_number and lables. How did you do to add name and comment?

     

    BR

     

     

     

  • v-jefferni Profile Picture
    on at

    Hi @AlexanderC ,

     

    I was using a Gallery. Seeing you are using a Data table to display the collection, so you will need columns just in the collection. Try below method:

    ClearCollect(col1,YourFlow.Run());
    ClearCollect(col2,AddColumns(col1,"Name",ThisRecord.labels.name,"Comments",ThisRecord.labels.comment))

    vjefferni_0-1650875841774.png

     

    Now you will be able to select all the three column in the Data table control.

     

    Best regards,

    Community Support Team _ Jeffer Ni
    If this post helps, then please consider Accept it as the solution to help the other members find it

  • AlexanderC Profile Picture
    8 on at

    Okay, seems like a bug or something in what the flow returns to power automate.

    Just created a exact copy of the flow, and its working. Then I´m able to add ThisItem.labels.name. Also seems like its easier to work with objects in gallery rather than datatable.

  • AlexanderC Profile Picture
    8 on at

    Thanks,

    The issue is in the flow, it doens´t return what it supposed to. I can´t check the ouput either since it´s created directly from powerApps and I can´t find the flow in powerAutomate. Have read about people that have the same problem and the solution seems to be export/import solution.. 

  • v-jefferni Profile Picture
    on at

    Hi @AlexanderC ,

     

    If your App is in a solution, the flow that created in the App will be in the same solution. You can go to the solution to find this flow. By the way, the Parse JSON action is not needed as you can parse JSON string in the Response action.

     

    Best regards,

    Community Support Team _ Jeffer Ni
    If this post helps, then please consider Accept it as the solution to help the other members find it

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
Kalathiya Profile Picture

Kalathiya 419

#2
WarrenBelz Profile Picture

WarrenBelz 397 Most Valuable Professional

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 345 Super User 2025 Season 2

Last 30 days Overall leaderboard