Skip to main content

Notifications

Power Automate - Building Flows

Power Automate: Error in Filter Query for Sending Notification 3 Days Before Date

Posted on by 4

I have a Power Automate flow that should send an email 3 days before a specific date.
I created a SharePoint list where the StartDateAndTime column contains the dates for which I want to receive a notification 3 days in advance.

In the Filter Query field, I entered the following code:

StartDateAndTime gt '@{formatDateTime(utcNow(), 'dd.MM.yyyy HH:mm')}' and StartDateAndTime lt '@{formatDateTime(addDays(utcNow(), 3), 'dd.MM.yyyy HH:mm')}'

When I test the flow, I encounter an error, and I’m not sure what’s causing it. Could it be the date format in the column, the filtering logic, or something else?
For additional context, the StartDateAndTime column is configured as a Date and Time type.

Does anyone know how to correctly configure the Filter Query so it works as expected?
Thank you in advance for your help!

*This post is locked for comments

  • creativeopinion Profile Picture
    creativeopinion 9,897 on at
    Power Automate: Error in Filter Query for Sending Notification 3 Days Before Date
    @CU29111912-0 I've suggested an approach on your other post which seems to be a duplicate of this post. 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,297

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,890

Leaderboard