Send Email Reminder from SQL database using Power Automate

[pravind96]

Hi, I have SQL database list which consist of Date and User Email ID list column. I want to create a flow to send email reminder for those users one day before the date. I’ve created a flow and tried it. It can grab the date but cannot send the Email to the persons. Could anyone guide or help me on this flow?

Database image:

Flow Image:

Get Rows(v2)
Filter Query: eventDate_2 eq formatDateTime(addDays(utcNow(),-1),'yyyy-MM-dd')

[Mira_Ghaly]

@pravind96 

Can you please share your flow run history?

[pravind96]

my flow run history:

[Mira_Ghaly]

@pravind96 

From your screenshot this means that the Get Rows step did not return any records, I believe the issue will be in your filter Query because if your field is date time so it will not always evaluate because of the time part.

[Mira_Ghaly]

@pravind96 

Can you paste a screenshot for your SQL table?

[pravind96]

My SQL record screenshot:

[Mira_Ghaly]

@pravind96

Your date field is saving only dates as per your screen shot and your filter query looks OK so have you checked you have records on 20 September as your query suggests utcnow - 1

[pravind96]

When I tried with  utcnow - 1 it's still the same.