In the flow below I'm assuming the Table name will always be called Table1. Let me know if this isn't the case.
For this example, my Excel file just contains a single column called Email_list in a Table called Table1.
See full flow below. I'll go into each of the actions.
When a file is created waits for a file to be created in my Email Files folder in OneDrive.
List rows present in a table retrieves the Table data using the Table Name Table1.
Select uses the output (value) from List rows present in a table and builds a simple array of emails. The expression used to extract the emails is below. Note that I'm also using Text mode for the Map (see arrow on screenshot below).
item()?['Email_list']
Join takes in the union of the Select to remove any duplicate emails that may exist. And Join with is set to a semi-colon ; to separate each of the emails.
union(body('Select'), body('Select'))
Send an email uses the output from Join in the To field so it emails each of the emails listed.
----------------------------------------------------------------------
If I've answered your question, please mark the post as Solved.
If you like my response, please consider giving it a Thumbs Up.
