cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Cooper01
Responsive Resident
Responsive Resident

Max number items in choice field?

How many items can be in a choice/option set? This set will be associated with a choice column on a dataverse table

1 ACCEPTED SOLUTION

Accepted Solutions
ChrisPiasecki
Super User
Super User

Hi @Cooper01,

 

There is no official documented limit. I've heard some say 300, 500, and other values. That being said, if you're having to ask that question, I would advise to use a Table to store your options and create lookups to related tables that need to use this. Generally, beyond 20/30 items will often result in poor user experience.

 

---
Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up. 

View solution in original post

3 REPLIES 3
ChrisPiasecki
Super User
Super User

Hi @Cooper01,

 

There is no official documented limit. I've heard some say 300, 500, and other values. That being said, if you're having to ask that question, I would advise to use a Table to store your options and create lookups to related tables that need to use this. Generally, beyond 20/30 items will often result in poor user experience.

 

---
Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up. 

View solution in original post

Cooper01
Responsive Resident
Responsive Resident

Thanks @ChrisPiasecki!

 

Hope you don't mind a follow up question. Can you speak more to why the user experience would be different in using a table vs. a choice set? I would surface both in a dropdown list so I would think the experience would be the same.

ChrisPiasecki
Super User
Super User

Hi @Cooper01,

 

A lookup will have a combo-box control where you can search for the record. With a regular dropdown list from an option set, a very large list would require lots of scrolling to get to the item you want. Additionally, if you ever need to get rid of an option in the future, it will cause a problem if there are existing/historical records referencing that option.

 

---
Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Users online (73,056)