Send email based on folder name

[Impossibru28]

I'm trying to create a flow that will send an email notification to a certain email distribution list when a file is saved to a specific folder in Sharepoint. For example, if a file is created in the Accounting folder an email notification goes to the Accounting department, or if a file is created in the Operations folder an email goes to the Operations department. I keep a separate Sharepoint list with the folder names in one column (Accounting, Operations, HR, etc) and the email distro in the other column (Accounting@email, Operations@email, HR@email, etc) but I'm not sure how to associate that with the flow. 

[v-LilyW-msft]

Hi @Impossibru28 

Thank you for posting.

According to your description you want to create a flow that will send an email a certain email distribution list when a file is saved to a specific folder in Sharepoint.

You can check whether the Folder path of the new file contains Accounting/Opreation/HR, then get the corresponding email address and send an email.

Please take a try with the following steps:

First please select the Trigger: When a file is created (properties only).

Then use condition to check whether the Folder path contains the Accounting

If Floder path contains the Accounting, Get the email address of Accounting and send an email

If No, check whether the Floder path contains the Operation.

If Folder path contains the Operation, Get the email address of Operation and send an email.

If Folder path does not contains the Operation, It means the file was created in HR folder, then get the email address of Operation and send an email as below

Then save Flow and can test it.

I created Accounting/HR/Operation folder in first-library

This is my List  for storing email address.

When I create a file in the Accounting folder

The email will be sent to the email address of Accounting

Hope the content above may help you.

Best Regards

Lily

[Impossibru28]

Thanks Lily. This solution could work, but I'm worried it will get too long if the department list is very large. In my case we could have close to 100 departments, so I'm wondering if there is a more efficient way than using multiple conditions. Is there a way to set a condition if the folder name matches an item on the Sharepoint list, send the email to the address associated with that list item?

[v-LilyW-msft · Accepted solution]

Hi @Impossibru28 

Thank you for your responding.

Please take a try with the below screenshot to see if it can meet your requirements.

The three Accounting/HR/Operation folder in first-library

This is my List for storing email address.

When I create a file in the Operation folder

The email will be automatically sent to the mailbox of the corresponding department

When running flow, if appear checker as below, please click X, and then continue to run.

Hope the content above may help you.

Best Regards

Lily