cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DavidForlen
Advocate II
Advocate II

Get a SharePoint file from sharing link or url

Hi,

 

Here is what I'm trying to do :

  1. From a PowerApps, a user click a button on a specific line of data from SQL Server. This line contain an url (a sharing link or a url like "https://emc13.sharepoint.com/sites/VidyaSiteBasedLogging/SP_Document_library/folder/folder/Document.... of a file from SharePoint.
  2. The id of the SQL Server row is sent to a Flow. So that the Flow can also access the url of the file.
  3. The Flow must take the file from SharePoint, convert it to PDF and save the link of the PDF to the corresponding column in SQL Server.

 

The problem is that I can't find a way to get the file content (or name) from the link, in either Power Automate or PowerApps.

 

If I could use the function "Launch" or "Download" of PowerApps to pass the content of the file to Flow, it wouldn't be a problem.

 

I must also be able to detect if the link doesn't work (if the SharePoint file was renamed or deleted), and prompt the user to provide a functionnal link.

 

Any idea ?

 

Thanks.

5 REPLIES 5
yashkamdar
Solution Sage
Solution Sage

Hello Team,

 

This is pretty easy !!

 

What you need to do is Create a STRING type variable and set that variable with the link that you have, then use the action GET FILE CONTENT USING PATH and as an input to this action, pass the Variable value.

 

yashkamdar_0-1599828669824.png

 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

 

Thanks a lot !

 

I didn't realize that I could put the whole URL in the File Path.

 

This works for URL with path like (https://emc13.sharepoint.com/sites/VidyaSiteBasedLogging/SP_Document_library/folder/Document.docx).

But not with sharing link, I get the following error : "URL is not for this web\r\nclient".

 

I hope it's possible to access files with sharing link as well as "path" link. As I can't expect my users to update the link with anything else than the sharing link. Constructing the "path" link is too tedious not to be automated.

 

I am still confronted with the same problem with a sharing link.

 

Does anyone have a solution?

gteibo
Frequent Visitor

do you already have a solution for this? I'm looking for the same.

 

 

W_Rocketpilot
Regular Visitor

Same issue here. I'm looking for a solution to get this problem fixed.

Helpful resources

Announcements
 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Users online (2,440)