Skip to main content

Notifications

Power Automate - Using Flows
Answered

Error when saving a flow for email reminder on tasks that are due

(0) ShareShare
ReportReport
Posted on by 50

Good Day,

 

I am trying to create a flow that will send emails to users assigned to a task, 1 day before the task is due.

 

The flow returns an error for getitems property which is designed as

tsholo_0-1716467190646.png

my DueDate field on sharepoint is

tsholo_2-1716467319398.png

The error i get when saving the flow is:

tsholo_3-1716467374974.png

 

  • tsholo Profile Picture
    tsholo 50 on at
    Re: Error when saving a flow for email reminder on tasks that are due

    It works now. thank you kindly

  • Verified answer
    creativeopinion Profile Picture
    creativeopinion 10,056 on at
    Re: Error when saving a flow for email reminder on tasks that are due

    @tsholo It looks like you have an extra single quote here. There should only be a single quote on each side of your dynamic content. 

    creativeopinion_0-1716470747675.png

     

    In the meantime, you might also find these YT Tutorials helpful: 

    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

     

    ------

     

    How to Work with 📆 Dates in Power Automate | Example Scenarios and Tips & Tricks

     

    Are you easily stumped when working with Dates in Power Automate? In this Power Automate tutorial, I’ll show you how to compose an expression that will return a future date, a past date, how to count the number of days between two dates, how to check for a birthdate and anniversary date as well as tips and tricks when working with dates in Power Automate.

     

    I’ll cover some common use cases and concepts that can help you to build better Power Automate flows. Feel free to skip ahead using the timestamps listed below. I’ve also linked a few other tutorials that you might be interested in as well.

     

    IN THIS VIDEO:

    ✅ 4 Date Functions You Need to Know

    ✅ How to use the Convert Time Zone Action

    ✅ How to Get a Future Date

    ✅ How to Get a Past Date

    ✅ How to Return SharePoint Items Due in a Number of Days

    ✅ How to Return SharePoint Items Due within a Date Range

    ✅ How to write a Filter Query for SharePoint Items Due in 30, 60 and 90 Days

    ✅ How to Calculate the Number of Days between Two Dates

    ✅ How to Check for a Birthdate and Anniversary Date

    ✅ How to work with Dates and Times in Excel

    ✅ How to use a Manual Trigger with Date Input

    ✅ How to Output Dynamic Text with an Expression

    ✅ How to Check if a Date Falls on a Weekend

     

    Hope this helps!

    If I helped you solve your problem—please mark my post as a solution ✅.
    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,304

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,703

Leaderboard

Featured topics

Restore a deleted flow