If you are using SharePoint and FLOW for the approval process, then as an approver, you might want to see the attachments as well, in the email itself. This will help to take the decision quickly from mailbox itself without a need to open the item in SharePoint.
In today's blog, we will see how to extract the list item attachments and send them as email attachments from FLOW.
- Login to here.
- Click on My Flows - Create New Flow from blank - You can use “When an Item is created or modified” trigger.
- For now, we will use “Manually trigger a flow” for testing purposes. Add the next step as “Get Item” from SharePoint (get the item from which you want to extract the attachments).
- Initialize a new array variable as AttachmentsArray.
- Let’s fetch the attachment from the above list item.
- Add new action “Get Attachments” - Provide site, list name and Item ID details same as "Get Item".
- Now, we need to extract the content of each attachment and save it in our array variable AttachmentsArray
- Add new action as “Get Attachment Content” - Provide site, list name, and Item ID details same as "Get Item". In addition to these, provide file identifier Id from the output of “Get attachments” action.
- Add a new action “Append to array variable”. To save the content of each attachment in an array variable, you can type the below formula in the expression window.
- Add any send email action which suits your requirement. In my case, I have selected “Send email with options”. In the "Attachments" field, as shown below, select the array variable which we have created.
That’s it. You are ready to test the flow now. Create a SharePoint list item with attachments added to it. Run the flow to get that item and check your mailbox. You must receive an email with attachments from the selected list item.
Refer to the below screenshot with all the actions included in a sequence.
Hope this helps you some way.