Where is the OneDrive File URL?

[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

[Brad_Groux]

See the Create share link to path (OneDrive for Business) action or the Create share link (OneDrive) action. Both provided a Web URL string called SharingLink.

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!