cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Super User
Super User

Where is the URL for a OneDrive File?

Hello,

I'd like to send an automated email that includes the URL of a file in my OneDrive folder. Unfortunately, I cannot find the URL of the file in Flow. 

What I have so far:

  • Trigger: Recurrance (every day)
  • Action1: Get File Metadata (file.xlsx)
  • Action2: Get File Content
    • Set to Dynamic Content: id from Action1
  • Action3: Send an Email
    • In the Body field, I'd like to include the URL to file.xlsx

Issue:

  • No values from the Get File Metadata action show the URL

Please advise on where I can get this so my users can open the file directly from the email by clicking the URL and using Excel Online.

Thank you

1 REPLY 1
Highlighted
Super User III
Super User III

Re: Where is the URL for a OneDrive File?

@ericonline :

Here are two options:

  • You can manually build the URL and insert the filename with extension which is available via Dynamic properties.
  • You can use the Create share link by path action which does generate a URL accessible via Dynamic properties

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

Helpful resources

Announcements
firstImage

Super User Program Update

Three Super User rank tiers have been launched!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Users online (8,537)