I have a column in a sharepoint list that has a future time based on specific SLA's. How would I create a flow to send an email when that time is reached. Example) I have a request that's critical, which means it has an SLA of 2 hours. I have the column set to make a timestamp exactly 1 hour after the request is submitted. I need to send an email reminder when the current time reaches that 1 hour timestamp.
If you want something more efficient, run a daily flow that checks if anything is due the next day, and launches delayed child flows for these items.
NOTE: Neither Power Automate nor Email give any guarantee that their actions will happen at the exact time. Everything is subject to system availability.
Verified answer
Michael E. Gernaey42,617Super User 2025 Season 1
on 21 Sep 2024at01:56:38
You would need to create a Scheduled Flow, and have that flow run at whatever the min interval is, for all reminders.
It may trigger every 1 minute or 10 minutes or whatever you need it do.
It would then have to do a Get Items, with a Filter on Time (those columns you mentioned)
It would then loop through all the Rows it returned, and have it check what Type of reminder it is (its a guess on my part what you want to do)
And then have it send the email for that row only to whomever it goes too
Thats' what I would do.
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.
Share
Report
14
All responses (
Answers (
