Forum Discussion
How to get the planner task Progress using power automate?
I am trying to filter the planner tasks based on the Progress column:- i tried those 3 actions, but none of them will return or allow us to filter based on the Progress column: 1)...
Please have a look at the following blog post
https://tomriha.com/export-planner-task-status-as-text-instead-of-percentage-power-automate/
In my case, I'm loading tasks from the planner into the Task table, where I use the Status Reason column with the following values:
Therefore, I had to modify the expression as follows:
if(
equals(items('Apply_to_each_Safety_Task')?['percentComplete'],100),
5,
if(equals(items('Apply_to_each_Safety_Task')?['percentComplete'],0),
2,
3)
)