Answered

Specify attachment from excel file

(0) Share

Report

Posted on by DEJ

Hi

I have a excel file with a table in. First colum is customer name and second is email adress. Then I have a seperate excel file for each customer. The file name is the name of customer. I have managed to get flow to send a seperate email to each customer from the excel table. But how do I make sure each email is getting the specific file attached for the customer ?

All responses (5)

Answers (1)

DEJ 16 on at

Like (0)

Report

Re: Specify attachment from excel file

Perfect !!! thx.

I can get it to work, but can you make me the recipe if the files in stored on a onedrive for business ? We don't save the customer files on sharepoint. The are stored either on onedrive or shared windows folder.
v-zhos-msft on at

Like (0)

Report

Re: Specify attachment from excel file

Hi @DEJ ,

You should add the 'Get file content' action in your flow.

Please Take a reference to the reply above.

Best Regards,

Community Support Team _ Zhongys

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
DEJ 16 on at

Like (0)

Report

Re: Specify attachment from excel file

Also I have trouble finding the dynamic content in the send mail part of the attachment name " File Content "

I dont have this oppotunity to choose ??
DEJ 16 on at

Like (0)

Report

Re: Specify attachment from excel file

Hi @v-zhos-msft

Thanks for helping. The files are stored in a folder on Onedrive for Business.
Verified answer

v-zhos-msft on at

Like (0)

Report

Re: Specify attachment from excel file

Hi @DEJ ,

It seems you want to send the corresponding excel file to the person based on the file name.

I assume you have saved all the attachments(excel files) in a SharePoint library.

I have made a flow for your scenario, please check it for a reference.

Best Regards,

Community Support Team _ Zhongys

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.