Where is the URL for a OneDrive File?

[ericonline]

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

[ScottShearer]

@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