Trying to reuse an automatically created flow

(0) Share

Report

Posted on by PC-20011641-0

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.

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

creativeopinion 10,506 Moderator on at

Like (1)

Report
Copy link

Link copied!

@PC-20011641-0 It's hard to offer any recommendations without seeing your full flow and the logic behind it. If you are using the new designer, toggle it off and click each action to expand it. Upload a screenshot of your flow in edit mode.

In the meantime, you might be interested in this YT Tutorial:

Send Emails Based on a 📆 Date Column in SharePoint with Microsoft Power Automate

In this Microsoft Power Automate tutorial, I’ll show you how to build a flow that will send a Happy Birthday email to a user based on a date column in a SharePoint list. The SharePoint list also contains a column with a Manager’s name which we’ll use to send a three-day and day of reminder to the user’s manager.

This automation will use the Filter Array action to filter out all SharePoint list items where the user’s birthday is today or in three days. This flow can apply to a variety of scenarios such as:
📅 Student Birthdays
📅 Project Due Dates
📅 Contract/Membership Renewals
📅 License Expirations
📅 Client Anniversaries
---
IN THIS VIDEO:
✓ How to Send an Email based on a Date Column in SharePoint
✓ Using the Recurrence Trigger in Power Automate
✓How to Use the Filter Array Action with multiple conditions
✓ How to Get Dynamic Content from a Filter Array Action
✓ How to Get a Date Three Days from Today
✓ How to Create a Dynamic Date Based on utcNow()
✓ How to Return a Count of Items
✓ How to initialize and set a variable
✓ How to use the Send an Email (V2) action
✓ How to send test emails

Hope this helps!

Consider giving me a ❤️ if you liked my response!

👉 Level up your Power Automate skills by checking out my tutorials on YouTube
👉 Tips and Tricks on TikTok and Instagram

Was this reply helpful? Yes No
Chriddle 8,525 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Your column name Date to be reviewed is wrong.

Check the output of the Get List Items action (without the filter, of course) for the correct name.

Was this reply helpful? Yes No
PC-20011641-0 4 on at

Like (0)

Report
Copy link

Link copied!

So i followed that video which I must say is really good but I now have an issue.

The document library im using has blanks in some of the date fields which throws up an error. I followed your section of the video which refers to editing the filter array to include the following:-

@and(
not(equals(item()?['ReleaseDate'], Null)),
or(contains(item()?['ReleaseDate'], outputs('Compose_-_Today''s_Month_and_Day')),
contains(item()?['ReleaseDate'], outputs('Compose_-_Dynamic_Date'))))

This removes the error but i'm no longer getting any output, the ouput from the filter array is now blank

{

"body": []

}

Was this reply helpful? Yes No
creativeopinion 10,506 Moderator on at

Like (1)

Report
Copy link

Link copied!

@PC-20011641-0 I would recommend filtering out items that do not have a ReleaseDate in the Get Items action. This will reduce the total number of items returned initially.

Hope this helps!

Was this reply helpful? Yes No