Skip to main content
Power Automate
    • Connectors
    • Templates
    • Take a guided tour
    • Digital process automation
    • Robotic process automation
    • Business process automation
    • Process advisor
    • AI Builder
  • Pricing
  • Partners
    • Blog
    • Documentation
    • Roadmap
    • Self-paced learning
    • Webinar
    • Business process and workflow automation topics
    • Overview
    • Issues
    • Give feedback
    • Overview
    • Forums
    • Galleries
    • Submit ideas
    • User groups
    • Register
    • ·
    • Sign in
    • ·
    • Help
    Go To
    • Microsoft Power Automate Community
    • Welcome to the Community!
    • News & Announcements
    • Get Help with Power Automate
    • General Power Automate Discussion
    • Using Connectors
    • Building Flows
    • Using Flows
    • Power Automate Desktop
    • Process Advisor
    • AI Builder
    • Power Automate Mobile App
    • Translation Quality Feedback
    • Connector Development
    • Power Platform Integration - Better Together!
    • Power Platform Integrations
    • Power Platform and Dynamics 365 Integrations
    • Galleries
    • Community Connections & How-To Videos
    • Webinars and Video Gallery
    • Power Automate Cookbook
    • Events
    • 2021 MSBizAppsSummit Gallery
    • 2020 MSBizAppsSummit Gallery
    • 2019 MSBizAppsSummit Gallery
    • Community Engagement
    • Community AMA
    • Community Blog
    • Power Automate Community Blog
    • Community Support
    • Community Accounts & Registration
    • Using the Community
    • Community Feedback
    cancel
    Turn on suggestions
    Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
    Showing results for 
    Search instead for 
    Did you mean: 
    • Microsoft Power Automate Community
    • Galleries
    • Power Automate Cookbook
    • Round Robin Assignment

    Round Robin Assignment

    11-17-2019 15:12 PM

    aprildunnam
    Memorable Member
    12956 Views
    LinkedIn LinkedIn Facebook Facebook Twitter Twitter
    aprildunnam
    aprildunnam Memorable Member
    Memorable Member
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    Round Robin Assignment

    ‎11-17-2019 03:12 PM

    Screen Shot 2019-11-17 at 4.53.03 PM.png

     

    Title: Round Robin Assignment

    Description: This flow monitors a shared mailbox for a keyword and checks against a SharePoint list that contains a list of staff members to automatically pick an employee, forward the email and assign a task in Planner.

    Detailed Instructions: Create a SharePoint list called TeamMembers.  In addition to the included Title Column, add another single line of text column called Email.  Populate this list with the name of the team member in the Title field and their email address in the Email field.  Create one more SharePoint list called Counter.  Create a number column called Value.  Create one item in this list with 0 as the title, leave the Value blank. 
    Questions: I am open to answering questions about this Flow. Please ask right here as a reply.

    Anything else we should know:  This is particularly useful if you have leads that come in and you want to evenly distribute them to your sales team to follow up on.

    watch?v=Vs0Wd2W2qrI

    Preview file
    152 KB
    RoundRobin_20191117225004.zip
    Preview file
    152 KB
    Labels:
    • Labels:
    • Automated Flows
    Message 1 of 9
    12,956 Views
    5 Kudos
    Reply
    • All forum topics
    • Previous Topic
    • Next Topic
    piersm2
    piersm2
    Regular Visitor
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎03-02-2020 01:57 PM

    I am getting ID #1 twice in a row.  Can you assist?

    Message 2 of 9
    12,616 Views
    1 Kudo
    Reply
    TT_2007
    TT_2007
    Regular Visitor
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎01-10-2021 08:49 AM

    Hi April, I am trying to build further condition to allocate task only to the members who are available. For this this i have added a column called "Availability" with value "Available" and "Not available" in the member list. I want flow to consider availability of members and allocate the new task among available member using "Round Robin Assignment". Please assist. I am very new to the flow so need your expert input. Thanks

    Message 3 of 9
    5,897 Views
    0 Kudos
    Reply
    bfcavaco
    bfcavaco
    Frequent Visitor
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎04-16-2021 02:39 PM

    Hi April,

     

    I have a flow very similar to yours and the round robin fails when multiple emails arrive at the same time, all the tasks are assigned to the same user, only after these assignments the variable in the sharepoint list is updated. I tried several approaches but with no success. This method only works when emails arrived 1 at a time with some interval between.

    Is there a workaround for this problem?

     

    Thanks.

    Message 4 of 9
    5,325 Views
    0 Kudos
    Reply
    vargasjo
    vargasjo
    Frequent Visitor
    In response to bfcavaco
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎04-17-2021 06:30 AM

    Hello,

     

    you should try at the settings on your trigger activate concurrency control set it to 1 so this way it only process 1 flow at a time, if you get 2 emails at the same time it will put the second on hold untill finish the first one, this worked like a charm for me.

     

    Best Regards

     

    vargasjo_0-1618666115062.png

     

    Message 5 of 9
    5,316 Views
    0 Kudos
    Reply
    bfcavaco
    bfcavaco
    Frequent Visitor
    In response to vargasjo
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎04-17-2021 07:05 AM

    Hi, vargasjo

     

    Thanks a lot for the reply.

    Works like a charm 😀

     

    Thank you.

     

    Message 6 of 9
    5,314 Views
    0 Kudos
    Reply
    EvilGretzky
    EvilGretzky
    New Member
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎05-14-2021 12:56 PM

    I keep getting hit with the following error. How can I troubleshoot further?

     

    The execution of template action 'Apply_to_each' failed: the result of the evaluation of 'foreach' expression '@outputs('GetCounter')?['body/Value']' is of type 'Float'. The result must be a valid array.
    Message 7 of 9
    5,140 Views
    0 Kudos
    Reply
    Ank4
    Ank4
    New Member
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎05-23-2021 11:37 AM

    Hello,

    I have a query on this flow ,I am getting error on get info team member I am using get item action , Error cannot find the file 

    Any suggestions I followed April's video still getting this. Error any suggestions?

    Message 8 of 9
    5,070 Views
    0 Kudos
    Reply
    mbeans
    mbeans
    Frequent Visitor
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎12-27-2022 12:43 PM

    I keep getting an errror on "counter initialize" (Unable to process template language expressions in action 'Counter_Initialize' inputs at line '0' and column '0': 'The template language function 'int' was invoked with a parameter that is not valid. The value cannot be converted to the target type.')

     

    anyone have any ideas?

    Message 9 of 9
    699 Views
    0 Kudos
    Reply

    Power Platform

    • Overview
    • Power BI
    • Power Apps
    • Power Pages
    • Power Automate
    • Power Virtual Agents

    • Sign up free
    • Sign in

    Browse

    • Templates
    • Connectors
    • Partners

    Downloads

    • Mobile
    • Gateway

    Learn

    • Documentation
    • Learn
    • Support
    • Community
    • Give feedback
    • Blog
    • Pricing

    • © 2023 Microsoft
    • Contact us
    • Trademarks
    • Privacy & cookies
    • Manage cookies
    • Terms of use
    • Terms & conditions
    California Consumer Privacy Act (CCPA) Opt-Out Icon Your California Privacy Choices