Create manually triggered flow for SharePoint list item to download all attachments to target folder (One Drive)

[DirkKoch]

Dear all, 

I would like to manually trigger a Power Automate flow for a selected SharePoint list item. The flow is supposed to download and transfer all attachments for this selected item to a target folder (e.g. OneDrive folder).  Furthermore each attachment should have the reference/item number included in its naming. The goal is to allow a search for all attachments linked to one reference/item number (see also example attachment -> reference number 12345678 linked to all attachments in this dataset).

Can somebody give me a detailed step by step instruction of how to create such a flow which can be manually triggered directly from this SharePoint Site for each selected dataset!?

Thank you in advance!

[grantjenkins · Accepted solution]

Hopefully this is what you are after. I wasn't sure if you also wanted to create a folder using the Barcode Number in addition to prefixing the file names but have done that here. If you didn't want the folder, then you can just create the files directly into your destination folder that already exists.

The source list in SharePoint for this example has three attachments.

And the destination folder in OneDrive is:

The full flow is below. I'll go into each of the actions.

For a selected item is setup for the source list in SharePoint so you can select an item and trigger the flow.

Create new folder will create a folder in OneDrive using the fileName from the trigger.

Since we are using the Title column for our Barcode Number, we can just use fileName from the trigger. If we wanted to get data from another column, we would need to use a separate Get item action, but no need here.

We use Get attachments to get the attachments associated with the list item.

Next, we setup an Apply to each to iterate through each of the attachments.

Get attachment content gets the actual content we need to create each attachment file.

Finally, we use Create file to create the attachment file in the folder we created earlier in OneDrive and prefix each file with the Barcode Number using fileName from the trigger.

The final output in this example is below.

[DirkKoch]

@grantjenkins Thanks a lot for your detailed reply. I followed all your steps, but I experience some issues when finally running the flow. 
There is an error occurring when running the action "Get attachments" saying that "the item/element is not existing. It might have been deleted by another user. clientRequestId: 0982b9a6-089a-42df-b5cc-a1fa818095b3
serviceRequestId: 921973a0-8079-5000-340d-4a21e2e85e3a???

I think there is some issues with the variable "ID". Some datasets have been deleted priorily, so the ID of the dataset of which I ran the flow is 86 but in the flow is shows ID 2 (see attached Screenshot).

[grantjenkins]

The ID you should be using for the Get attachments will be from the trigger For a selected item. It looks like you're using the ID from the Create new folder action which is why it's failing.

[DirkKoch]

@grantjenkins my mistake.  Now it works just fine. Thanks a lot!