Forum Discussion
Assign rating to individual Choice items?
Hello, I'm trying to create a Sharepoint list of employees and their respective skills. Each skill has a rating from 1-4 indicating how proficient they are in it. Is there any way to implement this in a Sharepoint list besides manually creating 4 different versions of each skill? If not, is there a better way of implementing this? If possible, I want to keep this in Sharepoint to make it easy to access.
1 Reply
There are multiple ways to design this, and the right solution depends on how many skills you have, and based on exact use case.
Option 1 (OOTB): If the number of skills is small (e.g., up to 10 and common across all employees):
- You can create a single list with columns like:
- Employee (Person column)
- Skill 1 to Skill 10 (Choice 1,2,3,4)
- Each skill column can be a Choice or Number (1–4 rating)
For example:
Employee | SPFx | SharePoint | Power BI
User A (Email/Unique ID) | 3 | 4 | 2Option 2 (OOTB): If you have many or growing skill sets:
- Use a more scalable approach with separate lists:
- Skills list (all available skills)
- Mapping list or Employee Skills with:
- Employee (Person column)
- Skill (Lookup)
- Rating (Choice) (1–4)
This approach is more flexible and easier to maintain as your data grows. One row per employee + skill combination.
For example:
Employee | Skills | Rating |
User A (Email/Unique ID) | SharePoint | 4 |
User A (Email/Unique ID) | PowerBI | 2 |
User B (Email/Unique ID) | SharePoint | 1 |And you can use JSON formatting to improve UX by showing ratings Stars.
Option 3 (Low Code): OR you can Use Power Apps if your organization allows thisIf my post solved your issue or answered your query, please mark it as a Solution and give it a Like.
- You can create a single list with columns like:
