Skip to main content

Notifications

Community site session details

Community site session details

Session Id : dGJv6GFQOgIYqnMrXdqUAQ
Power Automate - Building Flows
Answered

Flow is failed due to filter query condition

Like (0) ShareShare
ReportReport
Posted on 11 Jan 2024 20:56:01 by 176

Hi Guys,

 

I have created a flow which works fine with one condition but when I add 2 conditions with And operator then it gives the below error :

 

The field 'Progress' of type 'Calculated' cannot be used in the query filter expression.
clientRequestId: f7455a8c-e907-43b1-9357-0267bc8ad27f
serviceRequestId: f7455a8c-e907-43b1-9357-0267bc8ad27f

 

Please see below the Get_Items function :

RajSingh_0-1705006495562.png

 

Can anyone please help me to resolve this issue?

Thank you!

  • Verified answer
    creativeopinion Profile Picture
    10,406 Super User 2025 Season 1 on 13 Jan 2024 at 21:08:38
    Re: Flow is failed due to filter query condition

    @RajSingh 👍 no worries! 

     

    For more flow troubleshooting tips—check out this YT Tutorial: 5 Power Automate Troubleshooting FAQs and Helpful Tips for Creating Better Flows

    In this tutorial I cover:

     How to troubleshoot a false Condition action result

     How to get dynamic content when it isn’t selectable from the list of dynamic content

     How to troubleshoot an Apply to Each action that isn’t looping through

     How to troubleshoot a skipped Apply to Each action

     How to troubleshoot a Filter Query

     How to use a SharePoint yes/no column in a Filter Query

     How to use Compose actions to troubleshoot a Power Automate flow

    How to troubleshoot multiple emails being sent

     How to troubleshoot multiple Teams messages being sent

     

  • RajSingh Profile Picture
    176 on 13 Jan 2024 at 20:03:28
    Re: Flow is failed due to filter query condition

    SO looks like I have found out the issue . Under "Create HTML Table", I was using Get_items value so I changed it to below and it works fine 

    RajSingh_1-1705176058207.png

    Also under Condition, Changed the length function to below:

    RajSingh_2-1705176164662.png

     

    Thanks @creativeopinion for all your help!

     

  • RajSingh Profile Picture
    176 on 13 Jan 2024 at 19:35:52
    Re: Flow is failed due to filter query condition

    Thanks - The Date format and zone is correct . The flow works if I add date criteria in the filter query but If I use filter array to add another criteria for calculated column named Progress then it just ignores the second criteria and I get same result as using the 1st criteria . 

    See below the complete flow. What changes do I need to make so it checks both the conditions and give the result .

    RajSingh_0-1705173987109.pngRajSingh_1-1705174075372.pngRajSingh_2-1705174125829.pngRajSingh_3-1705174175012.png

    length(outputs('Get_Items')?['body/value'])
    RajSingh_4-1705174360104.pngRajSingh_5-1705174495682.png

     

  • creativeopinion Profile Picture
    10,406 Super User 2025 Season 1 on 12 Jan 2024 at 14:54:01
    Re: Flow is failed due to filter query condition

    @RajSingh Whenever you are using dates and times in your flow, it's always best practice to use a Convert Time Zone action. Please refer to this section of a recent YT Tutorial that goes through how to use this action. I also cover how to use a Manual trigger with a date input so you can quickly run tests on different dates. 

     

    You'll then need to use the converted time in your addDays() function. 

     

    Hope this helps!


    If I helped you solve your problem—please mark my post as a solution .
    Consider giving me a 👍 if you liked my response! 

    👉 Watch my tutorials on YouTube
    👉 Tips and Tricks on TikTok
  • RajSingh Profile Picture
    176 on 12 Jan 2024 at 13:58:02
    Re: Flow is failed due to filter query condition

    Thanks but it still doesn't check both the conditions. I have written the below condition for modified field but no records are returning . There are number of cases on sharepoint with yesterday's date (11/01/2024) so why this criteria doesn't work . DO I need to add any date format with this?

    adddays(utcNow(),-1)
    RajSingh_0-1705067746268.png

     

  • creativeopinion Profile Picture
    10,406 Super User 2025 Season 1 on 11 Jan 2024 at 23:43:50
    Re: Flow is failed due to filter query condition

    @RajSingh Your Filter Array action is comparing two strings of text.

     

    This is a string of text. Not an expression.

    creativeopinion_1-1705016608750.png

     

    The first value field should be your dynamic content as shown in the screenshot below. You should be able to select it from the Dynamic content list. 

    creativeopinion_0-1705016571112.png

     

  • RajSingh Profile Picture
    176 on 11 Jan 2024 at 23:06:59
    Re: Flow is failed due to filter query condition

    Thanks - I have tried to use Filter array to add another condition for calculated column as below but it doesn't filter the records using both Modified and Progress fields. I need to filter the records where both conditions are true. Please see below the screenshots. Any help will be much appreciated. 

    RajSingh_0-1705013938969.pngRajSingh_1-1705013987033.png

     

  • creativeopinion Profile Picture
    10,406 Super User 2025 Season 1 on 11 Jan 2024 at 21:17:24
    Re: Flow is failed due to filter query condition

    @RajSingh The error is indicating that you can't use a Calculated column in your Filter Query. Try using a Filter Array action to filter items where Progress eq 'Onshore Referral'.

    creativeopinion_0-1705007768506.png

    Note: You will not have access to the dynamic content from the Filter Array action and will need to use an expression to access any dynamic content from your Filtered Array. If you aren't sure how to do this, refer to this section of a YT Tutorial I uploaded on how to get dynamic content from a Filter Array action.

     

    Hope this helps!

    If I helped you solve your problem—please mark my post as a solution .
    Consider giving me a 👍 if you liked my response! 

    👉 Watch my tutorials on YouTube
    👉 Tips and Tricks on TikTok

     

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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,776 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,093 Most Valuable Professional

Leaderboard