cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
cbernier12
Resolver II
Resolver II

Collection values pulled from Power Automate do not show in gallery

Hi

 

Any run into an issue where collection values pulled from Power Automate flow do not show in a gallery?  I see all the data in the collection when I select the Values icon, however not of that data show's up in the gallery.  Anyone know how to get the actual column values to show up in a gallery or datatable?

27 REPLIES 27

@Pstork1 I'm not seeing an array property.  In Flow I use an HTTP action to query Microsoft Graph then parse that output in a Parse JSON action, where I tried to use the schema, however it fails with "message""Invalid type. Expected Array but got Object." when I test the Flow.

In your original schema that you posted for the object returned by the graph you listed this:

{
    "type": "object",
    "properties": {
        "@@odata.context": {
            "type": "string"
        },
        "value": {
            "type": "array",
            "items": {

The property 'value' is of type 'array'.  That is what you need to isolate and send back to Power Apps.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

@Pstork1 yeah I tried that.  I doesn't look like it's going to work.  The columns make it to a collection, however the data does not.  So maybe it's just not supported.

 

{
    "type""array",
    "items": {
        "type""object",
        "properties": {
            "id": {
                "type""string"
            },
            "deviceName": {
                "type""string"
            },
            "enrolledDateTime": {
                "type""string"
            },
            "manufacturer": {
                "type""string"
            },
            "model": {
                "type""string"
            },
            "serialNumber": {
                "type""string"
            }
        }
    }
}

Are you using the respond to power apps or the HTTP request response action to return the data?  The respond to power apps can't return an array only simple data.  If you are using the request response make sure you add the appropriate JSON schema to that action under advanced or you won't get the data.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

@Pstork1 see image.  Columns are created in the collection2020-08-31_10-58-59.jpg, however no data is sent to the collection.

You can't load the Body in as Input.  That contains more than the array required and doesn't match the schema.  You need to isolate the value array and send that back.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

@Pstork1 humm, ok, HTTP dynamic content only offers "Body, Headers, and Status Code".  How do I isolate it and what do I add as the Body?

You may have to do a Parse Json on the full body so that you can get at the array inside.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

@Pstork1 yes tried that too, only the columns are added to the collection, no data is populated in the columns though.

 

2020-08-31_12-11-34.jpg

If you feed the Body of the JSON into the Parse that should surface the properties in the JSON.  But then you have to use those properties, not the Body when doing the return.  You are still passing the body.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (1,709)