Filter in Powerapps Gallery

[elevate-me]

Hello everyone! I could really use your help. There are three filters associated with my gallery; however, only two (program and status) of the three are working. The drop downs are associated with my Sharepoint list but for some odd reason the gallery will not sort by team. Any ideas? Thanks a bunch! 🙂

[RandyHayes · Accepted solution]

@elevate-me 

"Sort by Team"???  Your formula has no sorting in it.  Do you mean that it will not filter by team?  If so, then you are missing that criteria in your formula.

Please consider changing your Formula to the following:

Search(
    Filter('Pre-Obligation Reviews',
        (varObligationSelect = 1 &&
         (IsBlank(ComboBoxProgram.Selected.Value) || Program in ComboBoxProgram.SelectedItems.Value) &&
         (IsBlank(ComboBoxStatus_1.Selected.Value) || PeObStatus in ComboBoxStatus_1.SelectedItems.Value) &&
         (IsBlank(ComboBoxTeam_1.Selected.Value) || Team in ComboBoxTeam_1.SelectedItems.Value)
        ) ||
        (!(varObligationSelect=1) &&
          (StartsWith('Created By'.Email, User().Email) || StartsWith('Team Leader''s Email'.Email, User().Email))
        )
    ),
    SearchboxFAO.Text,
    "Applicant_x0020_Name", "Title"
)
   

I hope this is helpful for you.

[elevate-me]

@RandyHayes thank you for the help. I did mean filter. Something new I learned. In the formula, remove the ".value" at the end of "selecteditems" and it works. Thank you so much!