I created a media document library using the template provided. I also enabled the 3 day notify automation flow rule.
So I made some edits to the document library to be focused on policies.
So the date column has been renamed to "Date to be reviewed"
I also have a "Policy Lead" column which which is a O365 person or group.
What i'm trying to do is when the policy is due to reach its review date in 7 days, notify the policy lead with an email notification.
I thought just editing the Get list items filter query would work.
concat(concat('Date to be reviewed',' ge ', '''',outputs('Today_+_x_days')),'''',' and ', concat('Date to be reviewed',' lt ','''', outputs('x_Days_+_1'),''''))
But i'm not sure if something else has broken it but the flow test is pointing to this area with the issue.
Error
Action 'Get_list_items' failed
The expression "Date to be reviewed ge '2025-01-27' and Date to be reviewed lt '2025-01-28'" is not valid. Creating query failed.
clientRequestId: ######
serviceRequestId: ######
Can anyone help? Day 0 here thrown in at the deep end.