Delete Watermark from Excel in Power Automate

PDF4me Remove Watermark from Excel action enables removal of watermarks and shapes from Excel documents in Power Automate with precise control and flexible targeting. This powerful cleanup feature supports deletion of specific watermarks by shape ID/name or removal of all shapes from worksheets, with flexible worksheet selection by name or index (1-based), and culture-specific localization support, perfect for document finalization, rebranding preparation, and automated watermark cleanup 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 watermark deletion services.

Get your API Key

Delete Watermark from Excel Power Automate

Key Features

Selective Deletion: Delete specific watermarks by ID or remove all shapes
Worksheet Targeting: Apply to specific worksheets by name or index, or all worksheets
Shape Name Matching: Find and remove shapes by exact name match
Batch Processing: Remove watermarks from multiple worksheets in single operation
Culture Support: Specify culture codes for localization during processing

⚠️ Critical Warning: When WatermarkId is empty, ALL shapes are removed from selected worksheets, including watermarks, charts, images, drawings, and text boxes. Use with extreme caution!

Parameters

Complete list of parameters for the Delete Watermark from Excel action. Configure these parameters to control watermark deletion.

Important: Parameters marked with an asterisk (***) are required. Worksheet indexes use 1-based numbering (1 = first worksheet).

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 ID	String	Specific Watermark Shape Name • Name/ID of specific watermark to delete - searches for shapes with matching Name • ✅ Safe (Specified): Removes ONLY matching shapes, preserves all other shapes (charts, images, etc.) • ⚠️ Dangerous (Empty): Executes worksheet.Shapes.Clear() - removes ALL shapes (watermarks, charts, images, drawings, text boxes) - cannot be undone • Case-sensitive exact match: "Confidential" ≠ "confidential" ≠ "CONFIDENTIAL" • ⚠️ Use empty value ONLY if you want to remove everything	`Confidential_Watermark`
Worksheet Names	Array	Target Worksheet Names • List of worksheet names to process • Selection Logic: If has values → Process those named worksheets. If both parameters have values → Process worksheets matching EITHER (union). If BOTH empty → Process ALL worksheets • Case-sensitive worksheet names	`["Sheet1", "Summary"]`
Worksheet Indexes	Array	Target Worksheet Indexes (1-based) • List of worksheet indexes to process • 1-based indexing: Index 1 = first worksheet, Index 2 = second worksheet, etc. (Valid range: 1 to total worksheet count) • Selection Logic: If has values → Process those indexed worksheets. Union with WorksheetNames • Empty = apply to all worksheets (if names also empty)	`[1, 3]`
Culture Name	String	Culture Code for Localization • Culture/locale code for processing • Examples: "en-US", "de-DE", "fr-FR" • Empty string uses default culture • Default: "" (empty)	`en-US`

Output

The PDF4me Delete Watermark from Excel action returns comprehensive output data for seamless Power Automate flow integration:

Table
JSON
Flow Integration

Table View

Response data in a structured table format:

Parameter	Type	Description
document	Base64	Excel document with watermark(s) removed
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 Response Format

The raw JSON response from the action:

{
  "document": "[Base64 Excel Content with Watermarks Removed]",
  "Success": true,
  "ErrorMessage": null,
  "Errors": []
}

Error Response Example:

{
  "document": null,
  "Success": false,
  "ErrorMessage": "Invalid worksheet selection",
  "Errors": [
    {
      "Code": "WORKSHEET_ERROR",
      "Message": "Worksheet 'NonExistent' not found. Available worksheets in workbook (5 total)"
    }
  ]
}

Common Error Messages

Understanding and troubleshooting errors helps ensure smooth Excel watermark deletion 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
"Invalid worksheet selection"	Worksheet name doesn't exist or index out of range	Use valid worksheet names or indexes (1-based)
"Available worksheets in workbook (X total)"	Informational message when worksheet validation fails	Review worksheet names/indexes and use valid values from 1 to X

Note: No error is thrown if WatermarkId doesn't exist - operation completes silently.

Workflow Examples

The PDF4me Delete Watermark from Excel action in Power Automate provides comprehensive workflow templates designed for real-world business scenarios:

Approval Cleanup
Rebranding Preparation
Client Sanitization
Template Reset

Automated Draft Watermark Removal on Approval Workflow

Transform your document approval process with automated watermark removal:

Complete Workflow Steps:

Trigger: Document approved in approval workflow system
Get Draft Document: Retrieve Excel file with "DRAFT" watermark
Delete Draft Watermark: Set WatermarkId = "DRAFT_Watermark"
Apply to All Sheets: Leave WorksheetNames and WorksheetIndexes empty
Verify Removal: Confirm watermark no longer present
Add Approved Stamp: Optional - add "APPROVED" watermark (separate action)
Email Distribution: Send final document to distribution list
Archive Final: Store approved version in final documents library

Business Benefits:

Removes draft watermarks from 100+ approved documents monthly
Ensures clean final appearance without draft markings
Automates document finalization saving 30 minutes per document
Prevents distribution of draft-marked final documents

Create Flow

Industry Use Cases & Applications

Legal & Professional Services Use Cases

Document Finalization: Remove "DRAFT" watermarks from approved legal documents
Client Delivery: Clean internal watermarks from client-facing deliverables
Privilege Cleanup: Remove privilege watermarks from public filings
Rebranding: Update law firm watermarks during merger/rebrand

Get Help

PDF4me Connect Get your API Key Power Automate Documentation

Authenticating Your API Request​

Key Features​

Parameters​

Output​

Common Error Messages​

Workflow Examples​

Industry Use Cases & Applications​

Get Help​