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 ?
Hi @KrzysztofKiser. I would approach this task that way:
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
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?
@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!
Michael E. Gernaey
497
Super User 2025 Season 1
David_MA
436
Super User 2025 Season 1
Riyaz_riz11
244
Super User 2025 Season 1