The 'Value' field should be set to '2' in the 'If yes' part of the program. Please update that in the video as it cost me a good 2-3 hours of time to figure out.
Hi, I have been searching for something like this for a while. This is gold! The only thing I would like to integrate, in my particular case is Schedule management. So in my list where all my users are, I have a Start Time and an End Time, this will determine their shift's. Where in your example would I slap my condition in to fact check if the (item created time) is within a user's shift?
Hi April, thank you for sharing this. Tried creating a flow as you recommended and was happy to see it working. Have one question though. How can I only assign the task to team members who are active? I tried adding in a filter in Get Items Team members but it kept routing only to the first active person. Any guidance for me?
I am trying to follow the instruction given in your video. and btw kudos to you... and thank you.. however i am getting an error about Correct to include a valid reference to "GetCounter' for the input parameter(s) of action 'Initialize_variable_2'.
Hello April, i'm having issues with the same user being returned each time, can you help with that? i have gone over this video time and time over but still not able to figure it out
I'm currently working through the flow and I'm getting an error when I try the expression "add(body('GetCounter')?['Value'],1)". I'm not sure if Flow has changed a rule but I'm guessing the function of "add" now only lets you actually add. I'm not sure if I need to concatenate the "add" expression/function or try a different function to lead that entire chain of expressions. Any suggestions? Thank you so much for putting this all together. It's always exciting to see complex flows put together.
Hi April thanks for the flow logic , I had a small query , I delete and add members in the SharePoint list. It fails the flow and error is item not found. Get items doesn't get updated if we make any changes in the SharePoint list?
Hi, thank you for this, Im having an issue where it fails at the Counter initialize and the error say: Unable to process template language expressions in action 'Initialize_Counter' inputs at line '0' and column '0': 'The template language function 'add' expects its first parameter to be an integer, a float or a decimal number. The provided value is of type 'Null'. Not sure waht the issue is
Doesn't work. Continually assigns to the first entry of the team member list. Would be nice to see an updated approach from you since other people in this comment section (and others where you've posted this content) are running into the same issue.
@April Dunnam I follow the instruction but I think I miss the integer formula for Next Counter Initialize, if I don't put one it repeats the same one, and if I put the same one as Counter Initialize it doesn't go back it continues adding Id. I have a list with 4 Users and it goes up to 6 and passes that as well. Please advise
Hi Nqoba - I would create a column in the list for "Active" that's a boolean field. When someone is one leave toggle that value to false. Then in the Flow you can limit the action to only get items where "Active" equals true
@@AprilDunnam Hi April, I'm very new to sharepoint lists and ms flow and would like to know how this can be done i.e. how do I limit the action to only get items where "Active" equals true in ms flow?
Hey Simon - should be simple to leverage CDS with this. Just re-create the list structure in a CDS table, the key being to have an AutoNumber field in your CDS table which is a single value so it can find the items. Replace the SharePoint Get Items action with the CDS List Rows action. Hope this helps!
Hi April. This tutorial is great! I ran into an issue though where my SharePoint list items are only getting assigned to the 3rd member on my team list. The counter seems to be working. I can't figure out what went wrong. Any ideas?
Hmmm I'm not sure. Someone else in the community took my flow template here and modified it a bit. Maybe their walk through will help: marqueeinsights.com/implementing-a-round-robin-in-power-automate/
I am stuck on the Count Initialize .... int(body('GetCounter')?['Value']) I get this error : Unable to process template language expressions in action 'Counter_Initialize' inputs at line '1' and column '43130': 'The template language function 'int' was invoked with a parameter that is not valid. The value cannot be converted to the target type.'.
For that case I would actually use the modified approach that was taken in this blog article. You can add an employee status field to check if that employee is available or on leave and only check against those who are marked available: marqueeinsights.com/implementing-a-round-robin-in-power-automate/
I got this working but the issue seems to be that if someone deletes an item from the SharePoint list that contains the user info then the whole thing breaks down. It think this is because the for the users is pulling in the ID of the users row in that sharepoint list (as it should) but the counter is going off of the number of records returned and then using that number to go get the 'correct' user from the list. This works great if you start with an empty list and enter X users and never delete. But if I delete record number 1 from the list and then run the flow the array might contain 5 users but those users will have IDs that start with 2 and go to 6. The counter sees 5 and then the flow passes that number (1, 2, 3, 4 or 5) to the list and if it passes a 1, the flow fails because there is no longer an ID 1 in the list. Any ideas on passing that last 'get user' action an ID that is NOT the counter but rather a 'lookup' of the counter into the array and then pulling out that array items' ID value?
@@AprilDunnam Hi, yes I'm working on a blog post and video detailing how we worked around the 'deleted' user issue we had in our implementation. With your permission, I will share a link to it in this thread when I have it up. In summary, though we added a 'LastAssigned' date field and an 'On Duty' Yes\No field to the user list. Then when we need a new user we do a GetItems but we filter for OnDuty=yes and we sort ascending by the LastAssigned field. Then we have the GetItems only return the Top 1 item. Because of the sorting, this means the record it returns is always the user that was last assigned the longest time ago. It worked so well that at first, I doubted it was actually working because there were so few 'moving parts.' :-)
@@briankennemer @april duannam, i am facing similar issue wherein my team members login and logoff continuously during their day either for breaks or other calls. Also, I want tickets to be assigned to them during their shift hours, which differs for everyone. hence I want to rely on OnDuty=Yes. so do you have a copy of this logic which i can download and utilize in my environment?
@@briankennemer Hi, I was wondering if you completed that blog post and video and where can I find the link if you did please? I am trying to achieve assigning tasks best on a complexity score of the total tasks a team member currently has and availability column and I believe your logic could help me achieve this. Thanks.
![Yeat & Quavo - 5BRAZY [Official Music Video]](http://i.ytimg.com/vi/4XxnTAwyxus/mqdefault.jpg)
Thanks again April, always wonderful
to learn from you!
Thank you Terri!
Hi April, Thanks for this video you saved me so much time. It's clear and easy to follow. Thank you!!!!
I love it when I can save someone time! Glad it was helpful 🙂
The 'Value' field should be set to '2' in the 'If yes' part of the program. Please update that in the video as it cost me a good 2-3 hours of time to figure out.
Just what I was looking for! Thanks a bunch April
Yay glad it helped Azure 😊
Hi, I have been searching for something like this for a while. This is gold!
The only thing I would like to integrate, in my particular case is Schedule management. So in my list where all my users are, I have a Start Time and an End Time, this will determine their shift's. Where in your example would I slap my condition in to fact check if the (item created time) is within a user's shift?
Hi April, thank you for sharing this. Tried creating a flow as you recommended and was happy to see it working. Have one question though. How can I only assign the task to team members who are active? I tried adding in a filter in Get Items Team members but it kept routing only to the first active person. Any guidance for me?
I am trying to follow the instruction given in your video. and btw kudos to you... and thank you.. however i am getting an error about Correct to include a valid reference to "GetCounter' for the input parameter(s) of action 'Initialize_variable_2'.
Hello April, i'm having issues with the same user being returned each time, can you help with that? i have gone over this video time and time over but still not able to figure it out
I'm currently working through the flow and I'm getting an error when I try the expression "add(body('GetCounter')?['Value'],1)". I'm not sure if Flow has changed a rule but I'm guessing the function of "add" now only lets you actually add. I'm not sure if I need to concatenate the "add" expression/function or try a different function to lead that entire chain of expressions. Any suggestions? Thank you so much for putting this all together. It's always exciting to see complex flows put together.
Hi April thanks for the flow logic , I had a small query , I delete and add members in the SharePoint list. It fails the flow and error is item not found. Get items doesn't get updated if we make any changes in the SharePoint list?
Hi, thank you for this, Im having an issue where it fails at the Counter initialize and the error say: Unable to process template language expressions in action 'Initialize_Counter' inputs at line '0' and column '0': 'The template language function 'add' expects its first parameter to be an integer, a float or a decimal number. The provided value is of type 'Null'. Not sure waht the issue is
If I wanted to create a condition to skip one of the team if their out of office is switched on, where would I insert that?
Doesn't work. Continually assigns to the first entry of the team member list. Would be nice to see an updated approach from you since other people in this comment section (and others where you've posted this content) are running into the same issue.
@April Dunnam I follow the instruction but I think I miss the integer formula for Next Counter Initialize, if I don't put one it repeats the same one, and if I put the same one as Counter Initialize it doesn't go back it continues adding Id. I have a list with 4 Users and it goes up to 6 and passes that as well. Please advise
Thats where I am Stuck as well the formula was int(body('GetCounter')?['Value'])
Hey, excellent video. I'm curious how you handle a team member on leave?
Hi Nqoba - I would create a column in the list for "Active" that's a boolean field. When someone is one leave toggle that value to false. Then in the Flow you can limit the action to only get items where "Active" equals true
@@AprilDunnam Hi April, I'm very new to sharepoint lists and ms flow and would like to know how this can be done i.e. how do I limit the action to only get items where "Active" equals true in ms flow?
@@AprilDunnam Hi April, can you do a video clip for this ?
I am getting ID 1 being chosen back to back. Any idea why?
Sorry for the delayed response. Are you still having this issue? If so could you share a screenshot of your list and flow config?
Hi April, Thank you so much for this video. Can you please help me in getting this workflow.
Tanks, great video. please how do i apply this to a common data service
Hey Simon - should be simple to leverage CDS with this. Just re-create the list structure in a CDS table, the key being to have an AutoNumber field in your CDS table which is a single value so it can find the items. Replace the SharePoint Get Items action with the CDS List Rows action. Hope this helps!
@@AprilDunnam Thanks, I'm going to try this out and tell you how it goes
Hi April. This tutorial is great! I ran into an issue though where my SharePoint list items are only getting assigned to the 3rd member on my team list. The counter seems to be working. I can't figure out what went wrong. Any ideas?
Hmmm I'm not sure. Someone else in the community took my flow template here and modified it a bit. Maybe their walk through will help: marqueeinsights.com/implementing-a-round-robin-in-power-automate/
I had the same issue. to fix: 1) change the condition to "is greater than" 2) if yes, the update item value should be 2.
@@chrishatch4769 Thank you thank you! Been bashing my head against this bug for more hours than I care to name )))
I am stuck on the Count Initialize .... int(body('GetCounter')?['Value']) I get this error :
Unable to process template language expressions in action 'Counter_Initialize' inputs at line '1' and column '43130': 'The template language function 'int' was invoked with a parameter that is not valid. The value cannot be converted to the target type.'.
Hi, were you able to resolve this? Im stuck in this error as well.
@April - anything to resolve this?
If user is on leave how to check through flow what functions we can add on that ?
For that case I would actually use the modified approach that was taken in this blog article. You can add an employee status field to check if that employee is available or on leave and only check against those who are marked available: marqueeinsights.com/implementing-a-round-robin-in-power-automate/
I got this working but the issue seems to be that if someone deletes an item from the SharePoint list that contains the user info then the whole thing breaks down. It think this is because the for the users is pulling in the ID of the users row in that sharepoint list (as it should) but the counter is going off of the number of records returned and then using that number to go get the 'correct' user from the list. This works great if you start with an empty list and enter X users and never delete. But if I delete record number 1 from the list and then run the flow the array might contain 5 users but those users will have IDs that start with 2 and go to 6. The counter sees 5 and then the flow passes that number (1, 2, 3, 4 or 5) to the list and if it passes a 1, the flow fails because there is no longer an ID 1 in the list. Any ideas on passing that last 'get user' action an ID that is NOT the counter but rather a 'lookup' of the counter into the array and then pulling out that array items' ID value?
I know you found a resolution for the issue. I'm going to update the description with a work-around for it.
@@AprilDunnam Hi, yes I'm working on a blog post and video detailing how we worked around the 'deleted' user issue we had in our implementation. With your permission, I will share a link to it in this thread when I have it up.
In summary, though we added a 'LastAssigned' date field and an 'On Duty' Yes\No field to the user list. Then when we need a new user we do a GetItems but we filter for OnDuty=yes and we sort ascending by the LastAssigned field. Then we have the GetItems only return the Top 1 item. Because of the sorting, this means the record it returns is always the user that was last assigned the longest time ago. It worked so well that at first, I doubted it was actually working because there were so few 'moving parts.' :-)
@@briankennemer @april duannam, i am facing similar issue wherein my team members login and logoff continuously during their day either for breaks or other calls. Also, I want tickets to be assigned to them during their shift hours, which differs for everyone. hence I want to rely on OnDuty=Yes. so do you have a copy of this logic which i can download and utilize in my environment?
@@briankennemer Hi, I was wondering if you completed that blog post and video and where can I find the link if you did please?
I am trying to achieve assigning tasks best on a complexity score of the total tasks a team member currently has and availability column and I believe your logic could help me achieve this.
Thanks.
Any reason why I keep getting 404 error on Get Team Member Info?
Did you ever figure this out?
I got the same error did you got any solution for this ?
int(body('getCounter')?['Value'])
length(variables('Users'))
add(body('GetCounter')?['Value'],1)