Hello, I need help because I'm going crazy in a moment, I'm trying to learn powerapps, but as soon as I solve one problem, three more appear. I have a gallery that lists the assortment for me, the table is filtered thanks to a formula that narrows the list view down to a category
If(filtr.Selected.Result = "Pokazuj wszystko";asortyment;Filter(asortyment;Grupa=filtr.Selected.Result))
I'd also like the list to be searched by the user using searchbox, and here's the code:
Filter(asortyment;StartsWith('Nazwa asortymentu';TextInput5.Text))
I've been struggling with it for an hour, I searched google but nothing works. PLEASE HELP!
Solved! Go to Solution.
With({asmt:Filter(
asortyment;StartsWith(
'Nazwa asortymentu';TextInput5.Text
)
)
};
If(
filtr.Selected.Result = "Pokazuj wszystko"; asmt;
Filter(
asmt;Grupa=filtr.Selected.Result
)
)
)
With({asmt:Filter(
asortyment;StartsWith(
'Nazwa asortymentu';TextInput5.Text
)
)
};
If(
filtr.Selected.Result = "Pokazuj wszystko"; asmt;
Filter(
asmt;Grupa=filtr.Selected.Result
)
)
)
THANK YOU!!!
will it be possible to make look in the whole text not only after the first word
ok the last question in this topic. At the moment I have a search but after the first word, how to force a search when, for example, a key word is in the middle
User | Count |
---|---|
165 | |
96 | |
78 | |
73 | |
59 |
User | Count |
---|---|
202 | |
166 | |
98 | |
94 | |
79 |