List send reminder on date and time to specified user

(0) Share

Report

Posted on by LM-01081535-0

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:

Process Advisor

I have the same question (0)

All responses (2)

Answers (0)

LM-01081535-0 8 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Suggested answer

David_MA 12,235 Super User 2025 Season 2 on at

Like (0)

Report
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.

Was this reply helpful? Yes No