Instant flow send e-mail to multiple recipients with customized attachment
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 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.