Skip to main content

Notifications

Power Automate - Building Flows
Unanswered

Trying to reuse an automatically created flow

(0) ShareShare
ReportReport
Posted on by 4
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.
  • creativeopinion Profile Picture
    creativeopinion 10,103 on at
    Trying to reuse an automatically created flow
    @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!
  • PC-20011641-0 Profile Picture
    PC-20011641-0 4 on at
    Trying to reuse an automatically created flow
    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": []
    }
     
     
     
     
  • Chriddle Profile Picture
    Chriddle 7,371 on at
    Trying to reuse an automatically created flow
    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.
  • creativeopinion Profile Picture
    creativeopinion 10,103 on at
    Trying to reuse an automatically created flow
    @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:
     

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,580

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,909

Leaderboard