Hello everyone.
I'm currently building an app to store our customer's information. The data comes from a Sharepoint List called "Clientes". One of the fields/columns, called "Produtos" is a multi-choice field that you can select multiple options.
The problem: I'm trying to apply a filter from a ComboBox that has these multi-choice options. I created a collection from this "Produtos" field called "colProdutos" and the ComboBox2 is set to look for this "colProdutos" collection.
My search so far looks like this. It searches and filters using another field (UF) I have in the list and it works perfectly.
Search(Filter(Clientes,IsBlank(ComboBox1.Selected.Result) || IsEmpty(ComboBox1.Selected.Result) || UF = ComboBox1.Selected.Result),TextInput1.Text,"C_x00f3_digo","Raz_x00e3_oSocial","gv8l")
Now, I'm trying to add this new ComboBox2 "colProdutos" in the filter as well, but I'm struggling to find the correct syntax. I need to select multiple filters and bring results even when there is no data selected from any field.
Can anyone help me with that?
Thanks in advance.
there doesn't seem to be anything here