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!
Works like a dream, thanks! The key was to use ListTasksV2, which I had never understood the difference in.
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
WarrenBelz
146,763
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
66,091
Most Valuable Professional