Forum Discussion
AGDWFT
Jun 06, 2023Copper Contributor
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