Hi Experts,
I'm struggling to build a filter to recognise the values in the calculated column in SharePoint.
That is the error message.
"Action 'Get_files_(properties_only)' failed: The field 'OverDueReminder' of type 'Calculated' cannot be used in the query filter expression"
It is a simple flow: it reads the ReviewStatus column and OverDueReminder Column's values, then updates ReviewStatus to a set status when the condition is meant, then fires off an email to remind the process owner to check the docs.
OverDueReminder Column is a calculated column the depends on the Next Review Due Date column's values then add 1 day (formular for that is =[Next Review Due Date]+1).
The Next Review Due Date triggers another automated email when the Next Review Due Date entry is due in the next 30 days. The logic behind the second reminder for the admins to monitor any docs whose status is not changed after 31 days.
My filter is below.
ReviewStatus eq 'Upcoming' and OverDueReminder le '@{addDays(utcNow(),31,'yyyy-MM-dd')}T23:59:59' and OverDueReminder ge '@{addDays(utcNow(),31,'yyyy-MM-dd')}T00:00:00'.
Those are my columns.
Any suggestions are welcome.
Thank you.