Power Platform Community Forum Thread Details

I have a Gallery filter which is not working based on combobox selection. If i select the combobox value as My Requests, it should show my own requests. If i select combobox value as Pending my action, it should show requests where i am being assigned as a Manager.

By default, combobox will show MyRequests as preselected. Currently Gallery shows empty if i select any combobox value. May i know where i am going wrong?

Gallery Items

With(
    {
        _activerequests: SortByColumns(
            Filter(
                'Users',
                (Len('ETypeCB'.Selected.Value) = 0 || 'Employee Type'.Value = ETypeCB.Selected.Value) && (Len('LocationCB'.Selected.Name) = 0 || Location.Value = LocationCB.Selected.Name) && (Len(SwitchCB.Selected.Value) = 0 || (SwitchCB.Selected.Value = "My Request" && (AdUser.Email = User().Email)) && (SwitchCB.Selected.Value = "Pending my Action" && (Manager.Email = User().Email ))) && (StartsWith(
                    'First Name',
                    SearchBox.Text
                ) || StartsWith(
                    Title,
                    SearchBox.Text
                ))
            ),
            "Modified",
            SortOrder.Descending
        )
    },
    SortByColumns(
        _activerequests,
        varsortcolumn,
        varsortdirection
    )
)

ComboBox default selecteditems

{Value:"My Request"}

Categories:

AI Builder

Connector development

Building Power Apps

Experimental features

Governance & administering

Microsoft Dataverse with Power Apps

GCC, GCCH, DoD - Federal App Makers (FAM)

Error handling

Power Apps Pro Dev & ISV

Power Query

General topics

Hi @Poweruser32490,

I assume it is SwitchCB that you are referring to here. If that is the case, you need Or || instead of And && where shown below.

With(
   {
      _activerequests: 
      SortByColumns(
         Filter(
            'Users',
            (
               Len('ETypeCB'.Selected.Value) = 0 || 
               'Employee Type'.Value = ETypeCB.Selected.Value
            ) && 
            (
               Len('LocationCB'.Selected.Name) = 0 || 
               Location.Value = LocationCB.Selected.Name
            ) && 
            (
               Len(SwitchCB.Selected.Value) = 0 || 
               (
                  SwitchCB.Selected.Value = "My Request" && 
                  AdUser.Email = User().Email
               ) ||
               (
                  SwitchCB.Selected.Value = "Pending my Action" && 
                  Manager.Email = User().Email 
               )
            ) && 
            (
               StartsWith(
                  'First Name',
                  SearchBox.Text
               ) || 
               StartsWith(
                  Title,
                  SearchBox.Text
               )
            )
         ),
         "Modified",
         SortOrder.Descending
      )
   },
   SortByColumns(
      _activerequests,
      varsortcolumn,
      varsortdirection
   )
)

You also had a few redundant brackets I have removed.

Please ✅ Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider answering Yes to Was this reply helpful? or give it a Like ♥
Visit my blog Practical Power Apps LinkedIn