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
Super User

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
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Users online (2,165)