How can we use Power Automate to export attachments from SharePoint List item
Introduction Hi Friends, let us examine how we can use Power Automate to export attachments from the SharePoint List item. To explain the usage of this scenario, let us extend this Cloud Flow to send the attachments in Email. Perhaps you can use the same concept of exporting the attachments and do the following
Send the attachment over an email (will see in this post)
Store all the attachments in a document library.
Store all the attachments in an Onedrive folder.
Note The flow which I am gonna show you will use manual trigger but the same can be used with automatic triggers like When an item is added or modified etc. Focus on the Flow Consider a sample list with only the Title field and the attachments for the list has to be enabled. Add an item with a single or multiple attachments. Let us start designing the flow
Create an Instant cloud flow, give a unique name and select the trigger Manual trigger a flow
Add an action named Initialize Variable as an array to store all the attachments from a list item.
Get attachment content - The above action Get attachments will not return the contents, but it returns the File Identifier and other metadata information. Using File Identifier we can get the attachment content.
Append to array variable - Append the Attachment name and Attachment content in the below format as a JSON array. The format mentioned below should be as it is without changing the key names. The same format is expected in the email action which we will add below the Apply to each action.