cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
syed_sme
Helper II
Helper II

Planner assigneePriority Value to excel table

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.

1 ACCEPTED SOLUTION

Accepted Solutions

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. 



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA

View solution in original post

10 REPLIES 10
v-bacao-msft
Community Support
Community Support

 

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,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
ChristianAbata
Community Champion
Community Champion

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.



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA
jimmydagher
Regular Visitor

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.

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.

 

 

 

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. 



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA

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
Frequent Visitor

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
Not applicable

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
New Member

Dear,

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

 

Regards

Matthew1900
Frequent Visitor

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

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power Automate Designer Feedback_carousel.jpg

Help make Flow Design easier

Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!

Top Solution Authors
Users online (2,108)