Can we filter the Planner Tasks instead of getting all of them

(0) Share

Report

Posted on by johnjohnPter

2,057 Season of Giving Solutions 2025

I have the following formula to get all the planner tasks:-

Collect(colRelatedPlannerTasks,
Planner.ListTasksV3(planner.id,group.Value).value);

now how i can dynamically filter those tasks based on the AssignedTo user and the Completion status? currently i am getting all the tasks and then filter them, but is there a more efficient way so we only get the needed filtered planner tasks?

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

SpongYe 5,909 Super User 2026 Season 2 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @johnjohnPter

Try this:

Filter( Planner.ListTasksV3(planner.id, group.Value).value, Office365Users.UserProfileV2("test@yourdomain.com").id in _assignments.userId )

Source: Filter Planner Tasks by Assigned User (Powerapps)

If you have any questions or feedback, please let me know. Have a great day! 😊

-----------------------
PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube| [My blog]

I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻

Was this reply helpful? Yes No
johnjohnPter 2,057 Season of Giving Solutions 2025 on at

Like
a
(0)

Report
Copy link

Link copied!

@SpongYe thanks for the formula, and what about the Completion percentage ? which can be 0, 50 or 100? can i filter the planner tasks based on them ? Thanks

Was this reply helpful? Yes No
SpongYe 5,909 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @johnjohnPter

You can expand the filter:

Filter( Planner.ListTasksV3(planner.id, group.Value).value, Office365Users.UserProfileV2("test@yourdomain.com").id in _assignments.userId, (CompletionPercentage = 0 || CompletionPercentage = 50 || CompletionPercentage = 100) )

If you have any questions or feedback, please let me know. Have a great day! 😊

-----------------------
PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube| [My blog]

I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻

Was this reply helpful? Yes No
johnjohnPter 2,057 Season of Giving Solutions 2025 on at

Like
a
(0)

Report
Copy link

Link copied!

@SpongYe i got an error that "CompletionPercentage" is not recognized

Was this reply helpful? Yes No
Verified answer

SpongYe 5,909 Super User 2026 Season 2 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @johnjohnPter

The CompletionPercentage is returned in the responsse as percentComplete.

So the formula would be:

Filter( Planner.ListTasksV3(planner.id, group.Value).value, Office365Users.UserProfileV2("test@yourdomain.com").id in _assignments.userId, (percentComplete = 0 || percentComplete = 50 || percentComplete= 100) )

If you have any questions or feedback, please let me know. Have a great day! 😊

-----------------------
PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube| [My blog]

I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻

Was this reply helpful? Yes No
johnjohnPter 2,057 Season of Giving Solutions 2025 on at

Like
a
(1)

Report
Copy link

Link copied!

@SpongYe worked well thanks a lot for your help.

Was this reply helpful? Yes No