Delete Rows from Excel in Power Automate

PDF4me Delete Rows from Excel action enables removal of specified row ranges from Excel documents in Power Automate with flexible range syntax and intelligent deletion ordering. This powerful cleanup feature supports deletion of single rows, multiple individual rows, or continuous row ranges using comma-separated range syntax, with automatic bottom-to-top deletion to prevent index shifting issues and maintain worksheet structure integrity, perfect for data cleanup, report trimming, and automated Excel file maintenance 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 row deletion services.

Get your API Key

Key Features

• Flexible Range Syntax: Delete single rows, ranges, or mixed combinations using simple comma-separated format
• Multiple Range Support: Process multiple row ranges in a single operation
• Smart Deletion Order: Automatic bottom-to-top deletion prevents index shifting issues
• Worksheet Targeting: Specify worksheet by name or use first worksheet by default
• Structure Preservation: Maintains worksheet integrity with automatic row shifting

Parameters

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

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
Row Ranges***	String	Row Ranges to Delete • Comma-separated row ranges in 1-based format (row 1 = first row) • Single row: "5" - Delete row 5 only • Range: "1-10" - Delete rows 1 through 10 • Multiple rows: "5,10,15" - Delete rows 5, 10, and 15 • Mixed format: "1-5,10-15,20" - Delete rows 1-5, 10-15, and row 20 • Brackets optional: "[1-5]" same as "1-5" • Deletion Order: Rows deleted bottom-to-top (highest row first) to prevent index shifting	1-5,10,15-20
Worksheet Name	String	Target Worksheet Name • Name of worksheet to delete rows from • Null or empty defaults to first worksheet (index 0) • Must match worksheet name exactly • Case-sensitive worksheet name	Sheet1

Output

The PDF4me Delete Rows from 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 specified rows deleted
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 Rows Deleted]",
  "Success": true,
  "ErrorMessage": null,
  "Errors": []
}

Error Response Example:

{
  "document": null,
  "Success": false,
  "ErrorMessage": "Invalid row ranges: Row 1000 exceeds maximum data row (50)",
  "Errors": [
    {
      "Code": "ROW_RANGE_ERROR",
      "Message": "Row 1000 exceeds maximum data row (50). Valid row range for worksheet 'Sheet1': 1 to 50"
    }
  ]
}

Flow Integration

Power Automate Flow Usage

Use Excel files with deleted rows in subsequent actions:

• Report Cleanup: Remove header rows, blank rows, or summary sections
• Data Trimming: Delete old records or expired entries from logs
• Template Preparation: Remove example/sample rows from Excel templates
• Quality Control: Remove invalid or flagged data rows
• Email Distribution: Send cleaned Excel files without unnecessary rows
• SharePoint Publishing: Upload trimmed Excel files to document libraries

Common Error Messages

Understanding and troubleshooting errors helps ensure smooth Excel row 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
"Row ranges are required"	RowRanges is null or empty string	Provide valid row range specification
"Invalid worksheet selection"	WorksheetName doesn't exist in workbook	Use existing worksheet name
"Available worksheets in workbook (X total)"	Informational message when worksheet validation fails	Review worksheet name and use valid value from X available worksheets
"Invalid start row {row}. Row numbers must be positive."	Row number < 1 (e.g., "0-5", "-1")	Use row numbers ≥ 1 (1-based indexing)
"Row {row} exceeds maximum data row ({maxRow})"	Row number > worksheet's data row count	Use row numbers within valid range (1 to maxRow)
"Invalid range {start}-{end}: End row cannot be less than start row"	End row < start row (e.g., "10-5")	Ensure end row ≥ start row in ranges
"Invalid row range format"	Malformed range string that couldn't be parsed	Check syntax: use commas and hyphens correctly

Workflow Examples

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

Report Cleanup

Automated Report Header/Footer Cleanup Workflow

Transform your report distribution with automated removal of internal headers and footers:

Complete Workflow Steps:

1. Trigger: Internal report marked as "Ready for Client"
2. Get Excel Report: Retrieve internal report from SharePoint
3. Delete Header Rows: Remove rows 1-3 (internal headers and instructions)
4. Delete Footer Rows: Remove last 5 rows (internal notes and formulas)
5. Set Parameters: RowRanges = "1-3,96-100" (assuming 100 total rows)
6. Add Client Headers: Insert client-appropriate headers (separate action)
7. Email Client: Send cleaned report to client stakeholders
8. Archive Original: Keep internal version in separate folder

Business Benefits:

• Cleans 50+ client reports monthly automatically
• Removes confidential internal notes and instructions
• Ensures professional client-ready appearance
• Saves 20 minutes per report in manual cleanup

