Power Automate – Get attachments in SharePoint list item and send to email

Attachments can be stored in an item of a SharePoint list. In Power Automate, we can get the attachment contents and send them through email. Proceed with this blueprint to find out how.

Step 1:

Create an Instant cloud flow with manual trigger.

Step 2:

Add Initialize Variable.

Name

varAttachmentsArray

Type

Array

Note: Leave the Value field blank.

Step 3:

Add Get attachments (SharePoint)

Site Address

[Site where 'Employee Files' is located]

List Name

Employee Files

Id

1

Note: In this demo, since we only have one row in our list that has an ID of 1, we hard code the ID field to 1.

Step 4:

Add Get attachment content (SharePoint)

Site Address

[Site where 'Employee Files' is located]

List Name

Employee Files

Id

1

Note: Leave the File Identifier field blank for now. We will do this in the next step.

Step 5:

In the same action (Get attachment control), fill out the remaining field.

File Identifier

ID

Note: Once you put in the dynamic content in File Identifier field, an Apply to Each will automatically enclose the current action.

Step 6:

Inside the ‘Apply to Each’, add Append to array variable.

Name

varAttachmentsArray

Value

{
  "ContentBytes": @{body('Get_attachment_content')},
  "Name": @{item()?['DisplayName']}
}

Note: Copy the code above and paste it to the field. Once pasted, it will look like something below:

{
   “ContentBytes”:

Body

,
   “Name”:

DisplayName

}

Step 7:

Outside of ‘Apply to Each’, add a ‘Send an email (V2)’ (Outlook).

To

[Your user profile or your email address]

Subject

Employee Files

Body

Hello!
Please see attached for the employee files of Zephyr Amihan Dela Torre.

Step 8:

On the same action (Send an email (V2)’), Click ‘Show advanced options’.

Step 9:

On the same action (Send an email (V2)’), Click on the ‘Switch to input array’ button. This will convert the section from a list of items into one field to input the array.

Step 10:

Inside the attachments field, insert a dynamic content for the variable named varAttachmentsArray:

Attachments

varAttachmentsArray

Save and test the flow. Once the run is successful, you should receive an email containing the two attachments that was inside of the specified SharePoint list item.