How to Automatically Update a SharePoint HR Training List with Power Automate
Question details
The user needs to automatically update training hours and staff details in a separate HRM list whenever a record in a SharePoint training log is added or its status is marked as Done.

- Product
- Microsoft SharePoint and Power Automate
- Device & OS
- not provided
- Scenario
- Managing employee records and ensuring training hours are accurately reflected across multiple interconnected HR lists without manual data entry.
- Observed behavior
- SharePoint list formulas cannot natively retrieve or update values from a different list, requiring an automated workflow solution.
Ensure you have the necessary edit permissions for both the source training log and the destination HRM list in SharePoint, as well as an active Microsoft Power Automate license to create flows.
Create a Power Automate Flow to Sync SharePoint Lists
Since SharePoint lacks built-in cross-list formulas, use Power Automate to trigger an automatic update when a training record is modified.
SharePoint Online does not have a native feature to push data from one list to another automatically. By setting up a Power Automate flow, you can bridge this gap. The flow will listen for changes in your training log and update the corresponding employee record in your HRM list when specific conditions are met.
Open Microsoft Power Automate, create a new Automated Cloud Flow, and select the 'When an item is created or modified' trigger for SharePoint. Point it to your site address and select the Training Log list.
Click 'New step' and add a 'Condition' control. Set the criteria to check if the 'Training Status' value is equal to 'Done'. This ensures updates only occur when a course is completed.
In the 'If yes' branch, add the 'Get items' SharePoint action. Select your HRM list and use an OData Filter Query (e.g., Title eq 'EmployeeName') to find the exact staff member based on the attendee lookup value.
Add an 'Update item' action. Use the dynamic content from the previous steps to map the newly earned training hours to the corresponding training-hour fields in the HRM list, then save and test your flow.

Looking for a Lightweight Office Suite? Try WPS Office
While SharePoint and Power Automate handle your backend list logic, creating the actual HR training materials, spreadsheets, and presentations is easier with a fast, reliable desktop suite. WPS Office provides a complete, free alternative to Microsoft Office for your daily document management.
- 1. Download the software: Visit the official WPS Office website and download the free installer for your operating system.
- 2. Install and launch: Run the installer, complete the quick setup process, and open the WPS Office dashboard.
- 3. Manage your documents: Open your existing Excel HR logs and Word training manuals instantly with full compatibility and no formatting loss.

Frequently Asked Questions
Can I use SharePoint calculated columns to pull data from another list?
No, SharePoint calculated columns and list formulas cannot reference or retrieve data from external lists or different sites. You must use Power Automate or a custom Power Apps form to achieve cross-list functionality.
What is the correct Power Automate trigger for SharePoint status updates?
You should use the 'When an item is created or modified' trigger. To prevent infinite loops or unnecessary runs, add trigger conditions in the settings, or use a 'Condition' action immediately after to verify if the status column equals your target value.
Why isn't my flow updating the secondary HRM list?
This usually happens if the lookup criteria in the 'Get items' action does not exactly match the employee identifier in the HRM list (such as an email or ID mismatch), or if you are trying to update a read-only column. Double-check your OData Filter Query formatting.




