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

Sigh...

Thanks again for your assistance but I'm not viewing the results you are showing in your screenshots.

1. The OneDrive site is not listed in the Site Address dropdown menu. I've copied and pasted it in, but I'm unsure if that is the correct way to add the Site Address.
2. When I paste the File Name and File Content codes you provided, the code does not revert to the colored view as shown in your screenshot and as seen before when pasting previous codes. I don't know why that is or if that's a sign of an issue.

3. When I add the additional Filter Arrays, the options displayed in your screenshot is not what is available to me. I don't have the field to paste the code: @or(contains(replace(item()?['Name'], '_', ' '), 'Category Blue'), contains(replace(item()?['Name'], '_', ' '), 'Category Red'), contains(replace(item()?['Name'], '_', ' '), 'Category Green')). I'm only given the options as seen below.

Please advise, thanks.

Dear Lissa,

You may add 3 more filter arrays and 3 more create file based on the original flow like the following.

Filter Array: filter all files whose names contain Category Red, Category Green and Category Blue.

Use the formula: @or(contains(replace(item()?['Name'], '_', ' '), 'Category Blue'), contains(replace(item()?['Name'], '_', ' '), 'Category Red'), contains(replace(item()?['Name'], '_', ' '), 'Category Green'))

Filter Array 2: Filter the files whose names contain Category Red from Filter Array.

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

Create the files in Category Red:

items('Apply_to_each_2')?['Name']

items('Apply_to_each_2')?['Content']

Filter Array 3: Filter the files whose names contain Category Blue from Filter Array.

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

Create the files in Category Blue:

items('Apply_to_each_3')?['Name']

items('Apply_to_each_3')?['Content']

Filter Array 4: Filter the files whose names contain Category Green from Filter Array.

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

Create the files in Category Blue:

items('Apply_to_each_4')?['Name']

items('Apply_to_each_4')?['Content']

Welcome to share any updates at your convenience.

Thank you for your effort and time.

Sincerely

Cliff | Microsoft Community Moderator

Thank you for your wonderful explanation! I am very appreciative. I understand now that with your response, I only needed to copy and paste the code.

The example I gave was to help explain what I needed to accomplish but I need to accomplish this for multiple folders. In other words, I need the attachments from MS Lists to be automatically added to multiple folders based on the file name.

For example: Jane completed the MS Form and uploaded 3 files: Category_Blue_Jane, Category_Green_Jane, and Category_Red_Jane. Each file needs to be added to the corresponding folder according to the category contained in the file name.

📁Category Blue

1. Category_Blue_Jane ⬅️
2. Category_Blue_Jon
3. Category_Blue_Jen

📁Category Green

1. Category_Green_Jane⬅️
2. Category_Green_Jon
3. Category_Green_Jen

📁Category Red

1. Category_Red_Jane ⬅️
2. Category_Red_Jon
3. Category_Red_Jen

How can the instructions you've provided be updated to accomplish this?

Thanks!

Dear Lissa,

The array part is created in the red box part like the following.

{

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

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

}

If you add a send Apply_to_each such as Apply_to_each_2 in my flow screenshots, the answer is Yes. You can paste items('Apply_to_each_2')?['Name'] in the File Name field and paste items('Apply_to_each_2')?['Content'] in the File Content field.

Welcome to share any updates at your convenience if you need further help on this issue.

Thank you for your effort and time.

Sincerely

Cliff | Microsoft Community Moderator

Thank you so much for your patience with me. Again, I've never used Power Automate before.

I'm trying to find out what I'm supposed to do with the code below. Am I supposed to copy and paste it somewhere in the flow for it to work? You've provided the code in your response but I don't see it anywhere in your screenshots so I don't understand what I'm supposed to do with it.

{

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

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

}

The same goes for the codes items('Apply_to_each_2')?['Name'] and items('Apply_to_each_2')?['Content']. What am I supposed to do with it?

Am I supposed to paste items('Apply_to_each_2')?['Name'] in the **** File Name field? **** Am I supposed to paste items('Apply_to_each_2')?['Content'] in the File Content field?

Please tell me exactly what I need to do here because I've never used Power Automate before and I don't understand all the jargon (though it may make more sense as time goes by, but right now, I don't comprehend). I can definitely accomplish this with your help. Thanks!