Planner assigneePriority Value to excel table

(0) Share

Report

Posted on by 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.

I have the same question (0)

All responses (10)

Answers (1)

v-bacao-msft on at

Like (0)

Report

Re: Planner assigneePriority Value to excel table

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,

Was this reply helpful? Yes No
ChristianAbata 8,949 Most Valuable Professional on at

Like (0)

Report

Re: Planner assigneePriority Value to excel table

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.

Was this reply helpful? Yes No
jimmydagher 4 on at

Like (0)

Report

Re: Planner assigneePriority Value to excel table

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.

Was this reply helpful? Yes No
jimmydagher 4 on at

Like (0)

Report

Re: Planner assigneePriority Value to excel table

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.

Was this reply helpful? Yes No
Verified answer

ChristianAbata 8,949 Most Valuable Professional on at

Like (0)

Report

Re: Planner assigneePriority Value to excel table

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.

Was this reply helpful? Yes No
cdesavio 34 on at

Like (0)

Report

Re: Planner assigneePriority Value to excel table

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.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Re: Planner assigneeriority Value to SharePoint List

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

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Re: Planner assigneePriority Value to excel table

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.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (1)

Report

Re: Planner assigneePriority Value to excel table

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

Regards

Was this reply helpful? Yes No
Matthew1900 23 on at

Like (0)

Report

Re: Planner assigneePriority Value to excel table

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

Was this reply helpful? Yes No