Skip to main content

Notifications

Power Automate - Using Flows
Unanswered

How to correct below formula

(0) ShareShare
ReportReport
Posted on by

Hi,

There is error with Filter Query, can you help how to correct this formula? 

The output of the variable is "addDays(utcNow(),-30,'YYYY-MM-DD')"

 

YanLiang_0-1670166700802.png

 

  • SudeepGhatakNZ Profile Picture
    SudeepGhatakNZ 14,231 on at
    Re: How to correct below formula

    @YanLiang ,

     

    Date format in your variable expression is incorrect. Try 

    addDays(utcNow(),-30,'yyyy-MM-dd')
     
    SudeepGhatakNZ_0-1670209043474.png

     

  • v-liwei-msft Profile Picture
    v-liwei-msft on at
    Re: How to correct below formula

    Hi @YanLiang 

     

    I'm sorry this was an oversight on my part.
    The filter query of List rows present in a table does not support some filtering methods such as greater than and so on (by design).
    I suggest you use the Filter array action.

     

    Best Regards,

    Levi

  • IDonknowwhay Profile Picture
    IDonknowwhay 27 on at
  • CU22080239-4 Profile Picture
    CU22080239-4 on at
    Re: How to correct below formula

    Hello Levi,

    Thanks, but still error.

    YanLiang_1-1670208286327.png

     

    YanLiang_0-1670208248843.png

     

  • v-liwei-msft Profile Picture
    v-liwei-msft on at
    Re: How to correct below formula

    Hi @YanLiang 

     

    1. The filter query of List rows present in a table does not support column names with spaces.
    Please change Start Date to StartDate.
    2.AND is in lowercase (and)
    3. Use single quotes around variables.

     

    Best Regards,

    Levi

  • CU22080239-4 Profile Picture
    CU22080239-4 on at
    Re: How to correct below formula

    Hi Sudeep,

    Tried but still error.

    YanLiang_0-1670206999332.png

     

    YanLiang_1-1670207035427.png

     

  • SudeepGhatakNZ Profile Picture
    SudeepGhatakNZ 14,231 on at
    Re: How to correct below formula

    Use gt instead of in your oData query.

     

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,526

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,907

Leaderboard

Featured topics

Restore a deleted flow