Assigning case to different Team members based on availability

[sagarbh (Sagar Bhusari)]

Hi All,

Hope you are doing well. I need your help to resolve the below mentioned scenario:

I have Input Excel file which contains Case details along with assigned to team name.
In second sheet we have team member list available and need to assign cases to respective team members in round robin method.

Attaching the excel file which contains more details about this scenario. Please help me to resolve this if you can.

Input File.xlsx (8.4 KB)
Team.xlsx (8.8 KB)
If you need any additional details please let me know.

Thank you.

[ppr (Peter Preuss)]

find some cases doing round robin assignments here:

How to fill specific columns from resource sheet contionaly

@Ranvir_Sangwan Variables [grafik] Excel readin [grafik] Creating List (we use it later for the Lookup) [grafik] The(you called it RoundRobin) we do implement with the modulo function [grafik] Find starter help here: Ranvir Sangwan.xaml (18.6 KB)

Row data need to assign to the users

assumed following there is a list with developers emails: arrDevEmail = {a@domain.com, b@domain.com …} We want to iterate the excel and assign in round robin style the rows to the dedicated developer we can do: [grafik] But maybe it would be more efficient to group also the different rows to the different developers and send an email with more rows in order to reduce the emails with work assignments feel fre to remove the offset and use idx Mod arrDevEmail instead