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!
@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
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!
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 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!
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?
@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.
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 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!
WarrenBelz
146,776
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
66,093
Most Valuable Professional