Instant flow send e-mail to multiple recipients with customized attachment

[dpal]

Hello, 

For my work I need to send a customized price lists (in excel) to a range of customers via e-mail, and I had hoped to manage this with a flow; however, my flow isn't working.  I am no expert so I appreciate some help on this please. 

The distribution list and the price lists are in a sharepoint location. 

The flow I created tests successfully, but no e-mail is sent. Here are the steps:

Takes the excel distribution list on SharePointGets files (excel price list per customer) on a SharePoint location

Condition step that is supposed to select the files on the SharePoint locationSends e-mail to the recipient in the distribution list with the excel file as attachment

[v-litu-msft]

Hi @dpal,

You could have a try that delete the Send an email action then recreate a new one.

Then confirm the Email address is located in the organization of your outlook connection account.

You could also have a simple test that sends the email to the Email of Connection account to check if it could work.

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[dpal]

@v-litu-msft thanks for your feedback. The issue is not with the sending the e-mail portion, as I have tried that independently and it works. What I need is to pick one custom file in Sharepoint to be attached to the e-mail sent to each customer. Does it makes sense?

The files on Sharepoint are named as the customer number. Customer number is also a column in the excel distribution list. I have been breaking my head trying to get this to work.