How to auto separate MS Lists uploads into separate Sharepoint folders using Power Automate?

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.

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

Appreicate your assistance in reviewing. Please see the below.

Thanks

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

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