Good afternoon all!
I'm a fairly new user to Flows, and I can see that the topic of assigning multiple people to a task in Planner via Flows is an on-going one. I've done enough research to get myself about 90% of the way over my particular hurdle, so I'm hoping somebody might have some insight into how I can get this project across the finish line.
My particular conundrum is that I have many-bucketed Plan that needs to have a specific user(s) assigned depending on which bucket that task happens to be moved to. I've worked out a way around the limitation of only being able to assign a task to a user at only the creation point of the task (with a recurrence and delay timer - see flow layout below). However, I haven't figured out how to pull the correct users into the assignment part of the flow. From my research, it seems to make the most sense to be using a Sharepoint list to accomplish getting the users, but now I need to be able to select and assign the particular user(s) based on the bucket the task happens to be in.
Currently, my Sharepoint list has these headers:
The Status_Combined column is a calculated column that pulls together info from the Status_Number and Status_Description columns to give me the full name of all the various buckets I've created. Bucket_ID was an earlier attempt to make this Flow work by getting the Bucket IDs from a List Buckets function and manually copying that info into this list. That column is not currently servicing any functions. Team_Label is for a hope of a future attempt to figure out how to update labels (I've found a few things that lead me to believe it's possible with some very clever programming and automation). Task_Assignment_All is a Person/Group type multi-choice column that contains the names of the user(s) that I need to assign to any given task that lands in the bucket named in Status_Combined. For reference, this is what the Status_Combined data looks like in part:
As mentioned above, I've figured out how to use a Timer and Delay to check if a task has been moved from one bucket to another to determine which tasks need to be updated. I have done this by gathering all the task details at Flow initialization, Delay for a set amount of time, then gathering those again. I use a Condition to check if the BucketID for each task is equal for both of those runs. If the BucketIDs are not equal, it moves to the next phase of updating the Task assignment.
I've now got the flow to a point where it will get ALL of the users listed in the Task_Assignment_All column of my Sharepoint list. Which is a victory in itself for me! But, I need to be able to filter that down so it will only assign the user(s) that are in the same row as the name of the bucket the task currently resides in.
Any insight or thoughts on how I can accomplish that or improve the efficiency of this Flow would be ever so greatly appreciated!
For reference, here is the current layout of the Flow:
1.
2.
3.
4.
The text of the concat function there is: concat(item()?['Email'],';',variables('FinalAssignedTo'))
5.
6.
7.
For reference, I got the idea for some of this flow from here: https://powerusers.microsoft.com/t5/Building-Flows/Adding-multiple-assigned-to-planner-tasks-and-outlook-event/m-p/108359#M10611.
Thanks all!
