Unanswered

Task assigned in Planner

(0) Share

Report

Posted on by drobles

Is there a way to set a trigger for when a user is assigned a task inside of planner? The only option I see is "assigned to me". I'm have all our task information go in a channel as different users update and complete their tasks.

Categories:

General topics

I have the same question (0)

All responses (9)

Answers (0)

Manish Solanki 15,167 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @drobles

You can get the information of completed tasks in teams channel using below actions:

but I could not find the action for update trigger. Trigger for task creation is also there.

If this helps, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

Was this reply helpful? Yes No
drobles 13 on at

Like (0)

Report
Copy link

Link copied!

Would this work if a task status is set to "inProgress"?

Was this reply helpful? Yes No
Manish Solanki 15,167 Moderator on at

Like (2)

Report
Copy link

Link copied!
Hi @drobles

I have designed a sample flow that will run on daily basis and extract the in-progress and completed tasks from planner and publish them to teams channel:
1. Set the schedule to run daily and use List tasks action to fetch all the tasks:

2. Next, filter the result to get in progress and completed tasks using percentage complete property:

3. Now, format the result obtained from filter array action:

expression used for if condition:
if(equals(item()?['percentComplete'],50),'In Progress','Completed')

4. finally, post the html table to teams channel:

I hope you have got some idea on publishing planner tasks information to teams channel.

If this helps, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

Was this reply helpful? Yes No
takolota1 4,980 Moderator on at

Like (1)

Report
Copy link

Link copied!

@drobles

I don’t know if you are willing to redesign your set-up, but it is possible to trigger something when an assigned column is changed in SharePoint.

And it is possible to get a Planner-like experience in a SharePoint list through the board views. Example shown in this template: https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/Project-Tracker-SharePoint-and-Teams/td-p/1788102

Was this reply helpful? Yes No
drobles 13 on at

Like (0)

Report
Copy link

Link copied!

Is there a way to show who the task has been assigned to?

Was this reply helpful? Yes No
Manish Solanki 15,167 Moderator on at

Like (1)

Report
Copy link

Link copied!
Hi @drobles

Yes, we can show the users to which the task is assigned to. The sample flow is as follows; it has become bigger now 🙂 -

Next, we will initialize variable for storing the owners (assigned to) for each task and other details like title, status etc.:

Now, using List tasks & filter array action, we will filter out the in progress & completed tasks:

Then, we will iterate on filter results and fetch the assigned to users for each task. As assigned to users can be multiple so we will again iterate "assignments" property and get all the assigned to users for each task:
Once we have a list of assigned to users close the 'Apply to each 2' loop. In the outer 'Apply to each' loop, combine the assigned to with other task details in 'varPlannerTasks' array and reset the 'varTaskOnwers' array:

Expressions used are:
join(variables('varTaskOwners'),',')
if(equals(item()?['percentComplete'],50),'In Progress','Completed')
finally, create a html table with the result of 'varPlannerTasks' and post the same to teams channel:

Belo is the post received in teams channel:

If this helps, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

Was this reply helpful? Yes No
drobles 13 on at

Like (0)

Report
Copy link

Link copied!

This is amazing! Is there away to filter these by a time frame? To just show the tasks from the current week?

Was this reply helpful? Yes No
drobles 13 on at

Like (0)

Report
Copy link

Link copied!

I also don't have admin approval on Azure. Is there another work around?

Edit: I was able to use "get users profile (v2)"

Was this reply helpful? Yes No
drobles 13 on at

Like (0)

Report
Copy link

Link copied!

Also is there a way to just show its "in progress" and void out the "complete" items

Was this reply helpful? Yes No