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

Dear Lissa,

Thanks for your updates.

I create the flow based on the example of your previous posts.

Move the following attachments to the folder Category Blue automatically.

1. Category_Blue_Jane
2. Category_Blue_Jon
3. Category_Blue_Jen

The Initialize Variable action can create the file array if you have uploaded multiple attachments to the form. No matter single attachment or the multiple attachments, the Append to array variable can create an array for all uploaded files.

As you have got how to parse JSON, the name and the id parameter of the attachments should be extracted.

As the normal form attachments are saved in OneDrive for Business, you can get the file content based on the id got from Parse JSON.

After got the file content, you can create an array like what I showed above for creating file in the library folder.

{

"Name": "@{items('Apply_to_each')['name']}",

"Content": @{body('Get_file_content')}

}

As not all the attachments meet the condition Category Blue, you need to use Filter Array from the created array to filter the matched files.

As there is "_" in the file name, replace it with a space is necessary by using replace(item()?['Name'], '_', ' ').

For the last step, you need to type items('Apply_to_each_2')?['Name'] in File Name and items('Apply_to_each_2')?['Content'] in File Content.

Welcome to share any updates at your convenience.

Thank you for your effort and time.

Sincerely

Cliff | Microsoft Community Moderator

Hello,

Thank you so much for providing this detailed response. I sincerely appreciate it. As mentioned, I'm new to Power Automate (meaning this is my first time using it). With that, please forgive me as I need a more detailed explanation.

I did not understand how to get the code for the schema. It took me a while but I eventually figured it out.

I was able to follow along with the information provided in the previous response but got lost at the Append to Array Variable step:

1. I do not understand what is being relayed with the code below. What am I supposed to do with it? Am I supposed to change some of the values? Please advise. Append to array variable { "Name": "@{items('Apply_to_each')['name']}", "Content": @{body('Get_file_content')} } Filter Array: replace(item()?['Name'], '_', ' ') contains Category Blue
2. When I try to enter the values as shown in the screenshot, the OneNote body option is not available to me. I'm only able to select from 3 body types, none of which are related to OneNote. Power Automate is also auto-populating an Apply to Each 2. Not sure why or if that is problematic.

I have not gotten to the final screenshot but I am also unclear what is being communicated with the red text. Is it an explanation of something or code that I need to include somewhere?

I do hope you can be so kind as to provide a thorough explanation to help me understand your direction and accomplish this task.

Thanks!

Dear Lissa,

Thanks for your updates and kindness.

Here is an example flow for your reference.

Form

Flow Details

Append to array variable

{

"Name": "@{items('Apply_to_each')['name']}",

"Content": @{body('Get_file_content')}

}

Filter Array:

replace(item()?['Name'], '_', ' ') contains Category Blue

Welcome to share any updates at your convenience.

Thank you for your effort and time.

Sincerely

Cliff | Microsoft Community Moderator

Thank you so much! I'm sorry but I'm a bit confused (as I mentioned, I'm very new to Power Automate). Below is what I have so far (thanks to visuals from YouTube). With this, I was able to get the attachments from Microsoft Forms to Microsoft Lists. I'm not clear on what steps to add next to get the attachments from Microsoft List to specific folders on SharePoint according to the file names.

I know you've provided steps in the previous response but I'm confused about how to add it to what I've already created. Could you kindly provide another screenshot to help?

Dear Lissa,

Thanks for your updates.

You can just change the Filter Array part in the flow screenshots in my reply above as follows to see the result.

Filter Array:

replace(item()?['DisplayName'],'_',' ') contains Category Blue.

Welcome to share any updates at your convenience.

Thank you for your effort and time.

Sincerely

Cliff | Microsoft Community Moderator