Round Robin with filters

(0) Share

Report

Posted on by KrzysztofKiser

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 ?

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Shuvam-rpa 897 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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

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!

Was this reply helpful? Yes No
KrzysztofKiser 26 on at

Like (0)

Report
Copy link

Link copied!

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.

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?

Was this reply helpful? Yes No
900cut 27 on at

Like (0)

Report
Copy link

Link copied!
Hi @KrzysztofKiser. I would approach this task that way:
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'.
The second is to identify the language of the form, I assume you fetch it from the form language and it works already;
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.
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.

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

Was this reply helpful? Yes No