Hello all,
could you please help me to find a solution for my formula.
I have a box list where items on a sharepoint list is returned using the Filter method.
When i want to use it with a text input, i'm using:
Filter([@'Defect Status Portal'],StartsWith(Title,TextInput1.Text))
When i want to use a choice in my Combobox, i use:
Filter('Defect Status Portal', Status in ComboBoxStatus.SelectedItems)
booth are working well but how to use booth together, in one formula?
So i want or make a search with the text that i type on the textinput or make a search with the item that i choose in the combobox.
Thanks
