Building flow to send an email on a specific date

[csau]

Hello! I know there are multiple posts for this type of flow already and I've built mine successfully, but I'm having trouble filtering the dates so that the email ONLY sends the email if the due date is today.

I have an excel table with an Assigned To (email) and Due Date Column, First Name, and Last Name. I've set up my flow to send an email to the assigned email with the Due Date, First Name, and Last Name. However, the email is showing my all the items in the table and not only the items due today. If someone can please offer some guidance, it would be very much appreciated!

Also, I tried the Filter Query section of the 'List rows present in a table' with: DueDate eq 'formatDateTime(utcNow(),'yyyy-MM-dd')' but this gives me an error: Invalid filter clause: cannot find the 'DueDate' column.

[csau]

Today is 12/16/22 and the email should've only included items with due date 12-16-2022, but it sent me everything in the list. Screenshot attached. 

[Amit_Sharma]

Hi @csau,

Please Select ISO8601 in Date TimeFormat Field of   List rows present in a table Action. and please confirm What Output selected in From Field of Create HTML Table Action.

Could You Show Me your Due Date Sample which Store in Excel Table.

[csau]

@Amit_Sharma Thank you for your response. ISO 8601 has been selected from the beginning. Please see below for my excel table.

Here is the entire flow from start to finish:

 

 

 

 

 

[Amit_Sharma]

After Filter Array2 Action Please Provide Value in From Field Select Action Which value return by Filter Array2 Which Filtered According to date.

item()?['Assigned To']

After this I guess you are good to go.

Best Regards.

[csau]

@Amit_Sharma Hi Amit, I changed the From & To in the Select action step, but received this error.