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: Most helpful
  1. Anonymous
    2024-05-03T15:45:36+00:00

    Hello,

    Thanks for your response. The items('Apply_to_each') formula appears to be applied as noted. Please see the below

    Filter Array

    Please specify what you mean by "check whether you put the right filter array outcome into each Apply_to_each part." What should I be checking for exactly? What would be the right filter array? Are you referring to the Body selection for the From field? Please clarify.

    This is what I have:

    Filter Array 2

    From = body('Filter_array')

    Filter Array 3

    From = body('Filter_array_2')

    Filter Array 4

    From = body('Filter_array_3')

    Thanks

    Was this answer helpful?

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

    Appreicate your assistance in reviewing. Please see the below.

    Thanks

    Was this answer helpful?

    0 comments No comments
  4. 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 No comments
  5. 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 No comments