Filter Excel File's Rows and Send Email Based on Date

[aselestok2]

Hello,

I am working on an automated email system for my team that involves a calendar of tasks created in Excel. I am attempting to filter the table based on the date of the task or tasks and sending a daily recurring email to my team that indicates these. Unfortunately, when the flow processes, it does not send a single table of tasks and instead sends an email for each entry that says "No Task Today." I am wondering where the logic is going wrong. I have my Excel Table ("DPT") and MS Flow screenshots attached.

DPT Excel TableDPT Automation Flow

[ScottShearer]

@aselestok2 

I believe your issue stems from the fact that Excel stores date values differently than Flow expects.  As a result, your condition will never be true.

There are a number of ways to approach this issue, but here is is a link to a solution with one method that I have used in the past.

Here is a link to a post that shows another way of approaching the issue.

Also, you may want to remove the "Apply to each 2" loop - it does not appear as though it is serving any purpose.

[v-bacao-msft · Accepted solution]

Hi @aselestok2 ,

Please try to configure Flow by referring to the following method.

There are two issues that need to be addressed here:

• The field value of the Date type in Excel table will be displayed as Number in Flow, so you need to use the expression to restore the number to Date.
• You need to filter out the eligible records before creating the Html table.

Please check this similar thread and see if it helps:

https://powerusers.microsoft.com/t5/Building-Flows/Excel-file-to-list-flow-date-issue/m-p/279258#M28...

Expression reference:

addDays('1899-12-30',int(item()['Date']),'yyyy-MM-dd')

Here you need to use variables to store what needs to be displayed in the Html table, and then use it to create an HTML table.

Image reference:

Details in Apply to each:

Please take a try.

Best Regards,