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 ?

Categories:

Using flows

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Verified answer

v-zhos-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
DEJ 16 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-zhos-msft

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

Was this reply helpful? Yes No
DEJ 16 on at

Like
a
(0)

Report
Copy link

Link copied!

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 ??

Was this reply helpful? Yes No
v-zhos-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
DEJ 16 on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No