Answered

type 'Calculated' cannot be used in the query filter expression. clientRequestId

(1) Share

Report

Posted on by YEUNG_Gabriel

I have a column named 'B' and it is a calculated field NOW() - [Due Date] so I put this in the FILTER QUERY --> B eq 'EXPIRED'

However, it failed and the Error Details is

The field 'B' of type 'Calculated' cannot be used in the query filter expression. clientRequestId : 7c92d7e20-a148.....

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Verified answer

v-yamao-msft on at

Like (3)

Report

Hi YEUNG_Gabriel,

I can reproduce this issue on my side. I create a simple flow with the action “SharePoint – Get rows”, then use Filter query to filter the items.

According to your description, I add a Calculated column named B in the list. I assume that the “EXPIRED” might be a Number column on your side. So I also use a Number column on my side.

Below is a screenshot for my flow configuration:

The flow failed with the same error message you mentioned:

I have seen a thread which is saying that The Calculated field is also not supported in query filter expression. So when we using the Calculated column in Flow, we will get the error message “Calculated cannot be used in the query filter expression”. Please check the thread at here:
https://social.msdn.microsoft.com/Forums/SqlServer/en-US/328cbc11-f37c-4489-9bf7-9710c655f7d1/error-occurs-on-sharepoint-online-when-user-filter-data-on-multiple-line-or-calculate-field?forum=appsforsharepoint

You could also consider to create a request at Flow Ideas Forum about this issue, hope PGs will take it into consideration in the future releases:
https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

PS: Please post Microsoft Flow related issues on Microsoft Flow Forums, the reason why I recommend posting appropriately is you will get the most qualified respondents, and other partners who read the forum regularly will share their knowledge or learn from your interaction with us. Thank for your understanding.

Best regards,
Mabel Mao

Was this reply helpful? Yes No
YEUNG_Gabriel 23 on at

Like (2)

Report

however, any workaround for the time being... Thanks ~~

Was this reply helpful? Yes No
warkem 32 on at

Like (1)

Report

Any workaround for this or did it get resolved??

Was this reply helpful? Yes No
PHemingway610 129 on at

Like (0)

Report

I get the same error. It would be nice to be able to filter against a calculated column. I have created a "Week Start Day" calc column that figures the first day of the week in which an item was modified. Then I'm trying to use that in a flow (with it as the filter for "Get Items") to send a weekly email of recently-modified items.

Was this reply helpful? Yes No
simon-int 45 on at

Like (3)

Report

There is a workaround for this issue described here:-
https://sharepains.com/2021/04/14/filter-by-calculated-fields/

Basically, you can use the Flow action "Filter array" to do the calculation and comparison instead.

Leaving this comment in case others find this thread later on.

Was this reply helpful? Yes No
Brudont 13 on at

Like (0)

Report

Hello, i had it the same problem but with 2 columns created inside a sharepoint and i concatenated this 2 columns, but on the moment i filter with this calculated column i get the same error, i resolved this problem with this formule in Filter Query "Namecolumn" eq '"nameinyoudata" and "Namecolumn" eq '"nameinyoudata"

Remember the apostrophes.

Was this reply helpful? Yes No