Add multiple assignees to a Planner task from Sharepoint list

(0) Share

Report

Posted on by ncvinegarbase

I am trying to create a flow:

- Blank Sharepoint list with "assigned to" column.

- Someone can add multiple names to that column.

- Upon modifying that column it triggers a create new task in Planner but have all the names from the "assigned to" Sharepoint column show up in the new Planner task.

How to handle this? If you could please post a detailed screen shot or describe what this flow should look like I would really appreciate it.

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

v-xiaochen-msft on at

Like (0)

Report

Hi @ncvinegarbase ,

Please try this

triggerOutputs()?['body/assignedto']

item()?['Email']

Best Regards,

Wearsky

Was this reply helpful? Yes No
ncvinegarbase 6 on at

Like (0)

Report

Unfortunately doesn't work, I am getting an error about invalid Email id.

Here is my current flow for the Sharepoint list to Planner task. It works for one person but when I add more people it creates a task for each of them instead of just putting all names in one task.

-When item or file is modified
-Get changes for an item or file (properties only)
-Condition equal to true
-If yes,
-Apply to each (Output set to Assigned to)
-Create a task (Assigned User Ids set to Assigned to)

Was this reply helpful? Yes No
ncvinegarbase 6 on at

Like (0)

Report

I though I finally figured it out.
After the item modification I had to:
-Initialize variable
-Apply to each
-Within apply to each, Compose concat for the email and variable
-Set the variable

But now, it shows up as two tasks with multiple assignees.

Was this reply helpful? Yes No
ncvinegarbase 6 on at

Like (0)

Report

Can you help to get this to only generate only one new task for multiple assigned users? This generates a multi assigned task to every assigned user.

Was this reply helpful? Yes No