How to store all attachments from a SharePoint list to one folder?

Kiriaki Kokona 5 Reputation points
2023-05-18T13:09:11.74+00:00

I need to store all the attachments of a Sharepoint list to a folder.

Microsoft 365 and Office | SharePoint | For business | Windows
0 comments No comments
{count} vote

3 answers

Sort by: Most helpful
  1. Yanli Jiang - MSFT 31,596 Reputation points Microsoft External Staff
    2023-05-19T08:36:12.41+00:00

    Hi @Kiriaki Kokona ,

    According to my understanding, you should store all the attachments of all items in a list into a SharePoint folder, right?

    If so, you can do it by using flow.

    Click Integrate-->Power Automate-->See your flows above the list to enter Power Automate.

    05191

    Click Create and select Instant cloud flow.

    05192

    Add a new step: Get all the attachments

    05193

    For each attachment, download the file content.

    05194

    Create a new file in your destination Folder.

    05195


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    2 people found this answer helpful.

  2. Yanli Jiang - MSFT 31,596 Reputation points Microsoft External Staff
    2023-12-13T06:42:34.43+00:00

    Hi @Kiriaki Kokona ,

    Great to know that and thanks for sharing the update here.

    By the way, since the Microsoft Q&A community has a policy that "The question author cannot accept their own answer. They can only accept answers by others.". and according to the scenario introduced here: Answering your own questions on Microsoft Q&A, I would make a brief summary of this thread:

    [How to store all attachments from a SharePoint list to one folder?]

    Issue Symptom:
    I need to store all the attachments of a SharePoint list to a folder.

    Current status:
    I have tried the solution and it works! One thing I would add (I am no Power Automate expert so that is probably why) is that you need one more step in the flow - 'For a selected item' to start it. Anyways, thank you for your help.Zrzut ekranu 2023-12-12 124436

    You could click the "Accept Answer" button for this summary to close this thread, and this can make it easier for other community members to see the useful information when reading this thread.

    Thanks for your understanding!

    0 comments No comments

  3. Douglas, David 0 Reputation points
    2024-05-20T20:18:56.3733333+00:00

    Hi, @Yanli Jiang - MSFT -

    I'm trying to do the same thing as the original poster, that is, to download ALL attachments from ALL items in a SharePoint list. I guess I'm not understanding exactly how to trigger this flow. When I use For a selected item as in your example above, I'm selecting the site address and the name of the list from which I want to get all attachments. When I save the flow, Power Automate changes the name of this triggering step to manual. I don't understand this, but it does seem to be the same trigger.

    User's image

    But then what? I don't see what actually makes the flow start running. I tried changing the trigger to When an item is created, and the flow worked, but all it did was download the attachment from this one new item. Again, I want to download ALL attachments from ALL items in the list.

    Thanks for your help.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.