Extract Text by Expression in Power Automate

PDF4me Extract Text by Expression action retrieves specific text patterns from PDF documents in Power Automate using powerful regular expression matching. This precision extraction feature targets exact data patterns like invoice numbers, email addresses, phone numbers, dates, and custom formats, with page-specific control, returning matched text as array for automated data processing and validation 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 pattern-based extraction services.

Get your API Key

Key Features

• Regular Expression Support: Use regex patterns for precise text matching
• Pattern-Based Extraction: Target specific data formats and structures
• Page-Specific Control: Extract from specific pages or all pages
• Array Output: Receive all matches as array for iteration
• Multiple Matches: Extract all occurrences of pattern in document

Parameters

Complete list of parameters for the Extract Text by Expression action. Configure these parameters to control pattern 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 • Must contain text for pattern matching • 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	Invoice.pdf
Expression***	String	Regular Expression Pattern • Regex pattern to match text • Use standard regex syntax • Examples: \\d{3}-\\d{3}-\\d{4} for phone, INV-\\d{5} for invoice numbers • Must be valid regex pattern	INV-\\d{5}
Page Sequence***	String	Page Selection • Pages where content should be extracted • Use numbers: 1,2,3 for specific pages • Use all for all pages • Use ranges: 1-5 for page ranges	all

Output

The PDF4me Extract Text by Expression action returns comprehensive output data for seamless Power Automate flow integration:

Table

Table View

Response data in a structured table format:

Parameter	Type	Description
Text List	Array of Strings	Array containing all text matches found by the expression

JSON

JSON Response Format

{
  "Text List": [
    "INV-12345",
    "INV-12346",
    "INV-12347"
  ]
}

Flow Integration

Power Automate Flow Usage

Use extracted text matches in subsequent actions:

• Data Validation: Validate extracted values against databases
• Database Import: Load matched data into systems
• Email Notifications: Send alerts with extracted information
• Conditional Logic: Route based on extracted values
• Excel Export: Save extracted data to spreadsheets
• API Integration: Send extracted data to external systems

Workflow Examples

The PDF4me Extract Text by Expression action in Power Automate provides comprehensive workflow templates designed for real-world business scenarios:

Invoice Number Extraction

Automated Invoice Number Extraction and Validation

Transform invoice processing with automated invoice number extraction:

Complete Workflow Steps:

1. Trigger: Invoice PDF received via email
2. Get Invoice: Extract PDF from email attachment
3. Extract Invoice Number: Use regex INV-\\d{5} to find invoice number
4. Validate Format: Check extracted number matches expected format
5. Check Duplicates: Query database for existing invoice number
6. If New: Process new invoice in accounting workflow
7. If Duplicate: Flag for review and notify AP team
8. Archive Invoice: Store with extracted invoice number as metadata

Business Benefits:

• Extracts invoice numbers from 300+ invoices monthly
• Prevents duplicate invoice processing
• Reduces manual number entry errors by 100%
• Accelerates invoice validation by 80%

Create Flow

Email Extraction

Automated Email Address Extraction from Documents

Streamline contact management with automated email extraction:

Complete Workflow Steps:

1. Trigger: Business card scan or contact PDF uploaded
2. Get Document: Retrieve PDF from upload folder
3. Extract Emails: Use regex [a-zA-Z0-9._%+-]+@[a-zA-Z0-9.-]+\\.[a-zA-Z]{2,} to find emails
4. Validate Emails: Check email format validity
5. Remove Duplicates: Filter out duplicate addresses
6. Import to CRM: Add email addresses to Dynamics 365
7. Create Contact: Generate contact records for each email
8. Email Confirmation: Send import summary to sales team

Business Benefits:

• Extracts emails from 100+ documents weekly
• Automates contact list building
• Eliminates manual email transcription
• Accelerates CRM data entry by 90%

Create Flow

PO Number Extraction

Automated Purchase Order Number Extraction

Optimize order processing with automated PO number extraction:

Complete Workflow Steps:

1. Trigger: Order confirmation PDF received from supplier
2. Get Confirmation: Retrieve PDF from email
3. Extract PO Number: Use regex PO-\\d{6} to find PO number
4. Validate PO: Check against open purchase orders in ERP
5. Match Order: Link confirmation to original PO
6. Update Status: Mark PO as confirmed in system
7. Calculate Delivery: Estimate delivery based on confirmation
8. Email Procurement: Notify procurement team of confirmation

Business Benefits:

• Processes 150+ order confirmations monthly
• Automates PO matching and tracking
• Reduces order tracking errors by 85%
• Accelerates order confirmation processing by 70%

Create Flow

Date Extraction

Automated Date Extraction for Deadline Tracking

Enhance deadline management with automated date extraction:

Complete Workflow Steps:

1. Trigger: Contract or agreement PDF uploaded
2. Get Document: Retrieve contract PDF
3. Extract Dates: Use regex \\d{2}/\\d{2}/\\d{4} to find dates
4. Parse Important Dates: Identify start date, end date, milestones
5. Create Calendar Events: Add dates to Outlook calendar
6. Set Reminders: Create reminder tasks 30 days before deadlines
7. Update Database: Log contract dates in tracking system
8. Email Stakeholders: Send date summary to contract owners

Business Benefits:

• Extracts dates from 75+ contracts monthly
• Automates deadline tracking and calendar creation
• Reduces missed deadlines by 95%
• Ensures proactive deadline management

Create Flow

Industry Use Cases & Applications

Finance & Accounting

Finance & Accounting Use Cases

• Invoice Numbers: Extract invoice and order numbers
• Account Numbers: Parse account identifiers from statements
• Transaction IDs: Extract transaction reference numbers
• Amount Extraction: Parse monetary values from documents

Legal & Professional Services

Legal & Professional Services Use Cases

• Case Numbers: Extract case and matter numbers
• Date Extraction: Parse important legal dates and deadlines
• Reference Numbers: Extract citation and reference identifiers
• Contact Information: Parse attorney and client contact details

Healthcare & Medical

Healthcare & Medical Use Cases

• Patient IDs: Extract patient identification numbers
• Medical Record Numbers: Parse MRN from documents
• Insurance Numbers: Extract policy and claim numbers
• Test IDs: Parse lab test reference numbers

Corporate & Business

Corporate & Business Use Cases

• Order Numbers: Extract purchase and sales order numbers
• Product Codes: Parse SKU and product identifiers
• Reference Numbers: Extract tracking and reference codes
• Contact Details: Parse phone numbers and email addresses

Get Help

PDF4me ConnectGet your API KeyPower Automate Documentation