Skip to main content

Notifications

Community site session details

Community site session details

Session Id : gxdpDn8qfsDCUzbZvKnMY9
Power Apps - Building Power Apps
Answered

Listing tasks ASSIGNED TO a certain user from Planner in PowerApp

Like (0) ShareShare
ReportReport
Posted on 22 Sep 2022 12:03:54 by

Hi all, 

 

My company is involved in a weekly reporting system in which a manager reviews the tasks completed by a certain user in the week and then gives certain adjectival ratings based on pre-determined KPIs. I have referenced this post :

Solved: List User's Planner tasks - Power Platform Community (microsoft.com)

About listing a specific user's planner tasks. This is the formula I've used for a gallery in PowerApp, where PlannerIDs is a dropdown with the Planner ID for the Plan in question and Dropdown1 displays the email address of the user who is being assessed, and it works exactly as it is supposed to:

Filter(Planner.ListTasks(PlannerIDs.Selected.id).value, createdBy.user.id=Office365Users.UserProfile(Dropdown1.Selected.Title).Id And completedDateTime>(Today()-Weekday(Today(),3)))

 

HOWEVER, I would like to list the tasks that were ASSIGNED TO a certain user, as opposed to those that are brought up using "createdBy.user.id" or, as the original post suggests, "completedBy.user.id" because it is not always the case that a task is created by or completed by the user to whom it was assigned (often in our morning agile meeting the scrum master marks off completed tasks for group understanding and accountability rather than the assignee themself completing the task). 

 

Is it possible to rework the formula where only those items that were assigned to a user will show up in the gallery view on our PowerApp?

 

Thanks!

  • Community Power Platform Member Profile Picture
    on 23 Sep 2022 at 07:40:39
    Re: Listing tasks ASSIGNED TO a certain user from Planner in PowerApp

    Works like a dream, thanks! The key was to use ListTasksV2, which I had never understood the difference in. 

  • Verified answer
    v-bofeng-msft Profile Picture
    on 23 Sep 2022 at 05:26:47
    Re: Listing tasks ASSIGNED TO a certain user from Planner in PowerApp

    Hi @Anonymous ,

     

    Please try:

     

    Filter(
     Planner.ListTasksV2(PlannerIDs.Selected.id).value, 
     Office365Users.UserProfile(Dropdown1.Selected.Title).Id in _assignments.userId And 
     completedDateTime>(Today()-Weekday(Today(),3))
    )

     

    Best Regards,

    Bof

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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,763 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,091 Most Valuable Professional

Leaderboard
Loading started