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) List all Tasks
2) Get Task Details
3) Get a Task
any advice?
Thanks
2 Replies
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)
)
- I also need help with this -- following the convo for a solution.
