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 SharePoint
Gets files (excel price list per customer) on a SharePoint location
Condition step that is supposed to select the files on the SharePoint location
Sends e-mail to the recipient in the distribution list with the excel file as attachment
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.
User | Count |
---|---|
88 | |
37 | |
26 | |
13 | |
13 |
User | Count |
---|---|
127 | |
54 | |
37 | |
24 | |
21 |