Gallery Filter based on a combo box while having a search box as well

[OsmandFernando]

Dear Experts, 

In my inventory , the inventory balance Gallary I want to have with 2 options. 

1. With a search box to search Items

2. With a combox filter to filter the gallery based on the Item type  

At the moment I am able to set only one set of formula to the Gallery Items Property

This is the formula I want to give, 

Sort(
If(IsBlank(ItemSearchText_2),ItemMaster,Search(AddColumns(ItemMaster,"ItemwithSpec",'Item and Spec'),ItemSearchText_2.Text,"ItemwithSpec")),
ID, Descending
);If(IsBlank(ComboBox1.Selected.Value),'ItemMaster',Filter(ItemMaster,'Type of Item'.Value=ComboBox1.Selected.Value))

There is no issue on the formulas , but I am not sure how we can use this

Osmand

[eka24]

Please did you say the formula is working, if so what is your request. If you can explain further.

Besides i see two formulas
Sort(
If(IsBlank(ItemSearchText_2),ItemMaster,

Search(AddColumns(ItemMaster,"ItemwithSpec",'Item and Spec'),ItemSearchText_2.Text,"ItemwithSpec")),
ID, Descending
)

And

If(IsBlank(ComboBox1.Selected.Value),'ItemMaster',Filter(ItemMaster,'Type of Item'.Value=ComboBox1.Selected.Value))

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[OsmandFernando]

@eka24  Thank you for your reply, 

What I want is to use both the Search box and dropdown filter with the same gallery. When search items using the search box gallery should filter, when I select the item type in the dropbox Gallery should filter. How can I do that?

Osmand

[OsmandFernando · Accepted solution]

Thank you @eka24  I found my answer via this video, 

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