Showing results for 
Search instead for 
Did you mean: 
Helper II
Helper II

Auto Assign Tasks to Pool of Users

Hi all,


I've currently built a flow that will check the created time of an item in a SharePoint list and use two columns to determine if the created (current) time is within the user's predefined schedule. Thing is it only works right now since I have 1 user (myself for testing). I need it to cycle through each one, one at time. The idea is to evenly assign tickets to users but it needs to take into consideration their availability, reason I have it fact check the Schedules list first.

This is so I can have new items automatically assigned to agents instead of having someone manually assign the items.


Currently, when a new item is created it will reach out to another SharePoint list (called Schedules) and see if the time the new item was created falls in between a user's schedule.


I now need it to cycle through my list of users and if WITHIN shift, assign an item, repeat for next new item, assign to next available person and cycle. This is so everyone that's available gets an even amount of tasks.

How can I now have multiple users and have it cycle through?


This is what it currently looks like:



Schedules List: (only me in it. I need to add more users and then have the flow skim through these and assign items evenly)



Helpful resources

MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Top Solution Authors
Users online (1,185)