Automatically Import PDF Form Data into SharePoint List Fields
Question details
The user wants to extract values from standardized PDF forms and automatically copy them 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.
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.
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.
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.
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.
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.
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.
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.

Build a custom PDF extraction and SharePoint integration
Use custom code or a PDF extraction tool when you need direct access to fillable fields or a workflow tailored to your forms.
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.

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.




