Forum Discussion
How to show over 20000 records in a combo box field in PowerApps form
Naligurtan Try using formula like below for items property of combo box control:
Filter(
CustomersList,
IsBlankOrError(Self.SearchText) || Self.SearchText in CustomerName
)
Use SharePoint list and column names correctly as per your list setup.
By default this will show 2000 records. But, when user will search in the combo box search input, it will show relevant records based on search text.
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
Thanks ganeshsanap
It did not work.
It is not possible to search. I only can use the dropdown selection and it shows empty scrolling down fields.
What I need is: the combo box should be searchable. When users search a customer name, they can find it and select it as a value for that filed. Then at the submit, this value should be saved back into SharePoint list.
Naligurtan Try this formula once for combo box control:
Filter( CustomersList, IsBlankOrError(Self.SearchText) || StartsWith(CustomerName, Self.SearchText) )
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
Hi ganeshsanap,
It still shows empty scrolling space. Not possible to search and also cannot see any customers.
Can you share the screenshot if possible? What is the formula used for DisplayFields and SearchFields property of combo box control?
You can enable searching for combo box using it's properties and set above mentioned properties to your customer name column.
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.