Planner assigneePriority Value to excel table

[syed_sme]

Hi all,

I've created a  Flow to add Planner bucket/tasks to an excel table, in a Document Library.

This is now working apart from Priority value. I can't seem to find the appropriate Dynamic content to use for the Priority field.

I used an expression (items('iterate_through_tasks')?['assigneePriority']) but this only brings back a numeric code instead of the given values - Urgent, Import, Medium, Low)

Is there another way to achieve this?

Hope someone can point me in the right direction.

[v-bacao-msft]

Hi @syed_sme ,

I did the same test on my side, and the results were consistent with what you described.

The value of assigneePriority that we can get seems to be unable to distinguish the rank.

Please check the REST API. The details of getting tasks mentioned here indicate that the value of assigneePriority we can get is in the number format, but it doesn't seem to tell us if we can distinguish the priority from numbers.

https://docs.microsoft.com/en-us/graph/api/plannertask-get?view=graph-rest-1.0&tabs=http#response-1

I'm afraid we can't know the specific priority through this value.

You could specify the priority of each task by adding a priority description to the description of the task.

Best Regards,

[ChristianAbata]

What you could do is just create a variable that means for you for example Urgent equals to 123 , normal 456, so then you can use a condition if the number is 123 is Urgent for you. 

I think the api way is another way.

[jimmydagher]

I've been trying to do the same in Powershell using only the API and my results are consistent, what makes it more difficult is that the majority of the task do not have a value for assigneePriority which makes it impossible to determine the rank

for example 8586320853961786934 is the number that identifies one of my items as Medium, but the large majority of the items do not have a number assign. so most likely the information is store somewhere else or is somehow combined with the hintOrder.

This was confusing to me:

https://docs.microsoft.com/en-us/graph/api/resources/planner-order-hint-format?view=graph-rest-1.0

Not sure how the are being shown in Excel or where is Microsoft are getting the information from.

[jimmydagher]

some additional info.

I took one of the task that wasn't assign to me and added myself to the assignee, then change the priority to Urgent. the missing assigneePriority got assigned a value and brought the task to the top of my priority list with number 8586205531703027813 

This means that the field is used to show what priority one of the assignees gave to the task.

sadly I took another task and move the priority to Urgent and the number assign to it was 8586235336594766132 which came in lower than 8586235333146418853 which is a medium

8586205531703027813 --> Urgent

8586235333146418853 --> Medium 

8586235336594766132 --> Urgent

so I'm not sure or don't believe the number we are looking for is stored in this value.

[ChristianAbata · Accepted solution]

Hi @jimmydagher  .... I test the values an are the same.

8586205531703027813 --> Urgent

8586235333146418853 --> Medium 

8586235336594766132 --> Urgent

So the solutions is a condition comparing this values. 

[cdesavio]

The numeric code changes for each task. So there is no direct correlation between the numeric code returned and the assigned priority (string). This numeric code is probably used in the display (Group by priority) in Planner to sort the tasks.

[abiman]

Can you provide more details. I am trying to create an item in sharepoint list when a new task is created.  Priority field is obviously not populating. What is the workaround to get the four different value Low, Medium, Important and Urgent.

Thanks

AM

[Anonymous]

Unfortunately, the assigneePriority will return a number but it's meant for sorting by priority and not actually distinguishing the values (i.e., Low, Medium, Urgent, Important) .

The numbers are dynamic based on the service, plan, and likely a combo of other variables. This code will change all the time.  So the assigneePriority code in Task A with priority Medium will be different then the assigneePriority code generated in Task B with priority Medium.

I'd love it if we could get the actual values as well since we're pulling in this data from Graph API and we actually have a need to know how many tasks are urgent, important, and so on. Hopefully that's coming down the pipes but it looks like we'll need to look at this field as a sort by priority field.

[Acvlima]

Dear,

Has anyone managed to solve or work around this behavior of the "assigneePriority" field?
I'm going through the same situation

Regards

[Matthew1900]

It seems like this community request to pull Priority level from Planner has been out there for years....has anyone heard an update?