Hi! I'm really dumbfounded about this seemingly simple question, I haven't found an answer on Google or these forums so here it goes.
How can I get the "relative path" or "path" for a SharePoint file using only the URL you get by right-click + "copy link"´?
Basically, I need to go from this: https://mysite.sharepoint.com/:x:/s/ExampleSharepointSite/EcubcEpU-5pEnFmhMrKVzwUB8y6DyZwsBmMSeMBdHhxnHQ?e=goOpUa
to this: /Shared Documents/Test Folder/some-random-document.xlsx
I'm really confused.
@EZuniga did you figure out how to solve this? I have a similar issue where I want the user to get the folder path of a shared folder link (as opposed to a shared single file link).
Hi! First of all, just to be clear because it confuses me a little too, I'll refer to the examples as following
Share link = https://mysite.sharepoint.com/:x:/s/ExampleSharepointSite/EcubcEpU-5pEnFmhMrKVzwUB8y6DyZwsBmMSeMBdHhxnHQ?e=goOpUa
File Path = /Shared Documents/Test Folder/some-random-document.xlsx
With that out of the way... The problem is that I don't have a file path to begin with 😕 the trigger to this flow is a forms response, and in one of the answers the users copy and paste the share link to said file.
I tried using the Get File properties and Get file metadata but it expects me to input the file path or identifier... which I can't figure out how to parse just out of the share link.
Is there a way to use those actions with JUST the share link?
Thank you so much
I don't actually have the time right now, but I looked into this a while back, @EZuniga ... if you can't actually use something like the render list items as a stream API endpoint, you could setup any given list to save that url in a hidden column.
I do think that the data is kept somewhere accessible, though ... take a look at this API explorer, perhaps?
@EZuniga You'll need to use the Full Path dynamic content from the Get File properties action.
Or, if you are using the Get file metadata action, you'll need to use the Path dynamic content.
Hope this helps!
For more flow troubleshooting tips—check out this YT Tutorial: 5 Power Automate Troubleshooting FAQs and Helpful Tips for Creating Better Flows
In this tutorial I cover:
✅ How to troubleshoot a false Condition action result
✅ How to get dynamic content when it isn’t selectable from the list of dynamic content
✅ How to troubleshoot an Apply to Each action that isn’t looping through
✅ How to troubleshoot a skipped Apply to Each action
✅ How to troubleshoot a Filter Query
✅ How to use a SharePoint yes/no column in a Filter Query
✅ How to use Compose actions to troubleshoot a Power Automate flow
✅ How to troubleshoot multiple emails being sent
✅ How to troubleshoot multiple Teams messages being sent
WarrenBelz
146,780
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
66,093
Most Valuable Professional