Announcements
Hi guys,
Not sure if this is possible but I have a 21K registers dataset in a SP list and I would like to use this list as data source in a Combobox and set the "IsSearchable" property as "true" to search inside the dataset the value that I'm looking for but not all the data is shown when I do this.
Any way to get this done?
Thanks
@CP0822
Items = Filter(yoursplist, StartsWith(yourcolumnname, Self.SearchText))
Anything else will be limited by delegation to a maximum of 2k items
Hi @Drrickryp
The keyword that users could use to search in the SP list might be in the middle of the description, It will work StarWith() with something like this?
Thanks.
You cannot Search inside a text in a large SharePoint list, only starts with.
Exactly, that is why I'm looking for a workaround.
Thanks for your answer.
Any workaround will come with a big performance hit. To avoid that use Dataverse or sql.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 397 Super User 2026 Season 2
Mohsin Ali 354
WarrenBelz 232 Most Valuable Professional
