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?
Filter Query: eventDate_2 eq formatDateTime(addDays(utcNow(),-1),'yyyy-MM-dd')
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.
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
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!