Forum Discussion

AGDWFT's avatar
AGDWFT
Copper Contributor
Jun 06, 2023

Tracking CPD points for multiple people using Sharepoint lists

Hi everyone,

I have a bit of a complicated query so please bear with me. I'm building a website to keep track of CPD points for people in my organisation. Whenever they attend a seminar they earn a certain number of CPD points which is currently kept track of using an excel spreadsheet. The spreadsheet has a workbook for each person and contains the following information:

  • Date
  • Provider
  • Details of activity
  • Type of activity (seminar, webinar etc)
  • Location
  • Hours / times
  • CPD points

What I want to do is have a Sharepoint site where people only see their CPD activities and points listed. Right now I've got a single list with everyone's information on it (the information is in each column) and have created a PowerApps program to calculate and display a person's CPD score based on who is logged in (using the [Me] code in the Filter part of the view setting).

What I want to know is, should I be using separate lists for each person or just continue with putting everything in one huge list? I'm afraid things might get a little bit confusing if I just put everything in a big list, even though the user will only see their details.

 

Thanks so much!

No RepliesBe the first to reply

Resources