Power Automate - Building Flows

Answered

Link of attachment in Sharepoint list contents spaces

Like (0) Share

Report

Posted on 20 Feb 2024 18:02:45 by Paulo44

Hi there,

I try to retrieve the links of the attachments I have in a Sharepoint List to put in an email.

My problem is that the name of the list where my attachments are has spaces in it, and therefor, when the link is in the email, it is not complete...

I don't want to change the name of the list, because there are a lot of other things attached to it.

Flow PowerAutomate02.PNG

This is the result I get:

Flow PowerAutomate04.PNG

Is it possible to replace these spaces to have a complete link ?

Thank you for the help...

I have the same question (0)

Summarized by AI

All responses (2)

Answers (1)

Paulo44 on 21 Feb 2024 at 07:27:16

Like (0)

Report

Re: Link of attachment in Sharepoint list contents spaces

Great, this solution is what I needed.
Thanks for this.

For your suggestion to put the attachments directly in the mail, it can not be implemented for my case, because I am limited in the number of attachments (company's policy), and the sharepoint list from where the attachments come can contain up to 35 attachments, which is way to much. Therefor I have to use the links to these attachments...
Thanks anyways...

Was this reply helpful? Yes No

Verified answer

creativeopinion

10,480 Super User 2025 Season 2 on 20 Feb 2024 at 19:32:15

Like (0)

Report

Re: Link of attachment in Sharepoint list contents spaces

@Paulo44 You could Compose a link using HTML

Alternatively, you can attach the attachments to your email. I cover how to do that in this YT Tutorial: How to Send SharePoint List Attachments 📎 via Email with Power Automate

Please note: I'm using the Classic Designer in this tutorial—the new one still has a few bugs.

In this Microsoft Power Automate tutorial, I’ll cover how to create a Power Automate flow to send SharePoint list attachments in an email.

This flow will check the SharePoint list to see if an item is marked as Ready to Send and has attachments. I will also cover how to combine multiple attachments to send in a single email.

IN THIS VIDEO:

✅ How to attach a single SharePoint list attachment to an email

✅ How to use the Filter Query to Filter SharePoint List Items by a Single Choice Column

✅ How to use the Filter Array action to Filter SharePoint List Items that have an Attachment

✅ How to use turn on Pagination and Set a Threshold in the Get Items action

✅ How to us the Top Count field in the Get Items action

✅ How to use the Get Attachments Action

✅ How to avoid the Apply to Each Action

✅ How to use the Get File Content Action

✅ How to Edit an Expression

✅ How to use the Compose Action

✅ How to Get Multiple SharePoint Attachments

✅ How to use the Append to Array Variable Action

Hope this helps!

If I helped you solve your problem—please mark my post as a solution ✅.
Consider giving me a 👍 if you liked my response! If you're feeling generous— ☕️ Buy me a coffee: https://www.buymeacoffee.com/acreativeopinion

👉 Watch my tutorials on YouTube
👉 Tips and Tricks on TikTok