How to Export Word Template Data to a SharePoint List with Power Automate
Question details
The user wants to automatically extract data entered into a Word template and write it to a SharePoint list when a document is created or updated.
- Product
- Microsoft Word, Power Automate, SharePoint
- Device & OS
- not provided
- Scenario
- Automating data extraction from Word documents to populate a SharePoint list, which will then be used for Power BI reporting.
- Observed behavior
- The goal is to capture structured data entered in a Word template and send it to SharePoint without manual data entry.
Ensure you have access to Power Automate with the necessary connectors and that your target SharePoint list is already set up with columns matching the data fields in your Word template.
Use Structured Content Controls and Power Automate
Add developer content controls to your Word template so Power Automate can parse and extract the entered data into SharePoint.
The standard Power Automate Word connector cannot easily extract arbitrary text directly from a standard Word document. To make data readable by automation tools, the document must be designed as a structured template using Content Controls.
Open your Word template, go to File > Options > Customize Ribbon, and check the 'Developer' box in the right pane.
From the Developer tab, insert Plain Text Content Controls for each data field you want to extract. Click 'Properties' for each control and assign a unique, easily identifiable Title.
In Power Automate, create an automated cloud flow with the trigger 'When a file is created or modified (properties only)' pointing to the specific SharePoint document library where templates are saved.
Add an action to get the file content, then utilize a supported document extraction connector to parse the Content Controls. Finally, add a 'Create item' SharePoint action to map these extracted values to your destination SharePoint list columns.
Create and Edit Word Templates for Free with WPS Office
While Power Automate and SharePoint manage your automated workflows, you need a reliable tool to design your document templates. WPS Office is a lightweight, fully compatible alternative to Microsoft Word that lets you build and format document templates seamlessly.
- 1. Download and Install WPS Office: Visit the official WPS website and download the free installation package for your Windows, Mac, or Linux device.
- 2. Open Your Existing Templates: Launch WPS Writer and open your existing .doc or .docx template files without losing formatting.
- 3. Edit and Save Seamlessly: Make your necessary formatting changes and save the file in standard Microsoft formats to maintain workflow compatibility with your SharePoint libraries.
Frequently Asked Questions
Can I extract data from a standard Word document without using Content Controls?
It is extremely difficult for Power Automate to reliably parse unstructured text. Using Developer Content Controls ensures the data is strictly bound to designated fields that automated tools can identify and extract accurately.
Do I need premium connectors in Power Automate to extract Word data?
While some basic SharePoint triggers are included in standard licenses, interacting deeply with Word documents often requires premium connectors. You may also need premium third-party tools if native parsing doesn't meet your document's complexity.
Will Power BI update automatically when the SharePoint list receives new data?
Yes, once the SharePoint list is populated by Power Automate, Power BI can reflect these changes automatically if it is connected via DirectQuery or if you have configured a scheduled refresh for your dataset.
