Send Email To Different People Based On File Name Using Flow

[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!

[Tristan_D · Accepted solution]

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]

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

[Tristan_D]

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]

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

[Tristan_D]

That can happen 😉

Thanks for the feedback !

T