I have a master sharepoint list my team uses to track and assign tickets that we receive from the sales team. I currently have a view for a specific type of customer. In this view we track the day a decision was made and the day it was completed. It is required that we complete a ticket no more than 45 days from the date the decision was made.
I want to create a flow that will send from this particular view and will create an automated email to the assigned person as a warning of any items that are 30 days or greater since the decision date. I would like the email to be sent every day at 5am.
Any ideas on how to do this? I honestly don't even know where to start other than with "scheduler".
You could use Select action to custom columns shows, for example:
If you like the email to be sent every day at 5am, you could use the Recurrence trigger to run the Flow every day 5 am, for example:
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Getting this warning message; any idea what this means? Also, does this flow look right? I'm trying to schedule an email to go out to whomever the primary reviewer is for any items that are 30 days or more since the date initiated that are equal to IRP "Yes" and are not in a "Completed" status. There are a couple of extra steps in there to format the table in the email body too.
Keep up to date with current events and community announcements in the Power Automate community.
A great place where you can stay up to date with community calls and interact with the speakers.
Check out the latest Community Blog from the community!