cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dpal
New Member

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

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:

image.png

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

 

Condition step that is supposed to select the files on the SharePoint locationCondition 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 attachmentSends e-mail to the recipient in the distribution list with the excel file as attachment

 

image.png

2 REPLIES 2
v-litu-msft
Community Support
Community Support

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.

@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. 

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (3,071)