We have a scenario where employees are submitting leave requests. For a number of reasons, we have a separate approved list which will then populate a manager search field for the employee to select who to route their request to. This is working well and we have email alerts going to the manager when a new request is submitted.
Many of our managers have clerks that would normally take the paper requests and then note the days off on a centralized departmental Calendar. Again, for a number of reasons, we need to allow the users an open text field to note the day(s)/Date(s) they are submitting the request for. For this reason, we cannot automate the population of a centralized calendar, so we will need to conditionally notify the clerks based on the manager the employee submits the request to.
I'm looking for suggestions on how to handle this. We thought of having the managers setup Outlook rules because we are using standard subject lines in the email alerts. This would allow them to create a rule that forwards a copy of the alerts to the clerk. However, we have found rules to sometimes be unreliable and would like to embed the functionality in the app.
Im thinking about creating a flow that essentially assigns a clerk to a manager via a list and using that as a trigger to send notification to the clerk when an employee submits a request to specific manager. I'm not sure this is the best approach as the lists and flows associated with this app are getting more complex and becoming a lot to manage.
looking for ideas.....
What if you had a list that this process dumped out the data to.
Then the clerks could setup their own alerts on the list and process what they need, or setup no alerts at all and process as they want to view the list?
Where are you storing your approved list of managers? Rather than use a Flow to manage the clerk/manager relationship you could build the clerks into your existing list. Each item would have a manager and an associated clerk, and from there it's a simple SharePoint Get Items action to get those values.
So your process would be similar to this:
Hope that helps!
If this response provided an answer to your question please mark it as a solution.
If you liked my reply, please give it a thumbs up! Thank you!
Has your problem been solved?
If your problem has been solved, You could go ahead and mark the post as solved by clicking “Accept as Solution” so that this thread will be marked for other users to easily identify!
Community Support Team _ Lin Tu
We've updated and improved the layout and uploading format of the Power Automate Cookbook!
Fill out a quick form to claim your user group badge now!
We've given our badges an overhaul and also added some brand new ones!
Learn how to build the business apps that you need.
Find out where you can attend!
Watch & learn from the Power Automate Community Video Gallery!