Email reminder after 3 days based on the date and status

Dear Team,

I have 2 columns in SharePoint, based on which I want to check the values and send the email reminder to the user.

Columns:

• "Date - Draft entry submitted" - Populates date and time
  • Please note it is in New Zealand Date time
• "Draft - Not Submitted" - Status column

SharePoint Local setting is in New Zealand Date and time

I have designed the below flow to trigger the notification when the date in column "Date - Draft entry submitted" is 3 days before todays date.

Details on Convert time zone part:

Filter query details: Applied in "Get items with filter""

• Date_x002d_Draftentrysubmitted ne null and Status eq 'Draft - Not Submitted'

Condition details:

1. formatDateTime(item()?['Date_x002d_Draftentrysubmitted'],'dd-MM-yyyy') is equal to 

   formatDateTime(addDays(utcNow(), -3), 'dd-MM-yyyy')

2. Status value is equal to Draft - Not Submitted

The flow is working but only the issue is with the date and time.

For example;

• If today's date is 21/02/2025

Flow will send email to the user where the values are below;

• 18/02/2025 and time in AM only
• 17/02/2025 and time is in PM only

I don't want it to consider the time part. It should only be triggered for all the records that are with values 18/02/25 (AM and PM both).

Request for assistance.

Also, for some reason my account is locked for the power platform community where I wanted to post this. Can someone please help unlock my account on the power platform community.

Regards