Attach file to email from a link in a list.

[Leo_NYC]

Hi there....

I have a list with two columns that contain links to files.  I am trying to write a flow that will attach the underlying files referenced by those links as attachments.

Is there a way to get the file contents from the link and then attach them to the email?

Thanks!

Leo

[leyburn19]

 Is the link to files in another list or document library or are they simple attachments to the list record? 

[v-chenzhi · Accepted solution]

Hi @Leo_NYC ,

Do you want to send the file in the link as an attachment in mail?

I assume you have two columns like this in SharePoint and have a test on my side, please try the following workaround.

The flow like this.

Here is the expression:

last(split(items('Apply_to_each')?['Column1'],'.'))

We could see this in outlook.

Best Regards,

Zhi Chen

[Leo_NYC]

Thanks!  I got it working a little differently but pretty much the same way.

I used the URI path function to grab the entire html link to the file from the list.

Then I passed the result in to a split function, split it in two to separate the site information from the path, and referenced the second member of the array.

After that I used the get file content by path function and was able to attach it...

thanks again!