Building a Flow from Sharepoint List to Planner

[Stephen_Dixons]

Hi,

I am trying to build a flow from a sharepoint task list to create a task in planner.  I have managed to get this to work and create a task in the planner with the correct information.  The problem I have is adding the assigned users, if I select the Assigned User IDs as "Assigned to email" it works ok if there is only one assigned user.  If I had two or three users to the assignment I get two or three new entries of the same task in planner.  Any ideas please?

[Rahber]

Can you please show your flow?

So we can see why is it creating multiple tasks instead of adding the people to same task

[Stephen_Dixons]

I was told it was because it sits inside "Apply to each" but it will not let me use Assigned to email without it applying to each

[v-alzhan-msft · Accepted solution]

Hi @Stephen_Dixons ,

Does the Assigned user column allow multiple selections?

If yes, you should refer to screenshot below to create the flow:

Best Regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Rahber]

that is true. Apply to each as loop that is running on assigned to people.

Do one thing.

Initialize a variable outside the apply to each lets call it userEmails

Then in your apply to each use the action append to variable and make sure in that action you have ; after your variable name

Now move the planner action outside your apply to each and in the assigned to each use the variable userEmail. Example i am using List of Items variable here you can use your own functionality

Please click Accept as Solution if it resolved your problem or give it a Thumbs Up if it helped you in anyway this will allow other people to search correct solutions effectively.

Thanks,
Rahber

[Stephen_Dixons]

@v-alzhan-msft 

I have tried this and now it moves further along but it fails on the create a task saying "the assignee id is invalid"

Thanks

Stephen

[v-alzhan-msft]

Hi @Stephen_Dixons ,

Could you please share the screenshot of the configuration of the flow?

Please make sure that you have choose the Assigned user Emails dynamic content from the trigger in the Append to array variable action, and the dynamic content would followed by a ";".

Best Regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Stephen_Dixons]

[v-alzhan-msft]

Hi @Stephen_Dixons ,

Please share the full screenshot of the configuration of the flow and the full run history of the flow so we could better understand your issue and provide the proper workaround.

Best Regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-alzhan-msft]

Hi @Stephen_Dixons ，

Does your issue still exists?

Best Regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.