cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
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
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.

I get your point.

But flow is working correctly.

The collection in PowerApp is empty.

@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.

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
New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

Top Solution Authors
Top Kudoed Authors
Users online (34,504)