Forward email to rotating recipients (based on a list) to allow workbalancing
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 firstname.lastname@example.org b. Second email goes to email@example.com c. Third email goes to c@company (...... further like the above...)
d. 30th email goes to firstname.lastname@example.org (so, this is the second email to that adress)
e. 31st email goes to email@example.com (so, this is the second email to that adress) d. 32st email goes to firstname.lastname@example.org ....
(.... 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.