Contents
Is the second reminder flow designed for date and time columns?
The second reminder flow is designed for Date and Time columns. With Date and Time columns you can’t use the ‘equals date’ operator as the time will be rarely equal.
When to send a reminder on a date?
The other situation is when you calculate a date in the calculated column by adding a time period. For example, you add 1 month to a Date date column and you want to send a reminder on that date. Let’s start here from the simplified formula:
How to calculate number of days for reminder in SharePoint?
Let’s take the first situation, you want to send a reminder after a number of days since SharePoint item was created, e.g. 7 days. You might use the JSON column formatting to calculate the number of days in the list view with the following formula:
How to use base date in power automate reminder?
This post is about replacing such calculated date column in the Filter Query with a ‘base’ date column and an expression. It is the main part of Power Automate reminder process, once you can filter the relevant items, you can send the reminder.
Can a calculated date be used in a filter?
“ The field ‘CalculatedDate’ of type ‘Calculated’ cannot be used in the query filter expression. ” You can’t use calculated columns in the OData filter query. But you can rebuild the whole calculation into an expression, and use that expression in the Filter Query. You should take one step back and look on the formula in the calculated column.
Number of days from a date Let’s take the first situation, you want to send a reminder after a number of days since SharePoint item was created, e.g. 7 days. You might use the JSON column formatting to calculate the number of days in the list view with the following formula: =floor ((Number (@now)-Number ( Created]))/ (1000*60*60*24))
Can you use calculated date in power automate?
You can build a Power Automate flow that would send a reminder on that date or after that number of days. But once you try to use that calculated column in a Filter Query, Power Automate won’t like it. “ The field ‘CalculatedDate’ of type ‘Calculated’ cannot be used in the query filter expression.