Create Flow

Data Archival

Automated Old Data Removal Workflow

Streamline your data management with automated deletion of expired records:

Complete Workflow Steps:

1. Trigger: Scheduled monthly archival process on 1st at midnight
2. Get Transaction Log: Retrieve Excel transaction log from SharePoint
3. Identify Old Rows: Use formula or script to identify rows older than 12 months
4. Build Range String: Create RowRanges dynamically (e.g., "5-150,200,250-300")
5. Delete Old Data: Remove expired transaction rows
6. Verify Row Count: Confirm expected row count after deletion
7. Update Archive: Save cleaned log back to SharePoint
8. Send Summary: Email admin with deletion summary report

Business Benefits:

• Archives 200+ old transaction records monthly automatically
• Maintains Excel file performance with trimmed data
• Complies with data retention policies automatically
• Reduces file size by 40% average

Create Flow

Template Cleanup

Automated Template Sample Data Removal Workflow

Optimize your template distribution with automated removal of sample data:

Complete Workflow Steps:

1. Trigger: New employee onboarding initiated in HR system
2. Get Excel Template: Retrieve expense report template from templates library
3. Delete Sample Rows: Remove rows 2-10 (sample expense entries)
4. Set Parameters: RowRanges = "2-10", WorksheetName = "Expenses"
5. Preserve Headers: Row 1 (headers) remains intact
6. Personalize: Add employee name and ID to template metadata
7. Email Employee: Send clean template to new hire
8. Log Distribution: Record template distribution in HR system

Business Benefits:

• Prepares 30+ employee templates monthly automatically
• Removes sample data that causes confusion
• Ensures employees start with clean templates
• Reduces onboarding time by providing ready-to-use templates

Create Flow

Quality Control

Automated Invalid Data Row Removal Workflow

Enhance your data quality with automated deletion of flagged rows:

Complete Workflow Steps:

1. Trigger: Data validation report completed by quality control system
2. Get Data File: Retrieve Excel file with validation results
3. Parse QC Results: Extract row numbers of rows marked as "Invalid"
4. Build Delete Range: Create RowRanges from invalid row numbers (e.g., "15,23,47-52,88")
5. Delete Invalid Rows: Remove all flagged data rows
6. Recalculate Stats: Update summary statistics after deletion
7. Email Data Owner: Send cleaned file to data owner for review
8. Archive QC Report: Store validation report in quality folder

Business Benefits:

• Removes 50+ invalid data rows weekly automatically
• Improves data quality by eliminating bad records
• Provides clean datasets for analysis and reporting
• Reduces manual data cleanup time by 90%

Create Flow

Industry Use Cases & Applications

Finance & Accounting

Finance & Accounting Use Cases

• Transaction Cleanup: Delete old or void transaction rows from accounting logs
• Period Close: Remove temporary calculation rows after month-end close
• Report Distribution: Delete internal notes and review comments from client reports
• Budget Templates: Remove previous year sample data from new budget templates

Sales & Marketing

Sales & Marketing Use Cases

• Lead List Cleanup: Delete unqualified or duplicate lead rows from lists
• Campaign Data: Remove test rows and invalid entries from campaign results
• Pricing Updates: Delete obsolete pricing rows from rate sheets
• Territory Management: Remove inactive territory assignments from sales data

Human Resources

Human Resources Use Cases

• Employee Records: Delete terminated employee rows from active rosters
• Payroll Processing: Remove sample data from payroll templates for new hires
• Benefits Enrollment: Delete expired enrollment options from benefits sheets
• Performance Reviews: Remove old review cycle data from tracking sheets

Operations & Manufacturing

Operations & Manufacturing Use Cases

• Inventory Cleanup: Delete discontinued product rows from inventory lists
• Production Logs: Remove old production run data beyond retention period
• Quality Control: Delete invalid or rejected inspection result rows
• Maintenance Records: Remove completed maintenance task rows from active schedules

Education & Training

Education & Training Use Cases

• Student Rosters: Delete graduated student rows from class rosters
• Course Catalogs: Remove discontinued course rows from catalog sheets
• Grade Books: Delete sample grade entries from new semester templates
• Training Records: Remove expired certification rows from tracking sheets

Healthcare & Medical

Healthcare & Medical Use Cases

• Patient Lists: Delete discharged patient rows from active treatment lists
• Appointment Schedules: Remove past appointment rows from schedule templates
• Lab Results: Delete old test result rows beyond retention requirements
• Insurance Claims: Remove processed claim rows from active claims tracking

Get Help

PDF4me ConnectGet your API KeyPower Automate Documentation