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

Large Entity (30,000 records), primary (unique) field suggestions?, & will that affect record retrieval?

Hi guys,

 

I'm wondering if those with more experience can offer me some guidance.

 

I have a custom "contact" entity, which, up till now, I have been designing with the full name + state as the primary key (eg. john smith illinois). However, it's becoming apparent that I'm not going to be able to keep the primary field unique.

 

What is the best way to navigate this? My thoughts are:

1) I could add more data (eg. full name + address + state) to make it unique...

2) Or I could re-format the entity so that the primary field is an autonumber

 

If I went with 1), it seems a klunky way to design the entity. I'd love to know what others do instead.

 

If I went with 2), I'm worried that when I design my powerapp (model driven), if the primary key is a number, am I going to have difficulty populating the record search box with name/address/state autofill suggestions eg. if someone types in "John", I would like the suggestion drop down to show all the Johns, together with their address & state, so the user can select the right one.

 

Any guidance would be hugely appreciated, thx!

3 REPLIES 3
Community Support
Community Support

Hi @Madumi

Do you want to deal with the problem of primary field unique?

I think the second way that you listed is better.

As the searching function, you just need to search based on Name field, not primary field.

What's more, you could also consider use GUID field as primary field, which will always be unique.

Here's a blog about how to work with this kind of data for your reference:

https://powerapps.microsoft.com/en-us/blog/fun-with-guids/

 

 

Best regards,

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thanks so much Phoebe,

 

So if I understand you correctly, when I create my model driven powerapp, even when using autonumbers for primary keys, I can still create a search function on the name field to retrieve rows which will autofill the search results? i.e. if I typed "john," in the search box, I could still have john agnes, john brown, john campbell, etc, drop down for the user to select?

 

thanks!

Can anyone guide me...

 

When creating a new Entity, the Primary Field is officially described as the field which "will be shown to users when they need to select from a list of records."

 

So... If I use an autonumber instead of the user friendly text field, when I create a powerapp, am I going to be stuck with the unintelligible autonumber field in search results, or will I be able to populate the search results with a meaningful list of (text) records i.e. populating it from the other fields?

 

Or should I simply ensure that the primary field remains both unique as well as user friendly (text based)?

 

thanks!

Helpful resources

Announcements
News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

Power Apps Community Call

Power Apps Community Call- January

Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST

PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

Users online (5,513)