cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Advocate I
Advocate I

Recommendation for field with large amount of records

I'm creating an app for a client that will act as a whiteboard for managing rooms in their hospice. When updating a room they will need to select from a large list of patients (several thousand) stored in a SQL Azure database. I'm trying to figure out what would be the best field type to use so they can quickly search for a patient and assign them to the room. Would a combobox work best?

2 REPLIES 2
Highlighted
Dual Super User II
Dual Super User II

Re: Recommendation for field with large amount of records

@pvanolinda 

 

Combobox will show upto the delegation limit of 2k records

 

Better bet will be to create a gallery showcasing all the items and add a search box on the top for user to filter the gallery and select an item

 

It will be important to understand delegation to work with large data sets and make your App performant

 

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/delegation-overview

http://rezadorrani.com/index.php/2019/09/18/powerapps-delegation-with-sharepoint-as-a-data-source-wi...

 

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

 

Highlighted
Advocate I
Advocate I

Re: Recommendation for field with large amount of records

Thanks for the reply! It's a relational database so I need to get the PatientID into the corresponding field in the Rooms table. Would you recommend having a Gallery sitting beside the edit form that includes the Room info and, when a patient is selected from the Gallery, have it populate the field in the Room form? If so, any tips on how to do that?

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors
Users online (7,190)