Case Assignment Round Robin Process

(0) Share

Report

Posted on by Priyanka03

@Pstork1

Hi All

Example:

Name Total Case Assigned

Asha 3

John 2

Jack 2

Beth 2

Carolyn 1

Charlie 1

I want to assign the next case to these people so its round robin process the person who has the lower value i have to start from them to assign the case. Lets say Charlie and carolyn has 1 ,before assigning to them i need to look alphabetically to sort carolyn comes first to assign the case next charlie beth jack john like this sequence.

It should be alphabetically and start from lowest value

Output should be like this

Carolyn 1

Charlie 1

Beth 2

Jack 2

John 2

Asha 3

Please help me how to proceed with this in power automate flow.

I have taken list rows and sort the column of total case assign then i put apply to each.

Kindly let me know how to proceed further.

Thanks,

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (2)

Pstork1 68,697 Most Valuable Professional on at

Like (1)

Report

Sort the list by name in ascending order and then Sort that result by case count in ascending order. Use a first() to get the name of the person whose name is first alphabetically with the lowest number of cases.

Was this reply helpful? Yes No
Priyanka03 on at

Like (0)

Report

It will come the right output but how do i want to implement like:

For example Total Case Assigned
2 stanwell
2 caroline
2 beth
totaly 3 rows are there so i need to filter those 3 rows from total column and then sort it alphabetically of their name for assigning the case
So i want to take the count of total column how many of them are there in the value 0 1 2 3 likewise.
I want to implement in this way.

Was this reply helpful? Yes No
Verified answer

Pstork1 68,697 Most Valuable Professional on at

Like (0)

Report

Have the count and the name in different columns. Then as I said in my previous reply use an inner sort to sort by name and then an out sort to sort by total. The resulting list will be

2 beth

2 caroline

2 stanwell

So the first record will be beth. If beth had 3 cases then the sort I've described would give you this

2 caroline

2 stanwell

3 beth

So now caroline is the first record.

Was this reply helpful? Yes No
Verified answer

Priyanka03 on at

Like (0)

Report

@Pstork1 ,

I did sorting and put inside apply to each its coming the right value.

Was this reply helpful? Yes No