Round Robin Assignment 04-17-2021 07:05 AM - last edited 04-17-2021 07:12 AM

[aprildunnam]

Title: Round Robin Assignment

Description: This flow monitors a shared mailbox for a keyword and checks against a SharePoint list that contains a list of staff members to automatically pick an employee, forward the email and assign a task in Planner.

Detailed Instructions: Create a SharePoint list called TeamMembers.  In addition to the included Title Column, add another single line of text column called Email.  Populate this list with the name of the team member in the Title field and their email address in the Email field.  Create one more SharePoint list called Counter.  Create a number column called Value.  Create one item in this list with 0 as the title, leave the Value blank. 
Questions: I am open to answering questions about this Flow. Please ask right here as a reply.

Anything else we should know:  This is particularly useful if you have leads that come in and you want to evenly distribute them to your sales team to follow up on.

watch?v=Vs0Wd2W2qrI

[piersm2]

I am getting ID #1 twice in a row.  Can you assist?

[TT_2007]

Hi April, I am trying to build further condition to allocate task only to the members who are available. For this this i have added a column called "Availability" with value "Available" and "Not available" in the member list. I want flow to consider availability of members and allocate the new task among available member using "Round Robin Assignment". Please assist. I am very new to the flow so need your expert input. Thanks

[bfcavaco]

Hi April,

I have a flow very similar to yours and the round robin fails when multiple emails arrive at the same time, all the tasks are assigned to the same user, only after these assignments the variable in the sharepoint list is updated. I tried several approaches but with no success. This method only works when emails arrived 1 at a time with some interval between.

Is there a workaround for this problem?

Thanks.

[vargasjo]

Hello,

you should try at the settings on your trigger activate concurrency control set it to 1 so this way it only process 1 flow at a time, if you get 2 emails at the same time it will put the second on hold untill finish the first one, this worked like a charm for me.

Best Regards

[bfcavaco]

Hi, vargasjo

Thanks a lot for the reply.

Works like a charm 😀

Thank you.

[EvilGretzky]

I keep getting hit with the following error. How can I troubleshoot further?

The execution of template action 'Apply_to_each' failed: the result of the evaluation of 'foreach' expression '@outputs('GetCounter')?['body/Value']' is of type 'Float'. The result must be a valid array.

[Ank4]

Hello,

I have a query on this flow ,I am getting error on get info team member I am using get item action , Error cannot find the file 

Any suggestions I followed April's video still getting this. Error any suggestions?

[mbeans]

I keep getting an errror on "counter initialize" (Unable to process template language expressions in action 'Counter_Initialize' inputs at line '0' and column '0': 'The template language function 'int' was invoked with a parameter that is not valid. The value cannot be converted to the target type.')

anyone have any ideas?

[VictorIvanidze]

Here are 2 commercial Round Robin templates:

https://ivasoft.com/roundrobinflow.shtml

https://ivasoft.com/roundrobinsharedflow.shtml