cancel
Showing results for 
Search instead for 
Did you mean: 

Planner - Get more task details

it would be grate to implement the following Planner task information

 

  • completed by Username (the User who checked the task)
  • task link (hyperlink to plannertask)
  • assigned to (which users are assigned to the task)
Status: New
Comments
Anonymous
Not applicable
If they hadn't blocked the Graph Odata feed in Power BI, that would have given us a work around.

Assign to is in the web service. They just have to fix their implamentaion of get task details to iterate that item or give us a specific action to get it. It's completely doable. They just need to finish what they started and not leave this action incomplete.
New Member

Currently the Action "Get Task Details" only returns the Task Title and Description. It would be very useful if more information can be retrieved via the Task Details action (e.g. Comments, Assigned To, Label, Attachment, Dates, Checklist). I'm thinking of scenarios like creating a SharePoint Item or Excel line based on the information after task completion (and Approval).

Advocate II

Just can't figure out why this is such a big deal to add assigned to.  Crazy oversite that renders exporting data from Planner useless.  All the work done to help people export data is wasted without this field. 

Advocate IV

I voted!

 

Please be a lad and vote my idea, to increase the approval timeout (or just general timeout) of flows to MORE THAN 30 DAYS!!

 

I'm at 155 votes, more is better.

Thanks!!

 

https://powerusers.microsoft.com/t5/Flow-Ideas/Increase-approval-timeout-to-more-than-30-days/idi-p/...

Regular Visitor

All details: Description, Label, Attachment, Comments etc.

ASAP

Please

Anonymous
Not applicable

Labels, Assigned To, Dates, and the Checklist are all things that you can already access with some creativity. We have flows that build reports based on what currently has a specific label and it shows who that task is assigned to with the due date, created date and completed date. The only thing that isn't accessible as far as I can tell is the comments. They're not handled by planner. If other's would like to know, post here and I'll provide the solution. 

Advocate I


@Anonymous

How do you access the assigned to in a usable format within flow?

Anonymous
Not applicable

It's not Ideal but you can access the first assignee. The method is outlined here:

https://powerusers.microsoft.com/t5/Flow-Ideas/access-to-assignee-parameter-in-planner-Tasks/idc-p/1...

New Member

@Anonymous, thanks for the feedback. Can you explain how to access the labels and dates in a usable format within flow?

Anonymous
Not applicable

Similar to how you read the assignments. You just need to access ['appliedCategories'] which are what Planner calls labels. Each label is then called "Category1", "Category2" etc. If you look at the JSON that the get task action pulls in you'll see them.

 

Now I think, but don't take my word for this, that the categories are named according to their position in planner. It is for us. Your mileage may vary. 

1.JPG

 

So to check for the testing label I use this:

 

@contains(string(items('Apply_to_each_2')?['appliedCategories']), 'category1')

You don't need to access the label. You just need to check for it. That way you can filter however you want. 

 

I use this to build a table a table of all tasks that have the testing label. It contains the task title, bucket, assignee, and due date. The due date, completed date, start date, and created date are all accessible as dynamic content.