'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Build a Secure Employee Training Logbook in SharePoint
Question details
The user needs to create a centralized employee training logbook with a visual interface where employees can only see their own data, but managers can view all records.
- Product
- SharePoint
- Device & OS
- not provided
- Scenario
- Creating a secure, multi-section centralized training logbook for employees with strict access controls and a user-friendly form.
- Observed behavior
- The goal is to implement a visual form-style interface with editable templates instead of a raw list, ensuring private user data and manager-level global access.
Ensure you have Site Owner or Full Control permissions on your SharePoint site to modify list settings, and verify your Microsoft 365 license includes Power Apps access for form customization.
Configure Item-Level Permissions in SharePoint
Apply item-level restrictions in the SharePoint list settings so employees can only read and edit their own logbook entries, while managers retain full visibility.
By default, all members of a SharePoint site can view all items in a list. To ensure privacy for employee logbooks, you must adjust the advanced settings to restrict view and edit access based on the item creator.
Navigate to your SharePoint site, open the list you created for the training logbook, click the Settings gear icon in the top right, and select 'List settings'.
Under the General Settings column, click on 'Advanced settings'.
Locate the 'Item-level Permissions' section. Change 'Read access' to 'Read items that were created by the user' and change 'Create and Edit access' to 'Create items and edit items that were created by the user'.
Scroll to the bottom of the page and click 'OK' to save. Employees will now only see their own logbook entries.
Customize the User Interface with Power Apps
Create a visual, multi-tab form interface to replace the default SharePoint list view, making it easier for employees to fill out training logs.
Manage Training Records Effectively with WPS Office
If configuring SharePoint permissions and Power Apps forms is too complex, WPS Office provides a free, lightweight alternative for managing employee records. You can easily create secure training logbook templates using WPS Spreadsheet, which offers seamless compatibility with Microsoft Excel.
- 1. Download WPS Office: Visit the official WPS website and download the free office suite.
- 2. Create a Logbook Spreadsheet: Open WPS Spreadsheet and design your logbook template with different tabs for training sections.
- 3. Set Sheet Protection: Go to the 'Review' tab and select 'Protect Sheet' to restrict editing permissions for specific cells.
Frequently Asked Questions
Can I prevent employees from seeing the names of other staff members in the list?
Yes, by configuring 'Item-level Permissions' to 'Read items that were created by the user', an employee will only see the rows they submitted. The rest of the list will appear empty to them, effectively hiding other staff members' data.
Does customizing a SharePoint form with Power Apps require a premium license?
No. Customizing a SharePoint list form using the standard SharePoint connector in Power Apps is included in most standard Microsoft 365 business and enterprise licenses. Premium licenses are only required if you connect to premium external databases.
How do I update the central template for all users if requirements change?
If you are using a Power Apps customized form, you simply open the Power Apps Studio, make the necessary field adjustments or add new tabs, and publish the app again. The changes will instantly reflect for all employees accessing the SharePoint list.
Why can managers still see entries when item-level permissions are active?
SharePoint overrides item-level permissions for users who have 'Cancel Checkout' permissions, which is typically included in the 'Design' or 'Full Control' permission levels. Managers assigned these roles will maintain full visibility of the logbook.
