Forum Discussion
How can we use SharePoint list to fill a Choice Column
I imported a list of items from Excel into a SharePoint List. I’d like to use this list as the source for a Choice column across different libraries. Do I need to build a Power App to populate the column, or is there a way in SharePoint to link the Choice values directly to the list? If Power Apps is required, could you point me to resources on how to set this up?
I would like this to go in the following column
If your list or library is hosted within a single SharePoint site:
Option 1: Use a Lookup Column
Create a separate list with your values and use a Lookup column in your libraries to reference it. This keeps values dynamic and centrally managed.Option 2: Use a Site Column
Create a custom site column with predefined choices and add it to multiple libraries within the same site. This works like a Choice column but is reusable across lists/libraries.
If your list or library is hosted across multiple SharePoint sites:Option 3: Use Managed Metadata (Term Store)
Create a Managed Metadata column using the Term Store. This allows consistent tagging across site collections and is ideal for enterprise-wide taxonomy.
Option 4: Use Power Apps for Custom Forms
Design a Power Apps form that pulls values from a central source (like a SharePoint list or Dataverse table).
3 Replies
If your list or library is hosted within a single SharePoint site:
Option 1: Use a Lookup Column
Create a separate list with your values and use a Lookup column in your libraries to reference it. This keeps values dynamic and centrally managed.Option 2: Use a Site Column
Create a custom site column with predefined choices and add it to multiple libraries within the same site. This works like a Choice column but is reusable across lists/libraries.
If your list or library is hosted across multiple SharePoint sites:Option 3: Use Managed Metadata (Term Store)
Create a Managed Metadata column using the Term Store. This allows consistent tagging across site collections and is ideal for enterprise-wide taxonomy.
Option 4: Use Power Apps for Custom Forms
Design a Power Apps form that pulls values from a central source (like a SharePoint list or Dataverse table).Thank you. One more question, is the Lookup column allow multiple values?
Yes, you can enable multiple selections in a SharePoint Lookup column.
To do this:
- Go to the column settings.
- Click on More options.
- Enable the "Allow multiple selections" checkbox.
-------------------------------------------------------------------------------------
If my response helped you, please consider marking it as the accepted answer.
