cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Amghost
Level: Powered On

Conditional Emails

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

 

4 REPLIES 4
gristcooper
Level: Powered On

Re: Conditional Emails

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?

Amghost
Level: Powered On

Re: Conditional Emails

Certainly an option, we were are trying to limit access to the lists and keep people within the app.

Also, leave requests should not be shared with others.

AKRogers
Level 8

Re: Conditional Emails

Hi @Amghost,

 

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:

 

  1. Employee Submits leave request to a particular manager
  2. Flow runs and stores the manager in a variable
  3. SharePoint Get Items where Title eq ManagerVariable
  4. Retrieve the associated Clerk from the information that comes back
  5. Send email to that Clerk 

Hope that helps!

 

Ashley

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!

Community Support Team
Community Support Team

Re: Conditional Emails

Hi @Amghost,

 

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!

Best Regards,
Community Support Team _ Lin Tu

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 161 members 5,059 guests
Recent signins:
Please welcome our newest community members: