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

54 answers

Sort by: Oldest
Most helpful Newest Oldest
  1. Anonymous
    2024-06-14T03:16:49+00:00

    Dear Lissa,

    Thanks for your updates and providing the screenshots for our reference.

    It seems that you use another way instead of Parse JSON to get the dynamic file id. You can just use the substring formula based on your data under Get file content (OneDrive for Business) to change the file names with Compose and then add them as attachments to the site list.

    Welcome to share any updates at your convenience.

    Thank you for your time and effort.

    Sincerely

    Cliff | Microsoft Community Moderator

    Was this answer helpful?

    0 comments
  2. Anonymous
    2024-06-14T04:30:00+00:00

    Thanks for that information. May I ask that you please be more explicit or kindly provide screenshots of your instructions?

    Are you saying?:

    • In flow #1, add a Compose action between the Apply to Each and Add Attachment actions
    • Add this formula to the Compose action - substring(items('Apply_to_each')?['name'],0,indexOf(items('Apply_to_each')?['name'],'_'))

    Please advise.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2024-06-15T02:25:34+00:00

    Dear Lissa,

    Thanks for your updates.

    Here is the screenshot for your reference.

    Compose: substring(items('Apply_to_each')?['name'],0,indexOf(items('Apply_to_each')?['name'],'_'))

    Compose2: substring(items('Apply_to_each')?['name'] , indexOf(items('Apply_to_each')?['name'],'.'), sub(length(items('Apply_to_each')?['name']),indexOf(items('Apply_to_each')?['name'],'.')))

    Welcome to share any updates at your convenience.

    Thank you for your time and effort.

    Sincerely

    Cliff | Microsoft Community Moderator

    Was this answer helpful?

    0 comments
  4. Anonymous
    2024-06-24T02:59:09+00:00

    Thanks but the original filename is not being maintained as my name and a number is still being added the filename of the uploaded files.

    Was this answer helpful?

    0 comments
  5. Anonymous
    2024-06-25T02:52:05+00:00

    Dear Lissa,

    What's output in the Compose action in your environment? Could you upload some related screenshots for our confirmation if you need further help on the flow you created?

    Note: Remove any private information before uploading the screenshots.

    Thank you for your time and effort.

    Sincerely

    Cliff | Microsoft Community Moderator

    Was this answer helpful?

    0 comments