Assign rating to individual Choice items?

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        |      2        

Option 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 this

If my post solved your issue or answered your query, please mark it as a Solution and give it a Like.