Add Text Header Footer to Excel in Power Automate

PDF4me Add Text Header Footer to Excel action enables adding customizable text headers and footers to Excel documents in Power Automate with comprehensive formatting control. This versatile feature supports document titles, page numbers, dates, branding, and custom text with full control over font styling (family, size, color, name), transparency levels, rotation angles, and orientation options (horizontal, vertical, diagonal, upside-down), perfect for document branding and professional presentation 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 Excel formatting services.

Get your API Key

Key Features

• Custom Text Content: Add any text as header or footer on Excel documents
• Font Customization: Control font family, size, color, and specific font names
• Transparency Control: Set semi-transparent (50% opacity) or fully opaque (100%) text
• Rotation & Orientation: Apply rotation angles or use preset orientations (horizontal, vertical, diagonal, upside-down)
• Culture Support: Specify culture codes for proper text rendering and formatting

Parameters

Complete list of parameters for the Add Text Header Footer to Excel action. Configure these parameters to control text formatting.

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

Parameter	Type	Description	Example
File Content***	Base64	Source Excel File Content • Map Excel file from previous action output • Supports Excel files from SharePoint, OneDrive, email attachments • Can be dynamically retrieved from flow variables • Must be valid Excel document (.xlsx, .xls formats)	[File Content from Get File]
File Name***	String	Excel Document Name • Specify Excel file name with extension (.xlsx, .xls) • Used for processing and output file naming • Must include proper file extension • Supports dynamic naming from flow variables	data.xlsx
Watermark Text***	String	Header/Footer Text Content • Text to be displayed as header or footer • Can include document title, dates, page numbers • Supports dynamic content from flow variables • Any alphanumeric characters and symbols	Confidential Report 2024
Font Family	String	Font Family Name • Font family to use for text • Common families: Arial, Times New Roman, Calibri • Default: Arial if not specified • Used unless FontName overrides it	Arial
Font Size	Number	Text Size in Points • Font size of header/footer text • Standard range 8-72 points • Default: 72 if not specified • Larger values for better visibility	12
Font Color	String	Text Color • Hex color code (e.g., "#FF0000") or color name • Supports standard HTML color names • Determines text appearance • Default: black if not specified	#0000FF
Semi Transparent	Boolean	Transparency Level • True - Apply 50% opacity (semi-transparent) • False - Apply 100% opacity (fully opaque) • Default: false (fully opaque) • Useful for watermark-style headers	false
Rotation	Number	Rotation Angle in Degrees • Rotation angle for text (0-360 degrees) • Default: 0 (no rotation) • Clockwise rotation • Note: Orientation parameter takes priority if provided	45
Font Name	String	Specific Font Name • Specific font name to use • Overrides FontFamily if provided • Use for precise font control • Example: "Arial Bold", "Calibri Light"	Arial Bold
Orientation	String	Text Orientation • Horizontal - Standard left-to-right text • Vertical - Top-to-bottom vertical text • Diagonal - Diagonal text across page • Upside-Down - 180-degree rotated text • Takes priority over Rotation parameter	Horizontal
Culture Name	String	Culture Code • Culture/locale code for text rendering • Examples: "en-US", "de-DE", "fr-FR" • Ensures proper character rendering • Affects date/number formatting if applicable	en-US

Note: The Orientation parameter takes priority over the Rotation parameter. If Orientation is specified, the Rotation value will be ignored.

Output

The PDF4me Add Text Header Footer to Excel action returns comprehensive output data for seamless Power Automate flow integration:

Table

Table View

Response data in a structured table format:

Parameter	Type	Description
document	Base64	Excel document with text header/footer applied
Success	Boolean	true if operation successful, false if failed
Error Message	String	Error description (null if successful)
Errors	Array	List of detailed error information (empty array if successful)

JSON

JSON Response Format

The raw JSON response from the action:

{
  "document": "[Base64 Excel Content with Header/Footer]",
  "Success": true,
  "ErrorMessage": null,
  "Errors": []
}

Error Response Example:

{
  "document": null,
  "Success": false,
  "ErrorMessage": "Invalid file format",
  "Errors": [
    {
      "Code": "FORMAT_ERROR",
      "Message": "The provided file is not a valid Excel document"
    }
  ]
}

Flow Integration

Power Automate Flow Usage

Use formatted Excel files in subsequent actions:

• Email Distribution: Attach branded Excel documents to Outlook emails
• SharePoint Publishing: Upload formatted Excel files to document libraries
• Report Generation: Create professional reports with headers and footers
• Archive Storage: Store branded Excel files in OneDrive or Azure Blob
• Further Processing: Convert to PDF or apply additional formatting
• Client Delivery: Send professionally formatted Excel documents externally

Common Error Messages

Understanding and troubleshooting errors helps ensure smooth Excel text header/footer insertion workflows:

Error Message	Cause	Solution
"Request is empty"	Request object is null	Provide valid request object
"Document is empty"	Document object is null	Provide valid Excel document
"Watermark text is empty"	WatermarkText is null or empty	Provide valid text content for header/footer
"Invalid font specification"	Font family or font name is invalid	Use valid font names available in Excel
"Invalid color format"	FontColor has invalid hex code or color name	Use valid hex format (e.g., "#FF0000") or standard color names

