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

secondImage

Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Power Apps June 2021

June Power Apps Community Call

Don't miss the call this month on June 16th - 8a PDT

Top Kudoed Authors
Users online (57,098)