cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sperry1625
Solution Supplier
Solution Supplier

Email Attachments as Links

I have a flow that sends out email notifications as one of it's steps.  In certain circumstances the flow will generate a file that is to be included in the notifications.

This is a multi-part problem...

  1. In one path I need to generate an Excel file that has a single table with one row in it.
  2. In a second path I will generate a flat file.

I have been able to generate the Excel file but have realized that the Excel calls are Asynchronous. And since I need to attach the file to the email notification, as well as to a SharePoint list item, I need to load the content of the file after I create it.  There is a chance that the file will not have completed my updates by the time I load it's contents. To get around this I was considering adding a link to the file in SharePoint instead of physically attaching the file. Thus eliminating the concern of update delays in the file updates. But how do I do that? I know I can embed a URL in the body of the email to the file I created. But how do I add a link to the file in the document library as an attachment in the email notification?

SIDE NOTE: While on the subject, other than putting in a false "Delay" in the flow after I call the Excel Add a Row action, is there any way I can detect that my update was actually completed before I load it's contents?  I tried adding Check In/Check Out but still ran into issues of the content not always reflecting my change.

Second path is easy as I do not have the asynchronous issue.  But how I send the file out needs to be consistent.  So the same question applies, how do I include a link to the file as an attachment?

 

Thanks.

 

-S

Regards,

-S

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

1 ACCEPTED SOLUTION

Accepted Solutions
fchopo
Super User
Super User

Hello @sperry1625 

After creating the file, you can add an attachment file and its content when using the "Send an Email (v2)" action:

documentlink.png

 

I tried to use "DocumentLink.url" as Attachment Name, but Outlook filters that file extension, so I used "txt".

Hope it helps!

Ferran

 

Did I answer your question? Please consider to mark my post as a solution to help others.
Proud to be a Flownaut!

View solution in original post

1 REPLY 1
fchopo
Super User
Super User

Hello @sperry1625 

After creating the file, you can add an attachment file and its content when using the "Send an Email (v2)" action:

documentlink.png

 

I tried to use "DocumentLink.url" as Attachment Name, but Outlook filters that file extension, so I used "txt".

Hope it helps!

Ferran

 

Did I answer your question? Please consider to mark my post as a solution to help others.
Proud to be a Flownaut!

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Users online (2,892)