Skip to main content
Community site session details

Community site session details

Session Id : KJ9ymwqg9fOCZ8D/R95jzn
Power Automate - Building Flows
Unanswered

Round Robin with filters

Like (0) ShareShare
ReportReport
Posted on 17 Jul 2022 06:06:07 by 26

I've been trying to set up a round robin auto allocation of tasks from MS Forms via Power Automate.

I've set it up like this: https://www.youtube.com/watch?v=Vs0Wd2W2qrI

It's working fine, but I'm facing a problem where I have two additional columns in my employees list: "Language" and "Absent?".

I need Power Automate for the auto allocation to consider only employees where the language matches the language selected in the form and where the column "Absent?" is equal to "No".

Is there any way to accomplish this ?

  • 900cut Profile Picture
    27 on 17 Jul 2022 at 09:35:52
    Re: Round Robin with filters

    Hi @KrzysztofKiser. I would approach this task that way:

    1. Which languages can speak each team member. I assume it can be done but adding specific column 'lang' to that Team Members SharePoint list. Then, I would join all the input in that list, like 'English', 'German', 'Italian' to 'EnglishGermanItalian'.
    2. The second is to identify the language of the form, I assume you fetch it from the form language and it works already;
    3. I would filter the array 'Team members' and check if the language of the form is present in the languages of joined value 'EnglishGermanItalian' and if yes appoint the task to that team member.
    4. And then you take team members only from filtered output

    How to filter array (see the screenshot below). Sure you can filter with AND combining the language and the absence filter.

    Before the filter, I parsed my input, maybe for you it is not a needed step.

    900cut_2-1658050251904.png

     

     

    900cut_3-1658050473698.png

     

    Sorry, my answer can be with too short explanations. Hope anyway it will help you.

    BR
    Alexey

  • KrzysztofKiser Profile Picture
    26 on 17 Jul 2022 at 09:05:21
    Re: Round Robin with filters

    Thanks @Shuvam-rpa, I did that, but in the video, they use "Get Item" to get the team member info as the last step of the round robin.

    Screen Shot 2022-07-17 at 11.01.53 AM.png
    It looks up the ID on the entire list and "Get Item" does not have any filtering options.

    How do I approach this? I need the Get Item to lookup the ID, but only for employees where the language matches the Forms response and where the Absent column shows "No" (the same as in one of the previous steps).

     

    I am also facing another issue.
    Since I have a separate counter for each language, I used "Get Items" to retrieve the correct counter from the SharePoint list. Even though it will return only one value, I the "Counter Initialize" where I convert it to an integer does not work. It throws an error: 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.
    I think it's because Power Automate assums that by using "Get Items" I have move than one record.
    How could I go around it?

  • Shuvam-rpa Profile Picture
    891 Super User 2024 Season 1 on 17 Jul 2022 at 06:32:05
    Re: Round Robin with filters

    @KrzysztofKiser you can filter the get items by using odata query. Please check below screenshot as reference

     

    Shuvamrpa_0-1658039509926.png

    If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 1

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 1

Loading started
Loading complete