cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Forward email to rotating recipients (based on a list) to allow workbalancing

Hi

 

I need a Flow to do the following:

 

1. Email comes in

2. Forward the email with all attchments to recpients changing as set out below (for illustration purposes)

     a. First email goes to a@company.com
     b. Second email goes to b@company.com
     c. Third email goes to c@company
      (...... further like the above...)

      d. 30th email goes to a@company.com (so, this is the second email to that adress)

      e. 31st email goes to b@company.co (so, this is the second email to that adress)
      d. 32st email goes to c@company.com ....

      (.... repeats again every 30 emails starting with a)

 

AIM is to have a simple workload balancing solution, so emails coming are distrubiting to a rotating, repeating set of people for handling.

 

Ideally, this would be work from an Excel sheet, so that one could assign different workload to different recipients (e.g. by making the order a,b,c,d,a,b,a,d,e[repeat at beginning], which meant a,b were doing more than the others)

 

I "only" need a clever idea how to:

   1. Pull the email from an email sheet AND

    2. Mark which one was used before, so the next one is used for the next round (so, store the status inbetween flows) , and
    3. have a method to "cycle back to one" if the list of adresses is completed.

 

THX!

 

Nico

 

Regards

 

Nico

 

 

 

1 REPLY 1
v-yamao-msft
Community Support
Community Support

Hi @Anonymous ,

 

I am afraid that your scenario could not be easily achieved using Flow. However, if you are familiar with Custom APIs, please consider registering a custom connector in Flow.

 

More details about custom connectors, please check the following doc at here:

https://docs.microsoft.com/en-us/flow/developer/register-custom-api

 

Best regards,

Mabel

 

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (3,595)