title: Power Automate to automatically refresh Excel and send emails without manual interaction
body: <p>Two part question:
  (1) Use Power Automate to Automatically have Excel power query tables auto refresh without having to open the excel workbook.
  (2) Trigger a Power Automate Flow to select rows from excel and send emails automatically based on each row WITHOUT having to open the Excel workbook. This is my flow (see screen shot).  I currently cannot run a test manually or automatically (see screen shot). Ideally I would like to trigger this flow to execute daily AFTER the refresh of the data.<br />
  <a href="https://i.stack.imgur.com/fzeI5.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/fzeI5.png" alt="Power Automate Flow" /></a>
  <a href="https://i.stack.imgur.com/JLtK0.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/JLtK0.png" alt="Error message on Test Run" /></a></p>