Filter Gallery Based on Button And / Or Toggle

[omi18]

Hello,

As shown below I have a gallery getting filtered by combo box and search field. What I'm trying to do is once we get results based on combo box selection. The user should be able to filter the gallery based on toggle tool selection. 

Any Suggestions?

Thanks,

Omi

[zmorek]

Here's a nice short video on how to filter a gallery by multiple criteria:

https://www.youtube.com/watch?v=kLGglidmPxg

It should help! You might need to buttons to set a variable in order to have the gallery filter based on its value, but that should be about it.

[WarrenBelz]

@omi18 ,

You did not provide any code or field/control names, but this should be the syntax required

Search(
   Filter(
      YourListName,
      (
         IsBlank(YourComboBox.Selected.xxxx) || 
         YourFieldName=YourComboBox.Selected.xxxx
      ) &&
      YourYesNoFieldName.Value = YourToggleName.Value
   ),
   YourTextSeachBoxName,
   "YourFieldToSearchOn"
)

also xxxx will depend on the Items of your Combo Box.

Please click Accept as solution 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 Thumbs Up.

[omi18]

Hi @WarrenBelz ,

Thanks for your reply.

For Toggle1 I have a default property set to: Distinct(Filter('Database',ID=First(ComboBox.SelectedItems).ID),Processed) but getting an error "Boolean value expected"

And in the Database, I have 1 for True and 0 for False.

And For Gallery I Have: Sort(Search(Filter('Database',ID=ComboBox.Selected.ID,Hrs>0),InsSearchBar_2.Text,"Name","Team","Fullname"),LastName,Ascending)

And for the flag in the gallery Color set to: If(ThisItem.processed=true,RGBA(54, 176, 75, 1),RGBA(255, 191, 0, 1))

What I'm trying to achieve is once the user gets the result in the gallery then the gallery can be filtered based on the toggle. 

Let me know if you need more information.

Best,

Omi

[WarrenBelz · Accepted solution]

Hi @omi18 ,

Are you sure this is a numeric field (1 or 0)?  I suspect a Boolean (yes/no) as you have referred to Processed as one. Assuming the toggle is linked to Processed, then the Default of the toggle should be

Parent.Default

I am not sure where you are heading with the code you posted.

If you simply want to filter by Processed based on the Toggle value (whether it is linked to anything or not)

Sort(
   Search(
      Filter(
         'Database',
         Processed=YourToggleName.Value
      ),
      InsSearchBar_2.Text,
      "Name",
      "Team",
      "Fullname"
   ),
   LastName,
   Ascending
)

Please click Accept as solution 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 Thumbs Up.

[omi18]

Hi @WarrenBelz ,

it worked. 

Thanks,

Omi