Skip to main content
Community site session details

Community site session details

Session Id :
Power Automate - General Discussion
Suggested answer

List send reminder on date and time to specified user

(0) ShareShare
ReportReport
Posted on by 8
I have the below sharepoint list.  I'm trying to get a reminder send to ther CRM Chased By user on the CRM follow up Date/Time.  The sharepoint reminders just send it to myself the list owner.  I've found several tutorials online creating variables, composes and none are working.  I last tried on the 13th hence the date, so it's not that theres nothing to remind that's stopping the flow.
 
Any help would be very appreciated.  
 
 
Categories:
  • LM-01081535-0 Profile Picture
    8 on at
    List send reminder on date and time to specified user
    Hi, Sorry I'm not very advanced with Power Automate, can you help me with the filter query please, what should it look like?  Also the tutorial talks about converting the time but as I'm UK i guessing i don't need that?
  • Suggested answer
    David_MA Profile Picture
    11,750 Super User 2025 Season 1 on at
    List send reminder on date and time to specified user
    You can follow the steps in this tutorial on YouTube: https://youtu.be/cwRjGLHyq9o?feature=shared
     
    The process is quite simple:
    • Create a scheduled flow that runs daily at the time you want the email to be sent.
    • Add a Get items action with a query filter to only get the items for the current date.
      • CRM Follow Up On for your use case.
    • Add an Apply to each for the items retrieved.
    • In the Apply to each, add a Send e-mail action to send the e-mail.
     
    Note: in the video he does not use a query filter in the get items action to return only items that need a reminder to be sent. Instead, he gets all items in the list and then uses a condition to check if the current date is the date in the list to send the notification. If you have a large list, this is not efficient. I recommend using the filter query instead as your flow will complete much faster.

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

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 1

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 1