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

All responses (6)

Answers (1)

Sort by

Verified answer

Tristan_D 405 on at

Like
a
(1)

Report
Copy link

Link copied!
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
Emtu 21 on at

Like
a
(1)

Report
Copy link

Link copied!

Actuallu no, it sent same email to everyone in the list.
Tristan_D 405 on at

Like
a
(1)

Report
Copy link

Link copied!

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

Can you send me your flow's screenshots please ?

T
Emtu 21 on at

Like
a
(2)

Report
Copy link

Link copied!

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

Like
a
(1)

Report
Copy link

Link copied!

That can happen 😉

Thanks for the feedback !

T
TM-08111125-0 2 on at

Like
a
(1)

Report
Copy link

Link copied!

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 :-)