Workflow Examples

The PDF4me Add Text Header Footer to Excel action in Power Automate provides comprehensive workflow templates designed for real-world business scenarios:

Financial Reports

Automated Financial Report Header/Footer Workflow

Transform your financial reporting with automated header and footer formatting:

Complete Workflow Steps:

1. Trigger: Scheduled trigger - monthly financial close on 5th at 8 AM
2. Get Excel Report: Retrieve monthly financial report from SharePoint
3. Add Header: Insert "Financial Report - [Month/Year]" header text
4. Set Font: Apply Calibri 14pt font in corporate blue (#003366)
5. Add Footer: Insert "Confidential - Internal Use Only" footer
6. Set Transparency: Apply semi-transparent footer (50% opacity)
7. Email Distribution: Send formatted report to finance team
8. Archive: Store branded report in finance document library

Business Benefits:

• Formats 12 financial reports monthly automatically
• Ensures consistent branding on all financial documents
• Adds professional appearance to critical reports
• Saves 30 minutes per report in manual formatting time

Create Flow

Client Deliverables

Automated Client Excel Deliverable Branding Workflow

Streamline your client deliverable branding with automated header/footer insertion:

Complete Workflow Steps:

1. Trigger: Project deliverable marked as "Final" in project management system
2. Get Excel File: Retrieve final Excel deliverable from project folder
3. Add Company Header: Insert company name and logo text in header
4. Add Date Footer: Insert "Generated: [Current Date]" in footer
5. Set Branding: Apply corporate fonts (Arial Bold 12pt) and colors
6. Set Orientation: Apply horizontal orientation for standard appearance
7. Email Client: Send branded Excel file to client stakeholders
8. SharePoint Archive: Store formatted version in client folder

Business Benefits:

• Brands 50+ client Excel deliverables monthly automatically
• Maintains consistent corporate branding on all client documents
• Eliminates manual formatting saving 15 minutes per file
• Enhances professional image with branded documents

Create Flow

Confidential Marking

Automated Confidential Excel Document Marking Workflow

Optimize your document security with automated confidentiality marking:

Complete Workflow Steps:

1. Trigger: Sensitive Excel uploaded to confidential SharePoint folder
2. Get Document: Retrieve Excel file from secure library
3. Add Confidential Header: Insert "CONFIDENTIAL" text in header
4. Add Restriction Footer: Insert "Internal Use Only - Do Not Distribute" footer
5. Set Red Font: Apply red color (#FF0000) for high visibility
6. Set Bold Style: Use bold font for emphasis
7. Apply Diagonal: Use diagonal orientation for watermark effect
8. Email Team: Send marked document to authorized users only

Business Benefits:

• Marks 100+ confidential Excel files monthly automatically
• Prevents unauthorized distribution with visible security labels
• Ensures compliance with data protection policies
• Reduces security incidents by 80% with clear markings

Create Flow

Sales Reports

Automated Sales Report Header/Footer Workflow

Enhance your sales reporting with automated professional formatting:

Complete Workflow Steps:

1. Trigger: Scheduled weekly sales report generation on Monday 9 AM
2. Get Sales Data: Retrieve weekly sales report Excel from CRM export
3. Add Title Header: Insert "Weekly Sales Report - [Date Range]" header
4. Add Page Info Footer: Insert "Page [#] - Generated [DateTime]" footer
5. Set Branding: Apply Times New Roman 11pt font
6. Set Semi-Transparent: Apply 50% opacity for subtle appearance
7. Email Sales Team: Distribute formatted report to sales managers
8. Archive Reports: Store in sales reports document library

Business Benefits:

• Formats 52 weekly sales reports annually automatically
• Provides consistent professional appearance for leadership review
• Adds tracking information with date/time footer
• Improves report organization and archival

Create Flow

Industry Use Cases & Applications

Finance & Accounting

Finance & Accounting Use Cases

• Financial Statements: Add headers with company name and reporting period
• Budget Reports: Insert confidentiality footers on budget documents
• Audit Documents: Apply audit date and version information in headers
• Expense Reports: Add submission date and approval status in footers

Sales & Marketing

Sales & Marketing Use Cases

• Sales Reports: Add report title headers and generation date footers
• Pricing Sheets: Insert "Confidential Pricing" headers on rate cards
• Customer Data: Apply data protection notices in footers
• Marketing Analytics: Add branding headers to analytics reports

Human Resources

Human Resources Use Cases

• Payroll Reports: Insert confidentiality headers on salary documents
• Employee Records: Add date and version footers to personnel files
• Benefits Enrollment: Apply open enrollment period headers
• Performance Reviews: Insert review period and confidentiality notices

Operations & Manufacturing

Operations & Manufacturing Use Cases

• Inventory Reports: Add warehouse location and date headers
• Production Reports: Insert shift information and date footers
• Quality Reports: Apply quality standard references in headers
• Supply Chain Data: Add supplier confidentiality notices in footers

Get Help

PDF4me ConnectGet your API KeyPower Automate Documentation