Update Rows in Excel in Power Automate
PDF4me Excel - Update Rows is a Power Automate action that modifies existing cells in a workbook in place, matching JSON property names to column headers. Use it to sync database changes, refresh CRM records, or update status columns in an Excel report without inserting or deleting any rows.
What this action does
PDF4me Excel - Update Rows writes a JSON array of objects into existing rows starting at Start Row, matching each property name to a column header. Convert Numeric And Date, Date Format, Numeric Format, and Culture Name control how the values are typed and formatted. It never inserts or deletes rows, only the matched cells change.
How Do I Authenticate My Power Automate Flow?
Every PDF4me action in Power Automate requires a valid connection. Create or select one that holds your PDF4me API key so the flow can authenticate Excel row-update requests securely.
Important Facts You Should Not Miss

Map File Content and File Name, set JSON Update Data and Start Row, then expand Advanced parameters for type conversion and formatting.
Parameters
Required: File Content, File Name, and JSON Update Data must always be provided. JSON Update Data must be a JSON array, a bare object is rejected.
| Parameter | Required | What it does | Example |
|---|---|---|---|
| File Content | Optional | Content of the Excel file to process. Map it from the file content returned by a previous action, such as SharePoint or OneDrive Get file content. | @{body('Get_file_content')?['$content']} |
| File Name | Optional | Name of the Excel file, including its extension (for example `report.xlsx`). Map it from the file name returned by a previous action. Defaults to `UpdateRows.xlsx`. | report.xlsx |
| Worksheet Name | Optional | Name of the worksheet to update. | your value |
| JSON Update Data | Optional | New row values, as JSON text. Written to the worksheet starting at Start Row and Start Column. | your value |
| Start Row | Optional | Starting row number for updates (1-based). Defaults to `1`. | 1 |
| Start Column | Optional | Starting column number for updates (1-based). Defaults to `1`. | 1 |
| Convert Numeric And Date | Optional | Automatically convert numeric and date values. Defaults to `Yes`. | Yes |
| Date Format | Optional | Format pattern for date values. Defaults to `yyyy-MM-dd`. | yyyy-MM-dd |
| Numeric Format | Optional | Format pattern for numeric values. Defaults to `N2`. | N2 |
| Ignore Null Values | Optional | Skip null values when updating. Defaults to `No`. | No |
| Ignore Attribute Titles | Optional | If Yes, the JSON property names are not written; only the values are updated. Defaults to `No`. | No |
| Culture Name | Optional | Culture name for data formatting. | your value |
Output Fields
| Field | Type | What it contains |
|---|---|---|
Output File Content | File content | Content of the Excel file with the rows updated. Map it into the next action, for example the File Content field of SharePoint or OneDrive Create file. |
Success | Yes/No | Whether the operation completed successfully |
Error Message | Text | Error message if operation failed |
Error Details | Array | List of detailed error messages |
What Do the Common Error Messages Mean?
| Error Message | Cause | Solution |
|---|---|---|
| Request is empty | The request object is null. | Provide a valid request object. |
| Document is empty | File Content is null or empty. | Map a valid Excel document into File Content. |
| Invalid worksheet selection | The named worksheet does not exist. | Use an existing worksheet name or leave it blank for the first sheet. |
| No headers found in worksheet | The target row (or Start Row minus one) has no headers. | Ensure the header row exists directly above the rows you are updating. |
| JsonData must be an array | A bare single object was provided instead of an array. | Wrap the object in array brackets, for example [{"Name":"John"}]. |
How Do I Set Up Update Rows in Power Automate?
- Add PDF4me → Excel - Update Rows to your Power Automate flow.
- Map File Content and File Name from a previous action (SharePoint, OneDrive, or a database connector).
- Set JSON Update Data to a JSON array of objects, one per row to update.
- Set Start Row to the first row to update (skip header rows) and Start Column for the header offset.
- Expand Advanced parameters to enable Convert Numeric And Date and set formatting. Run the flow, the updated workbook returns as document.
Typical Setups
Workflow ExamplesCommon Power Automate flow patterns using Update Rows.
- A scheduled trigger queries the database for updated stock levels.
- The results are converted into a JSON array matching the inventory sheet's column headers.
- Get file content retrieves the master inventory workbook from SharePoint.
- Update Rows applies the array starting at Start Row 2, with Convert Numeric And Date enabled for whole-number stock counts.
- The updated inventory workbook is saved back to SharePoint.
- A flow triggers when an order status changes in the order management system.
- The scenario builds a JSON array with the updated status field for the affected rows.
- Get file content retrieves the order tracking log.
- Update Rows applies the change with Ignore Null Values enabled, so other order columns stay untouched.
- The updated log is saved back to SharePoint.
- A weekly trigger queries Dynamics 365 for contacts modified in the last 7 days.
- The records are converted into a JSON array with contact and last-modified fields.
- Update Rows applies the changes with Ignore Attribute Titles enabled for case-insensitive header matching.
- The refreshed contact list is archived with a timestamp.
Practical Tips
Cheat Sheet
| Field | Value |
|---|---|
| Action | Excel - Update Rows |
| Required fields | File Content, File Name, JSON Update Data (array) |
| Default start row | 1 (set to 2+ to skip headers) |
| Default start column | 1 (column A) |
| Type conversion toggle | Convert Numeric And Date = true (default) |
| Default date/numeric format | yyyy-MM-dd / N2 |
| Output | document (Base64 workbook) + Success + ErrorMessage + Errors |
Common Questions
Industry Use Cases & Applications
- Sales & Marketing
- Finance & Accounting
- Human Resources
- Operations & Manufacturing
- Retail & E-Commerce
- Project Management
- Lead Status Updates: Update lead qualification status in Excel tracking sheets
- Campaign Metrics: Refresh campaign performance metrics from analytics platforms
- Customer Records: Sync customer contact information from CRM to Excel
- Sales Quotas: Update monthly sales targets and actuals in Excel dashboards
- Account Balances: Update customer account balances from accounting system
- Budget vs Actual: Refresh actual spending data in budget tracking Excel
- Invoice Status: Update payment status for invoices in Excel logs
- Exchange Rates: Update currency conversion rates in financial templates
- Employee Status: Update employment status (active, on leave, terminated) in Excel
- Salary Updates: Refresh salary information after annual reviews
- Training Completion: Update training status and completion dates
- PTO Balances: Sync vacation and sick leave balances from HR system
- Production Status: Update work order status in Excel production schedules
- Equipment Status: Refresh equipment condition and maintenance dates
- Quality Metrics: Update defect rates and quality scores from QC system
- Supplier Status: Update vendor approval status and ratings
- Stock Levels: Update product availability in Excel inventory sheets
- Pricing Updates: Refresh product prices from pricing management system
- Order Fulfillment: Update order shipping status and tracking numbers
- Product Information: Sync product descriptions and specifications
- Task Status: Update task completion status and progress percentages
- Milestone Dates: Refresh project milestone dates from project system
- Resource Allocation: Update team member assignments and utilization
- Budget Tracking: Sync project spending and budget utilization