Good Afternoon,
To accomplish your wanted outcome you need to do the following steps:
1. Trigger you can choose whatever you want (manual or scheduled) - basically on command or at the set time
2. Find the "List Rows" Action in the table this is tricky if the excel file is on your desktop you need to ensure you need to use the Excel (OneDrive) if its in your SharePoint it will be under the Excel(Business) side try both it should be easy to differentiate if you use them a lot.
3A. I would personally use the "Filter Query" field under the "List Rows" action to oData filter for what rows you are looking to send whether its by dept or by course example: Dept eq 'ENGL' | Grabs all rows where Dept == ENGL
3B. Use the "Filter Array" for the "List Rows" outcome this is where you will apply for whatever fields you want to send to if you want to send to all you can skip this this gives a better outcome if there is an error.
4. Send an email(V2) Outlook action-
Set the To field as your Email column dynamic value (because in your screenshot it is formatted correctly)
Set the title as wanted
Set the body to your formatted message with the dynamic values filled as needed.
This should get you started up
The only other side bar for this is make sure your Excel file has the data formatted as a table it looks like it is from the screenshot but, if it isn't go the table highlight all the headers and the rows then insert tab -> table -> My table has headers - > Insert/Create then you should be able to select that table to filter from if you follow the prompt for the list rows action.
If this answers your question please select it as the solution as it will help other users who come across it. If not feel free to follow up and at me I will try to respond!
Have a great day!
