You’re offline. This is a read only version of the page.
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,
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.
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.
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.
#1
Michael E. Gernaey
566
Super User 2025 Season 1
#2
David_MA
516
Super User 2025 Season 1
#3
stampcoin
492
Share
Report
All responses (
Answers (
