I have a sharepoint list with multiple line items assigned to various users. I am using planner to update the master list, then push eout emails and assign new planner tasks to members of staff. The flow goes something like
User A completes task in planer
Flow updates X items in sharepoint list
Flow send 1 email per unique assigned user from above items in sharepoint list
Flow assigns 1 planner task per unique user assigned (in different field) from above sharepoint list.
From the above list example the completion of a specific planner task would
Send 1 email to user1@company.com detailing tasks 1 & 2
Send 1 email to user2@companu.com detailing task 3
Create a follow up planer task for manager1@company.com called "Power Automate Doc Review"
Create a follow up planner task for manager2@company.com called "Power Automate Doc Review"
I have been able to complete the unique email portion of the flow, by following the solution in the below link.
https://powerusers.microsoft.com/t5/General-Power-Automate/microsoft-flow-get-all-items-with-distinct-Assigned-to-User-and/td-p/113348
But I cannot create 1 planner task. I always get 1 planner task created per sharepoint list item.
Any help, even with a basic solution of how to pass the assign user as a variable, then once all are collected from the list, pass this variable onto a newly created planner task for each unique value.
Thanks
