Power Platform Community Forum Thread Details

I'm building an App in PowerApps, and I would like to associate files in an SP Doc library to an item in an SP List. The intent is to get the URL of a Doc that has been copied into an SP Doc library, and then insert that URL into a column in an SP List.

Here's the scenario:

The User needs to make a purchase request, which requires getting an approval from a Manager. This is to be done using PowerApps where the User will fill in a "form", and the data gets captured in related Sharepoint lists.

In addition to the above, the User needs to "attach" docs. Which in this case would be quotations received from vendors. These "attached" docs need to be "private", only visible to the person who submits the request, and the person(s) to whom the request is being submitted to.

So I was thinking along the following lines:

1. User fills in "Form" in PowerApps.

2. User copies file ("attachment") to their own Onedrive for Business, which triggers a Flow to copy the file to a SP Doc library where only the User and Manager have access permissions.

3. I then need to be able to retrieve the URL of the doc in this SP Doc library, so that it can be entered into the SP List record for the specific purchase request.

So how do I retrieve the Doc URL, once Flow copies the file from OneDrive for Business to the SP Doc library, and can this be the same Flow so i have the Record ID for the associated record in the SP List?

Any help with this will be greatly appreciated

Categories:

Building flows

Hi UB400,

About #3 “I then need to be able to retrieve the URL of the doc in this SP Doc library, so that it can be entered into the SP List record for the specific purchase request”, I am afraid it cannot be achieved currently.

When creating a flow to create an item in SharePoint list when a file is created in SharePoint library, I found that there is no dynamic content for the URL of the documentation.

As currently, there are only several dynamic contents for the trigger “SharePoint – When a file is created” can be selected.

I haven’t seen a related idea on Flow Ideas Forum, please consider to create a new one at Flow Ideas Forum. PGs will check it and take it into consideration in the future release. I will also collect and report this from my side.

Best regards,
Mabel Mao