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.
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?
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.
8
Share
Report
All responses (
Answers (
