Extract Table from PDF in Power Automate

PDF4me Extract Table from PDF action intelligently extracts tabular data from PDF documents in Power Automate as structured JSON format. This powerful data extraction feature recognizes table structures, parses rows and columns, includes page location information, and returns data in array format, enabling automated data import, analysis, and integration with databases, Excel, and business systems across Microsoft 365 workflows.

Authenticating Your API Request

To access the PDF4me Web API through Power Automate, every request must include proper authentication credentials. Authentication ensures secure communication and validates your identity as an authorized user, enabling seamless integration between your Power Automate flows and PDF4me's powerful table extraction services.

Get your API Key

Key Features

• Intelligent Table Recognition: Automatically detect and parse table structures
• JSON Output: Receive structured data in JSON array format
• Page Location: Track which page contains each extracted table
• Row/Column Parsing: Extract data with row and column structure preserved
• Multiple Tables: Extract all tables from multi-page documents

Parameters

Complete list of parameters for the Extract Table from PDF action. Configure these parameters to control table extraction.

Important: Parameters marked with an asterisk (***) are required and must be provided for the action to function correctly.

Parameter	Type	Description	Example
File Content***	Binary	Source PDF File Content • Map PDF file from previous action • PDF must contain tabular data • Supports PDFs from SharePoint, OneDrive, email • Can be dynamically retrieved from flows	[File Content from Get File]
File Name***	String	PDF Document Name • Name of the PDF file • Used for processing identification • Should include .pdf extension • Supports dynamic naming	DataReport.pdf

Output

The PDF4me Extract Table from PDF action returns comprehensive output data for seamless Power Automate flow integration:

Table

Table View

Response data in a structured table format:

Parameter	Type	Description
tableList	Array of Objects	Array containing all extracted tables with metadata
Page Number	Integer	Page number where the table is located
Table	Array of Arrays	Two-dimensional array representing table structure
Rows	Array of Strings	Individual row data from the table

JSON

JSON Response Format

{
  "tableList": [
    {
      "Page Number": 1,
      "Table": [
        ["Header1", "Header2", "Header3"],
        ["Row1Col1", "Row1Col2", "Row1Col3"],
        ["Row2Col1", "Row2Col2", "Row2Col3"]
      ],
      "Rows": ["Header1,Header2,Header3", "Row1Col1,Row1Col2,Row1Col3"]
    }
  ]
}

Flow Integration

Power Automate Flow Usage

Use extracted table data in subsequent actions:

• Database Import: Load table data into SQL or Dataverse
• Excel Export: Convert table JSON to Excel spreadsheets
• Data Processing: Transform and validate extracted data
• CRM Integration: Import table data to Dynamics 365
• Analytics: Analyze extracted data in Power BI
• API Integration: Send structured data to external systems

Workflow Examples

The PDF4me Extract Table from PDF action in Power Automate provides comprehensive workflow templates designed for real-world business scenarios:

Invoice Data Extraction

Automated Invoice Table Data Extraction

Transform invoice processing with automated table data extraction:

Complete Workflow Steps:

1. Trigger: Invoice PDF received via email
2. Get Invoice: Extract invoice PDF from email
3. Extract Tables: Parse invoice line item table
4. Parse Rows: Extract product, quantity, price from each row
5. Calculate Totals: Sum extracted amounts for validation
6. Import to System: Load line items to accounting database
7. Verify Against PO: Match extracted data with purchase orders
8. Email AP: Send extracted data summary for approval

Business Benefits:

• Extracts data from 300+ invoice tables monthly
• Eliminates manual line item entry saving 40 hours monthly
• Reduces data entry errors by 95%
• Accelerates invoice processing by 75%

Create Flow

Report Analysis

Automated Financial Report Table Extraction

Streamline financial analysis with automated table data extraction:

Complete Workflow Steps:

1. Trigger: Quarterly financial report PDF published
2. Get Report: Retrieve financial report from SharePoint
3. Extract Tables: Parse all financial data tables
4. Parse Revenue Table: Extract revenue by product line
5. Parse Expense Table: Extract expense breakdowns
6. Load to Excel: Create Excel workbook with extracted data
7. Create Analytics: Generate Power BI dashboard from data
8. Email CFO: Send Excel analysis with extracted tables

Business Benefits:

• Extracts data from 20+ financial reports quarterly
• Enables rapid financial analysis without manual data entry
• Reduces analysis preparation time from 8 hours to 30 minutes
• Improves decision-making with accessible structured data

Create Flow

Inventory Import

Automated Inventory Report Table Extraction

Optimize inventory management with automated table data extraction:

Complete Workflow Steps:

1. Trigger: Weekly inventory report PDF received from warehouse
2. Get Report: Retrieve inventory PDF from email
3. Extract Tables: Parse inventory data tables
4. Parse Items: Extract SKU, quantity, location from rows
5. Validate Data: Check for missing or invalid values
6. Import to System: Update inventory database with extracted data
7. Flag Discrepancies: Identify and report data anomalies
8. Email Warehouse: Send import confirmation with summary

Business Benefits:

• Imports 50+ inventory reports weekly automatically
• Eliminates manual inventory data entry
• Reduces inventory update time from 4 hours to 15 minutes
• Improves inventory accuracy with automated data import

Create Flow

Pricing Extraction

Automated Price List Table Extraction Workflow

Enhance pricing management with automated table extraction:

Complete Workflow Steps:

1. Trigger: Vendor price list PDF received
2. Get Price List: Retrieve vendor PDF from email
3. Extract Tables: Parse pricing tables from all pages
4. Parse Products: Extract product codes and prices
5. Compare Prices: Match against current pricing database
6. Identify Changes: Flag price increases/decreases
7. Update Database: Import new pricing to procurement system
8. Email Procurement: Send price change summary report

Business Benefits:

• Processes 30+ vendor price lists monthly
• Automates pricing database updates
• Reduces price update time from 3 hours to 10 minutes
• Enables rapid price comparison and analysis

Create Flow

Industry Use Cases & Applications

Finance & Accounting

Finance & Accounting Use Cases

• Invoice Line Items: Extract invoice table data for processing
• Financial Reports: Parse financial statement tables
• Expense Reports: Extract expense detail tables
• Account Summaries: Parse account activity tables

Operations & Logistics

Operations & Logistics Use Cases

• Inventory Reports: Extract inventory table data
• Shipping Manifests: Parse shipping table information
• Production Reports: Extract production data tables
• Price Lists: Parse vendor pricing tables

Sales & Marketing

Sales & Marketing Use Cases

• Sales Reports: Extract sales data tables
• Product Catalogs: Parse product specification tables
• Performance Metrics: Extract KPI tables from reports
• Customer Lists: Parse customer information tables

Healthcare & Medical

Healthcare & Medical Use Cases

• Lab Results: Extract test result tables
• Patient Data: Parse patient information tables
• Billing Tables: Extract medical billing data
• Research Data: Parse clinical trial data tables

Get Help

PDF4me ConnectGet your API KeyPower Automate Documentation