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-05-13T15:47:09+00:00

    Thank you so much for that information. I tested by completing the form and got the below. Everything above has a green check, the Apply to Each and Create File actions have a red x, and everything below these 2 actions has a gray x. Please advise. Thanks.

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2024-05-07T05:45:59+00:00

    Dear Lissa,

    Thanks for your updates.

    The screenshots you uploaded seems not to be showed fine at our side.

    Could you upload it again for our reference?

    From your previous screenshots, it seems that the file name you select in your flow isn't from the result of Parse JSON.

    Could you change that part and see if the flow can be saved successfully at your side?

    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-05T20:56:48+00:00

    Thank you for helping me with that information. I chose the first body option seen in the Dynamic Content options. I did not know it needed to be the same. I've made the updates as directed.

    I saved the flow and received the following 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
  4. Anonymous
    2024-05-04T03:44:44+00:00

    Dear Lissa,

    The following configuration seems to be wrong in your environment.

    Filter Array 2

    From = body('Filter_array')

    Filter Array 3

    From = body('Filter_array_2')

    Filter Array 4

    From = body('Filter_array_3')

    You need to filter all files with different names from the original filter array.

    So the configuration should be the following.

    Filter Array 2

    From = body('Filter_array')

    Filter Array 3

    From = body('Filter_array')

    Filter Array 4

    From = body('Filter_array')

    I suggest you change it and see whether you can save and run the flow successfully.

    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-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