Curious if someone has an idea on how to use microsoft flow to help with a specific use case.
Myself and a group of my supervisors for a call center are in a distribution group, we will call the distribution group Supervisors@x.com. My goal for them is to make sure there is a response to each email within 1 business day. Since I am on the group I have outlook set to conversation mode and I just keep an eye out for any incoming mail to the group that does not get a response in that timeframe. I would like to be able to improve this process through automation, I would think microsoft flow can get me there but I am having trouble finding the right template.
Idea 1 (assume simpler) - For the first email of each unique subject sent to supervisors@x.com send a reminder if there is not a response sent within 24 hours. I am fine with getting the reminders over the weekend even though it is not a business day. This way each time I receive a reminder it is a possibility there was not a response provided within 24 hours.
Idea 2 (assume more complex) - Utilize microsoft flow to create a record in a spreadsheet each time an email is received that was sent to supervisors@x.com. Theoretically I should be able to calculate the response time between the first and second email of each unique subject to determine how many slipped passed 1 business day.
Idea 3 (incomplete idea) - Each time my inbox receives an email sent to supervisors@x.com I can create a rule to perform a function, hoping that the function created can then help to trigger when a response was provided. Perhaps to trigger a survey that a supervisor clicks 'yes' when they respond to the original email.
Obviously open for other suggestions as well. I am a little stuck on this one I assume there has to be a somewhat simple way of doing this but I was not able to find a great example through my searches.