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
Check out the new Process Advisor community forum board!
Check out new user group experience and if you are a leader please create your group
On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks