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