Announcements
Hello:)As a topic:Which is better, faster etc: Choice field or separate list to select from. Applies to SharePoint.So far I have been using Choice.Thank you in advance for each entry.
I think it depends - will the choices expand or change over time? Are there a million choices? Might be easier to use a list, as you can manage that a little bit easier (vs. having to explain to a user how to navigate to the column options in the list itself). Not changing? Probably OK to use a choice column.
Some funky business can happen with choice columns, for example, you can't search it with Search() because it's not text; you'll end up having to use AddColumns() to get around that. Else if you just use a list, it's easier to search. Either way, not awful to have to do either.
Choice is when you are not looking at a dynamic list of options. List is basically when you plan to have dynamic data, also applies if you looking at child records with attributes(metadata) that maybe needed when processing or searching data.
@Thoma2008
I never use Choice columns, either I have a second list or I set that column type to single line of text and hard code the options in a radio control or dropdown ["Option1","Option2", etc]. As above, it mostly depends on whether the options will be added or if they are static and will not change. If dynamic, the second list can be added to the app and modified as needed within the app.
@zmorek @Silvester @Drrickryp
Thank you all for the hints.
@Thoma2008 ,1. It is based on your requirement, If you need to update your data frequently use SharePoint list to retrieve data. Because you don't need to every time update app. you may use another SP list.2. If data is default means you can use Dropdown is better way and coding also simple.3. If your data based on PowerApps to update any time / modified the data content like your one of the data or choice is "Name", now you update to "First name" or remove the "Name" filed or so on so modification do means "Go to Collection" use based on your requirementLot of way available. Simple and easy means go Dropdown / Collection. that is my suggestion to you. if need use Combo box also.Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways or you liked the post and want to show some appreciation, please give it a Thumbs Up.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 536
WarrenBelz 426 Most Valuable Professional
Haque 305
