Power Automate: How to send SharePoint folder contents as attachments in Outlook email

Question

I'd like to do something very simple:

-- Select a folder in Sharepoint

-- Send the files in the folder as attachments to an email

A little more detail:

I'd like to select the folder in the document library and then, on the Show Actions menu (three vertical dots), select Automate > {myFlowName}

I go into Power Automate and select New > Automated-from blank > "Complete a custom action for the selected file".  This is how I initiate a variety of other flows.

From there, I know I need to verify that the selected file is actually a folder, and, if so, collect it's contents as attachments to an email.  I can find examples that are somewhat similar.  But they are different enough that I can't figure out how to adapt them to what I need.

Suggestions?

Thanks.

Answer 1

Dear Michael,

As the automatic flow has no folder connector action in SharePoint Online, the easiest way I suggest you is to use a list trigger as a workaround.

First create a list naming List for selected folder (for example) and create a folder content type in the site naming Folder for list 1 via the detailed steps in the article. Then add a column in the list List for selected folder naming Users who select the folder. Click on New to add a folder for the list with the folder content type>click on Edit form to enable the hidden Title column for the folder and add files as attachments in the folder.

The flow is created as follows.

Trigger the flow: When a new item in the list is modified. You can let users fill the values in the column Users who select the folder when selecting the folder in the list to trigger the flow.

Then the flow will get the attachments of the folder in the list to send an email with attachments automatically. You can also not use the folder and just use the list item with attachments as well.

However, if you want to trigger the flow in the folder in a library, you may write some custom expressions.

Here is an thread for your reference.

Best Regards,

Cliff

Answer 2

Dear Michael,

Welcome to share any updates when you have time if you need further help on this issue.

Best Regards,

Cliff