Flow is failed due to filter query condition

(0) Share

Report

Posted on by RajSingh

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 :

Can anyone please help me to resolve this issue?

Thank you!

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (1)

creativeopinion 10,502 Super User 2025 Season 2 on at

Like (0)

Report

@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'.
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

Was this reply helpful? Yes No
RajSingh 176 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
creativeopinion 10,502 Super User 2025 Season 2 on at

Like (0)

Report

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

This is a string of text. Not an expression.

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.

Was this reply helpful? Yes No
RajSingh 176 on at

Like (0)

Report

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)

Was this reply helpful? Yes No
creativeopinion 10,502 Super User 2025 Season 2 on at

Like (0)

Report

@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

Was this reply helpful? Yes No
RajSingh 176 on at

Like (0)

Report

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 .
length(outputs('Get_Items')?['body/value'])

Was this reply helpful? Yes No
RajSingh 176 on at

Like (0)

Report

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
Also under Condition, Changed the length function to below:

Thanks @creativeopinion for all your help!

Was this reply helpful? Yes No
Verified answer

creativeopinion 10,502 Super User 2025 Season 2 on at

Like (0)

Report

@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

Was this reply helpful? Yes No