Emailing information from table within excel document with dynamic file name

[Gwill1983]

Hi all

I am currently having huge difficulties with this and am after some pointers if possible.

My team regularly run reports using an excel template, but this report is then saved with a seperate file name with the date that the report is created. The table names within the report always remain the same. 

What I am trying to achieve is that once the report is complete then a flow is triggered by a button within the excel sheet to send the emails using the information within one of the tables.

So...... the table will always be called Email_List within the sheet and contains 3 columns named "Supplier", "Email Address", "Outstanding Purchase Orders"

Once the flow is triggered then I would like an email (with dynamic content) be created for each row of the table to be sent to the email contained in column 2 containing the information in the other columns.

I am struggling to achieve this with a dynamic file name as I cannot then reference any tables or data within the dynamic detail in the steps. 

If anybody can help with this then it would be amazing.

I can supply anymore information required

[AnthonyAmador]

Hi @Gwill1983 

For what you say, I guess you want to use Excel's "For a selected row" trigger, the problem is that each time the file is going to be different and you have to change the file path in the trigger manually.

I think the best approach is to use a trigger when a new file is created for SharePoint or OneDrive, then use "List rows present in a table" to get the values from the Excel table, and finally create the email with that information, that way automatically every time the new file is uploaded the email will be send.  

Let me know if you need more help. 

Kind regards. 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.