How to Create a Condition in Power Automate Flow and save the attachment Microsoft List in a specific Sharepoint folder based on an option that the user selects from the Microsoft list

[fabtodton40]

Good morning my friends, how are you?

I have a good challenge and I will explain it to you. Sorry if my English not good. I'm from Rio Grande do Sul, Brazil and I'm new to the forum.

So, I have a Microsoft List with this options here:

In the first red square (sector), I created a column. This column is "choice" type. User must choose their "sector". Ex: financial, administrative, expedition, engineering, SAC, ...

In the second red square (attachment), are the files that user includes when he creates a new item and adds files.

The flow I need to create in Power Automate is:

Every time a new item is created => The files that the user attaches to the item are saved in a specific Sharepoint folder library based on the option they select in this column (sector).

For example.

If the user chooses the option = IT in the sector column, the files must be saved in (...)FILES/IT/

If he chooses sector = SAC, the files must be saved within (...)FILES/SAC

I already created the flow where it can take the attached files and save them in a folder that I choose.

However, I don't know how to create the conditional (condition) that he saved it automatically in a specific.

Here my Power Automate Flow

[BhawnaBansal777]

Hi Dear, I got your query - allow me some time - trying this and will get back to you on this.

[BhawnaBansal777 · Accepted solution]

Ok, so I think everything is good, just you need to know the logic for this.

Every time a new item is created => The files that the user attaches to the item are saved in a specific SharePoint folder library based on the option they select in this column (sector).

For example.

If the user chooses the option = IT in the sector column, the files must be saved in (...)FILES/IT/

So, I have an example that I tried.

My Form

Sectors taken : IT, Manufacturing and Others.

My Sharepoint folders are under a document library named as SectorBasedLibrary

My Flow where condition is handled.

I initialized a variable where it will find out which sector is selected from the trigger that will be used to define the path in whatever trigger you are going to use to save/copy/create the same file.

Created a record:

Flow Run :

Result 

Lets test for one more record lets say where sector is "others"

Record :

Flow Run :

Results:

In this way you don't have to define different conditions and have a dynamic folder path for 'n' number of sectors .

Thanks

[fabtodton40]

BhawnaBansal777

You are amazing!

I did it here and it worked beautifully and perfectly!
Thank you very much for your speed, agility and courtesy in recreating the scenario in your environment and being willing to assist me.

A big hug,

God bless you.

Fábio.

[BhawnaBansal777]

Thank you Fábio for the appreciation - these words made my day 😌