Multifilter gallery with a column choice

[Rubio_Damien]

Hi the community,

I have generate multifilter gallery and there is no problem.

But now i need to have in first choice to filter in a column of a list of nine column, is it possible ? I join a picture Who will be more clear probable than my explain.

Could Someone could help me ? 

[Rubio_Damien]

@CNT Any idea ?

[CNT]

@Rubio_Damien I understood what u'r trying to do. But u'r columns name are a bit confusing. So, I demo the concept with some IceCream 🍦!

I have DropDown with the column names.

I have a TextInput to enter the Filter Value and a Gallery to Show the results as seen below.

The formula for the Items property of the Gallery

Filter(myIceCream, 
    If(DropdownFilterColumn.Selected.Value="Ice Cream ID", ID=Value(TextInputFilterValue.Text),
    DropdownFilterColumn.Selected.Value="Ice Cream Flavour", Flavor in TextInputFilterValue.Text,
    DropdownFilterColumn.Selected.Value="Ice Cream Quantity", Quantity in TextInputFilterValue.Text
    )
)

Please follow the same pattern for u'r 9 fields

Hope this helps!

[Rubio_Damien]

Sorry i'm very bad ! I have rename my dd menu and try to translate with my table. Attach a file of where i am, in the second and third line if i have understand the code the left part is to say wich column display but i don't understand right part ?

If you want more detail it's possible and if you think it's to difficult for me i understand too 🤣

[CNT]

@Rubio_Damien The left part is which column you want to filter in and the right part is the value. If it's a number column, you will say myColumn=Value(textField.Text). If it's a text column, you will say myColumn in textField.Text.

Hope this is clear!

[Rubio_Damien]

I'm sorry i don't arrive to the result, i will try to do something more easier for me. 

I arrive to nothing as soon as i want to do a complex filter... thanks for your time and sorry to arrive to nothing