How to auto separate MS Lists uploads into separate Sharepoint folders using Power Automate?

Anonymous
2024-04-09T20:38:05+00:00

Hello,

Just realized that MS Lists only allows 1 column for attachments (though allowing multiple attachments). The problem is, I was trying to create multiple columns so the attachments can be added by category.

Since I can't categorize multiple columns, I need to be able to separate the attachments into categorized folders once they are uploaded but I want to do this automatically.

How do I use Power Automate to grab the attachments and place each file in separate SharePoint folders? Thanks!

Lissa

Microsoft 365 and Office | Install, redeem, activate | For business | Other

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

54 answers

Sort by: Newest
  1. Anonymous
    2024-06-06T02:44:35+00:00

    Trying different methods of copying and pasting the screenshot. the 2nd attempt shifted the images. Let me know if this is visible and clear.

    Thanks

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2024-06-06T02:35:23+00:00

    Sorry about that I don't know why that is happening. Please let me know if this is visible.

    What I am trying to do:

    1. Add the data and attachments from the MS Form to the SharePoint List using automation.
    2. The attachments uploaded to the MS Form, which are also being added to the SharePoint List, need to be added to a Document Library and separated into folders according to the name contained in the file.

    What has been accomplished:

    The data and attachments from the MS Form are being added to the MS List by the automation.

    What needs to be accomplished:

    The attachments are not being added to the Document Library.

    Please review the above flow and advise. Note: Filter Array 1 is cut off in the screenshot but it has - replace(item()?['Name'], '_', ' ')

    Thanks

    Was this answer helpful?

    0 comments No comments
  3. Anonymous
    2024-06-06T01:35:33+00:00

    Dear Lissa,

    Thanks for your updates.

    The screenshots seem not to be uploaded fine. They are showed as follows at my side.

    The Forms attachments will not automatically be added to the SharePoint Online list. If you are using a personal form, the attachments will be saved in the folder in OneDrive for Business.

    If you are using a group form, it will be saved in the folder in SharePoint Online.

    Do you mean that you want to aa them to the list as attachments?

    Regarding "how can this be accomplished? The data and attachments are being added to the SharePoint List but the attachments are not being added to folders in the SharePoint library. What's missing?", where are the attachments added after running the flow? Could you upload some screenshots for our confirmation? Are there some error messages popped up when you run the flow you created?

    Note: Remove any private information before uploading the screenshots.

    Welcome to share any updates at your convenience.

    Thank you for your effort and time.

    Sincerely

    Cliff | Microsoft Community Moderator

    Was this answer helpful?

    0 comments No comments
  4. Anonymous
    2024-06-05T23:47:42+00:00

    Thanks for that explanation. Here's what I'm trying to do:

    1. Use MS Forms to collect the needed data and attachments then automatically have the MS Form data and attachments be added to a SharePoint List.
    2. The attachments also need to be added to a SharePoint library and separated into corresponding folders according to what is contained in their file name.
    3. The file attachment names need to keep the same file name they were uploaded with and NOT include my name at the end. The file attachments should also have the ability to be previewed from within the Sharepoint library.

    Looking at the flow below, how can this be accomplished? The data and attachments are being added to the SharePoint List but the attachments are not being added to folders in the SharePoint library. What's missing?

    Sorry, the flow reverted to the old designer and the toggle isn't working to get it back to the new designer. With this toggle issue, something seemed to have changed in my flow and It stopped working correctly and I had to start again. Please forgive me.

    Thanks,

    Was this answer helpful?

    0 comments No comments
  5. Anonymous
    2024-06-01T05:42:39+00:00

    Dear Lissa,

    Thanks for your updates.

    Based on your previous description, you use Microsoft Forms to upload the attachments and category the attachments to the corresponding folders in the library in OneDrive for Business and SharePoint Online, so you don't need to involve the Microsoft List related connectors unless that you want to do something in Microsoft List or the SharePoint Online list.

    The screenshots you copied from my previous replies are to get the uploaded attachments and category them to the folders in SharePoint Online.

    Welcome to share any updates at your convenience.

    Thank you for your effort and time.

    Sincerely

    Cliff | Microsoft Community Moderator

    Was this answer helpful?

    0 comments No comments