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

Re: Embedded Canvas Apps for SharePoint Documents

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

Re: Embedded Canvas Apps for SharePoint Documents

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
Resolver I
Resolver I

Re: Embedded Canvas Apps for SharePoint Documents

I get your point.

But flow is working correctly.

The collection in PowerApp is empty.

Highlighted
Super User III
Super User III

Re: Embedded Canvas Apps for SharePoint Documents

@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

Re: Embedded Canvas Apps for SharePoint Documents

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

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Watch Now

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (7,777)