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.
"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.
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.
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])'
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. ]