Send Email To Different People Based On File Name Using Flow

(1) Share

Report

Posted on by Emtu

Hello,

I want to build a flow sending email attachments automatically to different people based on file name.

* The pdf files are in Onedrive folder ( might be moved to a sharepoint folder if necessary for building the flow)

* I save pdf files to a specific folder with a particular format;

"SupplierName_YYYYMM_EmplyeeShortName_InvoiceNo"

For examle:

Hilton_202407_CKent_123456

ItalianRestaturant_202407_CKent_789456

ThePlaza_202407_LLane_852963

TheRitz_202407_LLuthor_741852

I have a sharepoint list for the employee short names and corresponding emails

So I want to build a flow which will send the pdf files (invoices) as attachment in an email to respective employee when a new file saved with her/his short name in the folder of employee travel expenses.

For instance;

Hilton_202407_CKent_123456 : will be sent to Clark Kent

ItalianRestaturant_202407_CKent_789456: will be sent to Clark Kent

ThePlaza_202407_LLane_852963: will be sent to Lois Lane

TheRitz_202407_LLuthor_741852: will be sent to Lex Luthor

Hope someone can help!

Thanks in advance!

Categories:

Building flows

I have the same question (1)

All responses (6)

Answers (1)

Verified answer

Tristan_D 400 on at

Like (1)

Report
Hi @Emtu !

You can do it by using the following flow and replacing the trigger by the onedrive connector and by using in the variable varFileName the attachment name :

the contains can be removed, I just use it to check the condition manually :

contains(variables('varFileName'),items('Apply_to_each')?['Title'])

That should do the trick 😉.

I let you try that and let me know if it helps.

T

Was this reply helpful? Yes No
Emtu 21 on at

Like (1)

Report

Actuallu no, it sent same email to everyone in the list.

Was this reply helpful? Yes No
Tristan_D 400 on at

Like (1)

Report

ok so it means that you have an issue with your filter or contains.

Can you send me your flow's screenshots please ?

T

Was this reply helpful? Yes No
Emtu 21 on at

Like (2)

Report

I had skipped the "Compose" at first but now added and it works thank you!

Was this reply helpful? Yes No
Tristan_D 400 on at

Like (1)

Report

That can happen 😉

Thanks for the feedback !

T

Was this reply helpful? Yes No
TM-08111125-0 2 on at

Like (1)

Report

I am in a similar situation and would really like to try this solution, but I cannot open/see the images to be able to follow the solution.

Are you able to reupload them or share them as a link?

Thank you :-)

Was this reply helpful? Yes No