cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Resolver I
Resolver I

Embedded Canvas Apps for SharePoint Documents

Hi,

 

I am trying to get documents of SharePoint from Flow to Canvas App.

So I have created Flow, filtered Document Location, got the documents uploaded for the record in flow and passing that data to PowerApps using Response to PowerApps.

 

I am able to call flow from PowerApps but not able to access collection data which came from PowerApps.

community15_1.png

 

This is the json 

{
    "type": "object",
    "properties": {
        "d": {
            "type": "object",
            "properties": {
                "__metadata": {
                    "type": "object",
                    "properties": {
                        "id": {
                            "type": "string"
                        },
                        "uri": {
                            "type": "string"
                        },
                        "type": {
                            "type": "string"
                        }
                    }
                },
                "Files": {
                    "type": "object",
                    "properties": {
                        "__deferred": {
                            "type": "object",
                            "properties": {
                                "uri": {
                                    "type": "string"
                                }
                            }
                        }
                    }
                },
                "ListItemAllFields": {
                    "type": "object",
                    "properties": {
                        "__deferred": {
                            "type": "object",
                            "properties": {
                                "uri": {
                                    "type": "string"
                                }
                            }
                        }
                    }
                },
                "ParentFolder": {
                    "type": "object",
                    "properties": {
                        "__deferred": {
                            "type": "object",
                            "properties": {
                                "uri": {
                                    "type": "string"
                                }
                            }
                        }
                    }
                },
                "Properties": {
                    "type": "object",
                    "properties": {
                        "__deferred": {
                            "type": "object",
                            "properties": {
                                "uri": {
                                    "type": "string"
                                }
                            }
                        }
                    }
                },
                "StorageMetrics": {
                    "type": "object",
                    "properties": {
                        "__deferred": {
                            "type": "object",
                            "properties": {
                                "uri": {
                                    "type": "string"
                                }
                            }
                        }
                    }
                },
                "Folders": {
                    "type": "object",
                    "properties": {
                        "__deferred": {
                            "type": "object",
                            "properties": {
                                "uri": {
                                    "type": "string"
                                }
                            }
                        }
                    }
                },
                "Exists": {
                    "type": "boolean"
                },
                "IsWOPIEnabled": {
                    "type": "boolean"
                },
                "ItemCount": {
                    "type": "integer"
                },
                "Name": {
                    "type": "string"
                },
                "ProgID": {},
                "ServerRelativeUrl": {
                    "type": "string"
                },
                "TimeCreated": {
                    "type": "string"
                },
                "TimeLastModified": {
                    "type": "string"
                },
                "UniqueId": {
                    "type": "string"
                },
                "WelcomePage": {
                    "type": "string"
                }
            }
        }
    }
}

 

I am collecting the response from Flow in PowerApp using this ClearCollect:

 

ClearCollect(AllDocuments, 'Retrievedocumentforeachrecord.'.Run(BrowseGalleryObjectives.Selected.Objective))

 

This is collection which I am getting.

 

community15_2.png

 

Any help is appreciated.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Resolver I
Resolver I

The problem is solved,  It is working after I deleted the flow connection.

View solution in original post

4 REPLIES 4
Highlighted
Super User III
Super User III

Hi @tjalui ,

The response from a Flow is a pure Power Automate issue - you are welcome to post here, but I suggest you will get a quicker and more complete answer from experts over in the Power Automate Community.

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Highlighted

I get your point.

But flow is working correctly.

The collection in PowerApp is empty.

Highlighted

@tjalui ,

I will leave it for others to answer here, but the point I was making is that the return value to Power Apps is the Response from the Flow, so the specifications of that have to be correct for Power Apps to get the required data.

Highlighted
Resolver I
Resolver I

The problem is solved,  It is working after I deleted the flow connection.

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Community Highlights

Community Highlights

Check out the Power Platform Community Highlights

Top Solution Authors
Top Kudoed Authors
Users online (3,456)