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: Newest
Most helpful Newest Oldest
  1. Anonymous
    2024-05-03T04:37:47+00:00

    Dear Lissa,

    Thanks for your updates and screenshots.

    The flow structure seems to be fine.

    Could you click on each items('Apply_to_each') formula in each part of the Create file action and see whether you put the items('Apply_to_each') code under the correct parent Apply_to_each action in your environment?

    In Create file, it may be the following.

    items('Apply_to_each_2')?['Name']

    items('Apply_to_each_2')?['Content']

    In Create file 2, it may be the following.

    items('Apply_to_each_3')?['Name']

    items('Apply_to_each_3')?['Content']

    In Create file 3, it may be the following.

    items('Apply_to_each_4')?['Name']

    items('Apply_to_each_4')?['Content']

    Moreover, check whether you put the right filter array outcome into each Apply_to_each part.

    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
  2. Anonymous
    2024-05-03T01:28:37+00:00

    Appreicate your assistance in reviewing. Please see the below.

    Thanks

    Was this answer helpful?

    0 comments
  3. Anonymous
    2024-05-01T02:58:42+00:00

    Dear Lissa,

    Thanks for your updates and kindness.

    From the message, it seems that you don't put the items('Apply_to_each') code under the correct parent Apply_to_each action in your environment.

    For example, items('Apply_to_each_1') must be put under Apply to each 1 and items('Apply_to_each_2') must be put under Apply to each 2 and so on.

    I suggest you check your flow at your side.

    If it is convenient, you can upload the full screenshots of the flow and expand it with details for our confirmation and we'll try to see what actions are put wrongly in your flow.

    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
  4. Anonymous
    2024-04-30T18:29:59+00:00

    Thanks for specifying the code should be entered under the Expression tab.

    I'm seeing the following error message:

    Flow save failed with code 'InvalidTemplate' and message 'The template validation failed: 'The inputs of template action 'Append_to_array_variable' at line '1 and column '3663' is invalid. Action 'Apply_to_each' must be a parent 'foreach' scope of action 'Append_to_array_variable' to be referenced by 'repeatItems' or 'items' functions.'.'.

    Kindly advise. Thanks.

    Was this answer helpful?

    0 comments
  5. Anonymous
    2024-04-30T05:21:35+00:00

    Dear Lissa,

    Thanks for your updates and kindness.

    Here are the answers of the question.

    1. If you use the OneDrive for Business site address, you can select Enter custom value and type the OneDrive for business site URL such as https://contoso-my.sharepoint.com/personal/username\_contoso\_onmicrosoft\_com.

    1. You need to click on Expression to type the code.

    1. For Filter Array code, you need to click on Edit in advanced mode to type the code.

    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