cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Cooper01
Continued Contributor
Continued Contributor

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
Continued Contributor
Continued Contributor

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 Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Users online (1,335)