Hi everyone! I am new, learning PowerApps and would like to ask if somebody could help me with the following problem:
I have a gallery connected to a SP list containing various products, here is an example of the list:
| Product |
| Dogfood |
| Parrotfood |
| Collardog |
| Toysparrot |
I built a searchbox with Filter(in) which works well if you would like to search for every product that contains "dog" it will give you Dogfood and Collardog in the gallery. But I would like to separate those searches so that when I type in "*dog" it will give me only Collardog or if I type "dog*" it will only return Dogfood (or any wildcard character, doesn't have to be *) .
I tried to play with Startswith and Endswith but I am too inexperienced to set it up if it's even possible to do it with those functions.
I would appreciate any help! Thank you!
