Forum Discussion
How can we use SharePoint list to fill a Choice 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).
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.