Hopefully this will get what you're looking for. Note that I had to convert your Excel data to an Excel Table. You can then reapply the formatting to the Table as required. Let me know if this is not possible to set as a Table but would definitely make it harder. Also, note that I didn't add anything relating to sending emails - just focused on getting the appropriate data from Excel.
For this example, I'm using the following Excel Table (only includes a few dates for testing purposes).
See full flow below. I'll go into each of the actions.
Recurrence is set to run once a day. Note sure what you have here.
List rows present in a table will retrieve all the data from your Excel Table. We won't be able to filter the data at this point.
Filter array then filters on the rows where the current date column is equal to No (reports that haven't been completed for the current date). The expression used is below. It retrieves the value from the column titled the current date (Jun-21 for example).
item()?[formatDateTime(utcNow(), 'MMM-dd')]
Select uses the output from Filter array and only maps the relevant fields we want. The expressions are below:
item()?['ID']
item()?['Report']
item()?['Frequency']
item()?['Due on']
item()?['1st Owner']
After running the flow, we would get only the items where today's date value is No. We could then loop through each of these items and send an email with the relevant data.
[
{
"ID": "2",
"Report": "Report 2",
"Frequency": "Daily",
"Due on": "Daily",
"1st Owner": "A1"
},
{
"ID": "4",
"Report": "Report 4",
"Frequency": "Daily",
"Due on": "Daily",
"1st Owner": "A1"
}
]
----------------------------------------------------------------------
If I've answered your question, please mark the post as Solved.
If you like my response, please consider giving it a Thumbs Up.
