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: Oldest
  1. 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
  2. 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
  3. 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
  4. 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
  5. Anonymous
    2024-05-14T07:04:43+00:00

    Dear Lissa,

    Thanks for your updates.

    The Filter Array action seems to run successfully in your environment. Could you check whether some file name and file content is got from the action at your side?

    If the output is null such as [ ], the Create file action will got no parameter to create the file and will run with failure.

    If it is convenient, could you also upload some screenshots showing the detailed error pane in the Create file action at your side for our reference as well?

    Note: Remove any private information before uploading the screenshots.

    Thank you for your effort and time.

    Sincerely

    Cliff | Microsoft Community Moderator

    Was this answer helpful?

    0 comments No comments