cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Dr0idy
Level: Powered On

Planner Tasks - Filter Gallery by _assignment

I am trying to filter a gallery of planner tasks by assigned user using a drop down for selecting the user. Can't seem to get it to work. The best attempt i have come up with is : 

 

SortByColumns(
    Filter(
        Planner.ListTasksV2("QnqX9FLyrEOMBuZ-jGlaRpYAC55R").value,
        bucketId = ListBox1.Selected.id,
        Countif(_assignments.value,id=ComboBox2_1.Selected.id)>0
    ),
    "dueDateTime",
    Ascending
)

Cant seem to get this to work. I was able to get a list of the asignments to display in a combobox using 

ForAll(
    Planner.GetTaskV2(Gallery4.Selected.id)._assignments,
    LookUp(
        Office365Groups.ListGroupMembers("d490059b-543b-4203-a6f4-91818454f99b").value,
        userId = id
    )
)

The planner is built in a team site so the office group is the list of possible assignments.

 

Anyone got any advice about this?

1 ACCEPTED SOLUTION

Accepted Solutions
Dr0idy
Level: Powered On

Re: Planner Tasks - Filter Gallery by _assignment

I fixed this myself (literally minutes after posting) for anyone else who might be wondering how to do this the correct filter formula was

 

SortByColumns(
        Filter(
            Planner.ListTasksV2("QnqX9FLyrEOMBuZ-jGlaRpYAC55R").value,
            bucketId = ListBox1.Selected.id,
            CountIf(_assignments.userId,userId=Radio1.Selected.id) > 0
        ),
        "dueDateTime",
        Ascending
)

1 REPLY 1
Dr0idy
Level: Powered On

Re: Planner Tasks - Filter Gallery by _assignment

I fixed this myself (literally minutes after posting) for anyone else who might be wondering how to do this the correct filter formula was

 

SortByColumns(
        Filter(
            Planner.ListTasksV2("QnqX9FLyrEOMBuZ-jGlaRpYAC55R").value,
            bucketId = ListBox1.Selected.id,
            CountIf(_assignments.userId,userId=Radio1.Selected.id) > 0
        ),
        "dueDateTime",
        Ascending
)

Helpful resources

Announcements
firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

SecondImage

PowerApps Monthly Community Call

Next Wednesday, September 18th at 8am PDT

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

SecondImage

Power Platform Summit North America

Register by September 5 to save $200

Users Online
Currently online: 148 members 4,588 guests
Please welcome our newest community members: