SharePoint Document Issues

Automatically Import PDF Form Data into SharePoint List Fields

Amos GikundaAmos Gikunda Nov 20, 2026 868 views

Question details

The user wants to extract values from standardized PDF forms and automatically copy them into SharePoint list fields.

Automatically Import PDF Form Data into SharePoint List Fields
Product
Microsoft SharePoint and Power Automate
Device & OS
not provided
Scenario
Standardized PDF forms need to supply data for new or existing SharePoint list items.
Observed behavior
The desired outcome is to extract form values and map them to the corresponding SharePoint columns automatically.
Before you start

Identify where the PDFs will be stored, which values must be extracted, and the SharePoint columns that should receive them. Check whether the PDFs contain fillable fields or are scanned documents, and collect representative samples for testing.

Solution 1Recommended

Use Power Automate and AI Builder to extract and map PDF data

Use this approach when PDFs arrive in a SharePoint document library and you can use an AI Builder document-processing model.

Train and publish a document-processing model that extracts the required values from representative forms. AI Builder availability, licensing, and processing capacity depend on your organization's plan.

1
Prepare the list and model

In SharePoint, create or identify the destination list columns. In AI Builder, create a document-processing model, upload representative PDF forms, label the values to extract, and publish the trained model.

2
Create the flow

In Power Automate, select Create and build an automated cloud flow. Choose the SharePoint trigger for a file created in a library and select the site and library that will receive the PDFs.

3
Extract the values

Add the SharePoint Get file content action, using the file identifier from the trigger. Then add the AI Builder document-processing action, select the published model, and provide the PDF content.

4
Map values to list columns

Add the SharePoint Create item action, select the destination site and list, and map each extracted value to its matching column. To update an existing item instead, use Update item and supply the correct list item ID.

5
Test the flow

Save the flow and upload a sample PDF to the monitored library. Check the flow run history and the SharePoint list item to verify the extracted values and column mappings.

Use Power Automate and AI Builder to extract and map PDF data
Allow for extraction errors: Test different form samples, especially scans, and add a review or error-handling step if missing or incorrectly recognized values could affect the list.
Free Microsoft Office alternative

Review PDF forms and Office files with WPS Office

WPS Office is a free, lightweight alternative for working with PDF forms and Office documents in a familiar interface. Its format compatibility can help with a smooth move from Microsoft Office, although it does not provide the SharePoint list automation described above.

Open and review PDF forms before setting up an extraction workflowWork with Microsoft Office formats, including Word, Excel, and PowerPoint filesUse a familiar interface to ease the transition from Microsoft OfficeAccess a free, lightweight office suite for everyday document work
microsoft office alternative - wps office

Frequently Asked Questions

Can SharePoint automatically extract PDF values into a list by itself?

The described workflow requires an extraction and integration solution, such as a Power Automate flow with AI Builder or custom code. Configure the extracted values to map to the destination list columns.

Can I update an existing list item instead of creating a new one?

Yes. In Power Automate, use the SharePoint Update item action instead of Create item and provide the ID of the existing list item. You may need an earlier step to find the correct item.

Will the same approach work for scanned PDFs?

Scanned PDFs require text recognition. An AI Builder document-processing model or another extraction tool with OCR can process them, but results should be tested against representative scans.

Do I need a license to use AI Builder in Power Automate?

AI Builder use depends on your organization's licensing and processing capacity. Check the available AI Builder credits and Power Automate connector entitlements with your Microsoft 365 administrator before building the flow.