web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Filter Planner Tasks b...
Power Apps
Answered

Filter Planner Tasks by Assigned User (Powerapps)

(0) ShareShare
ReportReport
Posted on by 2

Hi guys,

 

i am currently working on a small Powerapps application to grant specific views on open tasks by specific predetermined team members. The user can predetermine the team members with a mypeople selection and the gallery than shall display a column for each team member with a sub gallery with rows for each tasks assigned to the specific team member. 

I have achieved the parent gallery with the names and also filled it with a sub gallery and the tasks from the specific Plan.

 

The formula used in the sub gallery is: Planner.ListTasksV3("XXXXX"; "XXXXX").value

 

However, I can not find a way to filter the tasks by the assigned person which is shown in the parent gallery. Hence, the all tasks within the plan are shown for each user.

 

View with two users and the same taskView with two users and the same task

 

I tried multiple filters but could not succeed.

Later on, I also want to integrate a filter by a specific Part within the title (as tasks are automatically generated)

Does anybody have an idea for me? (sorry if this may trivial for you, I am only starting out with powerapps right now).

 

 

Categories:
  • Verified answer
    v-bofeng-msft Profile Picture
    Microsoft Employee on at

    Hi @7Kali7 ,

     

    Please try:

    Filter(
        Planner.ListTasksV3("XXX","XXXX").value,
        Office365Users.UserProfileV2("test3@XXXXXXX.com").id in _assignments.userId
    )
     
    Best Regards,
    Bof
  • 7Kali7 Profile Picture
    2 on at

    Hey, sorry for the late reply. Thanks for the help, that worked great!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 382 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 329

#3
WarrenBelz Profile Picture

WarrenBelz 187 Most Valuable Professional

Last 30 days Overall leaderboard