Others

How to Automatically Assign SharePoint List Items in Rotation

Olivia Miller Sep 25, 2026 869 views

Question details

The user needs to distribute new SharePoint list items evenly among a five-member team using an automatic round-robin assignment method.

How to Automatically Assign SharePoint List Items to Team Members in Rotation

Product: SharePoint and Power Automate
Device & OS: not provided
Scenario: Managing a shared SharePoint list where new tasks or tickets must be rotated automatically among team members to balance the workload.
Observed behavior: Currently seeking an automation method so each new item with a 'New' status is systematically assigned to the next consecutive team member.

Before you start

Ensure you have adequate permissions to create Power Automate flows for your SharePoint list, and verify that the 'Assigned To' and 'Status' columns are already set up.

Solution 1Recommended

Set up a Power Automate Flow for Round-Robin Assignment

Since native SharePoint list rules do not support complex rotation logic, using Power Automate is the most effective way to assign items dynamically based on mathematical calculations.

This method uses the unique ID generated for each new SharePoint list item to calculate which team member should receive the assignment. By dividing the item ID by the total number of team members (using the Modulo function), you can determine a consistent and automatic rotation sequence.

Create an automated cloud flow

Navigate to Power Automate, click on 'Create', select 'Automated cloud flow', and choose the trigger 'When an item is created or modified' for SharePoint. Select your site address and list name.

Set a condition for New items

Add a 'Condition' action to check if the 'Status' column is equal to 'New'. If this condition is true, proceed to the 'If yes' branch.

Calculate the assignee index

In the 'If yes' branch, add a 'Compose' action. Use the expression `mod(triggerOutputs()?['body/ID'], 5)` to calculate the next team member (assuming a 5-member team). This will return a value between 0 and 4.

Update the SharePoint item

Add a 'Switch' control based on the Modulo result. Create cases for 0, 1, 2, 3, and 4. In each case, add an 'Update item' action to set the 'Assigned To' field to the specific email address of the corresponding team member.

Prevent Infinite Loops: Because the flow triggers on item modification and also updates the item, you must go to the trigger settings and add a Trigger Condition (e.g., ensuring it only runs when 'Assigned To' is empty) to prevent the flow from looping endlessly.

Free Microsoft Office alternative

Boost Your Team's Productivity with WPS Office

While SharePoint and Power Automate handle complex workflows, your team still needs a reliable, lightweight, and highly compatible office suite for daily document collaboration. WPS Office offers a seamless, cost-effective alternative to Microsoft Office.

1. Download the installer: Visit the official WPS Office website and download the free installer for your operating system.
2. Install WPS Office: Run the setup file and follow the quick installation prompts to set up the software.
3. Open your team documents: Launch WPS Office to instantly open, edit, and collaborate on any Microsoft Office file formats without losing formatting.

Fully compatible with Microsoft Word, Excel, and PowerPoint formats.Free, lightweight, and fast-loading office suite for Windows, Mac, and mobile.Built-in collaborative tools like cloud sharing, PDF editing, and team templates.Familiar user interface requiring zero learning curve for seamless migration.

microsoft office alternative - wps office

Frequently Asked Questions

Can I use standard SharePoint list rules to assign items in rotation?

No, standard SharePoint list rules do not support complex mathematical calculations or tracking previous assignments required for a round-robin rotation. You must use a tool like Power Automate to achieve this.

How do I prevent my Power Automate flow from looping endlessly when it updates the item?

Go to the settings of your 'When an item is created or modified' trigger and set a Trigger Condition. For example, add a condition specifying that the flow should only run when the 'Assigned To' field is empty, or when a specific status flag is met.

What happens if a SharePoint list item is deleted before assignment?

If you base the rotation on the SharePoint item ID (which sequentially increases), a deleted item will simply skip that specific ID. This means one team member might be skipped in that exact rotation cycle, but the round-robin sequence will continue smoothly for future items.

Can I assign items based on a custom counter instead of the Item ID?

Yes. You can store a counter value in a separate SharePoint list or an environment variable. The Power Automate flow would retrieve this counter, assign the item based on its current value, and then increment the counter for the next flow run.

Office Quick Solutions