cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Timbo
Frequent Visitor

Send reminder based on a CALCULATED date in Document Library

I need to send a reminder based on a date from a CALCULATED column in a Document Library. The flow works if I use a Date formatted column. But we need a reminder based on a calculated date from another date column. This is the flow error when I use the needed calculated column.
    "status"400,
       "message""The field 'Expiration_x0020_Calculated' of type 'Calculated' cannot be used in the query filter expression.
I can overcome this issue if there is a way to convert the calculated data (Expiration Calculated) to text values into date format into another column (Expiration Value). Then I can just hide the extra column from the view.
flow problem.jpg
 
 
1 REPLY 1
tom_riha
Super User II
Super User II

Hello @Timbo ,

you can't use Filter Query on a calculated column, but you can move the whole calculation into Power Automate. The calculated column is the Agreement Date + Duration Value, the same calculation can be done with the addDays(...) expression.

addDays([AgreementDate],[DurationValue])

Note:
replace both the values with the dynamic content representing the columns

similarly, if you want to check if today is the expiration date based on the AgreementDate:

AgreementDate eq 'addDays(utcNow(),-[DurationValue])'

Note:
replace [DurationValue] with the dynamic content representing the column

 



[ If I have answered your question, please Accept the post as a solution. ]
[ If you like my response, please give it a Thumbs Up. ]

[ I also blog about Power Automate solutions even for non-IT people. ]

Helpful resources

Announcements
MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Users online (75,774)