I'm sorry for a possible duplicate post but none of the solutions I've found over here worked for me. I'm trying to have a simple search bar field that searches for some request types from my sharepoint list. Thanks for stopping by and trying to help me out.
Here are some of the screenshoots so then you can have a better understanding of my case. Thanks!
You have to put the formula I gave you into the Items property of the gallery.
The textbox default property is the default text value inside the textbox.
The Items property if a gallery define which items are displayed. So this is where you have to do the filter.
I would try this Filter('Leave Request', '<name of field in SharePoint list>' in TextSearchBox1.Text)..
The current formula seems to be searching within the app when it needs to be searching the actual Sharepoint datasource.
With that being said I would highly recommend you stay away from "in" when using SharePoint as it isnt delegable. More information on that here. My recommendation would be to download them into a collection perhaps using a filtered formula and then use the "in".. This should work much quicker..
All the best!
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
The largest Power BI, Power Platform, and Data conference in New Zealand