Hi
Im trying to create a collection each time i enter something in a textinput.
ClearCollect(
collectNew,
Filter(
TestList,
(IDsingle = TextInput.Text)))
My issue is that it needs to be an exact match for it to collect, i want to collect the first 500 items that contains something like the text input.
For example if i type in the textinput = 2020 i want it to collect all items that contains 2020 in the IDSingle column. Currently it will only collect the exact input and if i dont know the exact input i will not generate anything