Others

How to Automatically Update a SharePoint HR Training List with Power Automate

Camila MilosovichCamila Milosovich Nov 3, 2026 871 views

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.

Automatically Update a SharePoint HR Training List with Power Automate
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.
Before you start

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.

Solution 1Recommended

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.

1
Set up the flow trigger

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.

2
Add a condition for the training status

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.

3
Retrieve the matching HRM record

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.

4
Update the HRM list item

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.

Create a Power Automate Flow to Sync SharePoint Lists
Community Support: If you encounter complex lookup matching issues or need specialized guidance on advanced OData queries, posting your flow structure in the Microsoft Power Automate Community is highly recommended.
Free Microsoft Office alternative

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. 1. Download the software: Visit the official WPS Office website and download the free installer for your operating system.
  2. 2. Install and launch: Run the installer, complete the quick setup process, and open the WPS Office dashboard.
  3. 3. Manage your documents: Open your existing Excel HR logs and Word training manuals instantly with full compatibility and no formatting loss.
Seamlessly open, edit, and save Microsoft Word, Excel, and PowerPoint formats (.docx, .xlsx, .pptx).Design comprehensive offline HR training logs and track employee hours efficiently in Spreadsheets.Enjoy a lightweight installation with a familiar, easy-to-use tabbed interface.Free cross-platform support for Windows, Mac, Linux, iOS, and Android.
microsoft office alternative - wps office

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.