Power Platform Community Forum Thread Details

Here i want to filter ComboBox1_15.Selected.Value and filter the gallery with the below code.
but i have commented this line (IsBlank(ComboBox1_15.Selected.Value) || 'Big Rocks' = ComboBox1_15.Selected.Value) for filtering but if i uncommented its showing the error as shown in image. i have items property of ComboBox1_15 as

Distinct(
   
        Gallery7_6.AllItems, 'Big Rocks'
       
    ).Value

how to filter using this

Switch(
        Radio1_4.Selected.Value,
        "Q1",
        Sort(
            Filter(
                Actuals_QPA,
                Title = Gallery3_1.Selected.Value &&
                TeamName = "-" &&
                Year = Dropdown2.Selected.Title &&
                Quarter = "Q1" &&
                Active = "Active" 
                
              
             // (IsBlank(ComboBox1_15.Selected.Value) || 'Big Rocks' = ComboBox1_15.Selected.Value)
            ),
            Modified,
            SortOrder.Descending
        ),
        "Q2",
        Sort(
            Filter(
                Actuals_QPA,
                Title = Gallery3_1.Selected.Value &&
                TeamName = "-" &&
                Year = Dropdown2.Selected.Title &&
                Quarter = "Q2" &&
                Active = "Active" 
             
             // (IsBlank(ComboBox1_15.Selected.Value) || 'Big Rocks' = ComboBox1_15.Selected.Value)
            ),
            Modified,
            SortOrder.Descending
        ),
        "Q3",
        Sort(
            Filter(
                Actuals_QPA,
                Title = Gallery3_1.Selected.Value &&
                TeamName = "-" &&
                Year = Dropdown2.Selected.Title &&
                Quarter = "Q3" &&
                Active = "Active" 
              
              //(IsBlank(ComboBox1_15.Selected.Value) || 'Big Rocks' = ComboBox1_15.Selected.Value)
            ),
            Modified,
            SortOrder.Descending
        ),
        "Q4",
        Sort(
            Filter(
                Actuals_QPA,
                Title = Gallery3_1.Selected.Value &&
                TeamName = "-" &&
                Year = Dropdown2.Selected.Title &&
                Quarter = "Q4" &&
                Active = "Active" 
              
              // (IsBlank(ComboBox1_15.Selected.Value) || 'Big Rocks' = ComboBox1_15.Selected.Value)
            ),
            Modified,
            SortOrder.Descending
        ),
        "YTD",
        Sort(
            Filter(
                Actuals_QPA,
                Title = Gallery3_1.Selected.Value &&
                TeamName = "-" &&
                Year = Dropdown2.Selected.Title &&
                Active = "Active"
               
                //(IsBlank(ComboBox1_15.Selected.Value) || 'Big Rocks' = ComboBox1_15.Selected.Value)
            ),
            Modified,
            SortOrder.Descending
        )
    ) 

Categories:

Power Apps Pro Dev & ISV

Hi rdsi

You cannot filter a gallery with a data set obtained from the same gallery (it creates a circular reference as you have seen. Your Combo Box Items need to be from somewhere else - probably distinct from your Data Source. You can also save yourself a lot of code on the gallery Items.

Sort(
   Filter(
      Actuals_QPA,
      Title = Gallery3_1.Selected.Value &&
      TeamName = "-" &&
      Year = Dropdown2.Selected.Title &&
      (
         Radio1_4.Selected.Value = "YTD" || 
         Radio1_4.Selected.Value
      ) &&
      Active = "Active" &&
      (
         Len(ComboBox1_15.Selected.Value) = 0 || 
         'Big Rocks' = ComboBox1_15.Selected.Value
      )
   ),
   Modified,
   SortOrder.Descending
)

If you really must get the Combo Box Items from the gallery, you need to duplicate the gallery filter apart from the target field

Distinct(
   Filter(
      Actuals_QPA,
      Title = Gallery3_1.Selected.Value &&
      TeamName = "-" &&
      Year = Dropdown2.Selected.Title &&
      (
         Radio1_4.Selected.Value = "YTD" || 
         Radio1_4.Selected.Value
      ) &&
      Active = "Active"
   ),
   'Big Rocks'
)

Please click 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 giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee