In Power Automate, use the Excel Online (Business) action "Add a row into a table" — the workbook must be stored in OneDrive for Business or SharePoint and the target range must be formatted as an Excel table; choose Location, Document Library, File and Table, then map a value to each column.
On this page7
In the workbook, select the data range and use Insert ▸ Table, then give the table a name on the Table Design tab.
Save the workbook to OneDrive for Business or a SharePoint document library.
In the flow, add the Excel Online (Business) action Add a row into a table.
Choose Location, Document Library, File and Table.
Map a value to each column; for a dynamically selected file or table, provide the Row as JSON with the column headers as keys.
What this does
Power Automate does not insert worksheet rows the way the Insert command does; it appends a record to an Excel table through the Excel Online (Business) connector. The action needs to find a named table in a file on OneDrive for Business or SharePoint, and it writes one value per table column. When the file or table is chosen dynamically (from an earlier step), the column fields cannot be shown at design time, so the row is supplied as a JSON object whose keys match the column headers. Before you run it on a workbook other people depend on, try it on a copy or a few rows first. Undo only reaches back through the current session, so a quick trial run is the cheapest way to see exactly what will change before the file is saved and shared. For “add a row to excel table dynamic power automate”, the reliable version is a short checking loop, not just the first command that appears to work. Run it on a deliberately small range first, watch how the affected rows change, and only then apply the same setup to the full sheet. When this is a ribbon command, the selection matters more than the button: confirm the range, apply the command, then spot-check the output before saving. That is what makes a workflow that saves repeating the same clicks every week useful in real work: repeatable, auditable, and not dependent on memory or luck.
A worked example
A form response should land in Orders.xlsx, table tblOrders with columns Date, Customer and Amount. Add "Add a row into a table", pick the SharePoint site, library and file, choose tblOrders, and map Date, Customer and Amount to the trigger's outputs. For a dynamic file path, set Table from a variable and put {"Date": "2026-09-16", "Customer": "Contoso", "Amount": 120} in the Row field — the keys must match the headers exactly. Automating record capture — form responses, approvals, emails — into a shared workbook removes manual copy-paste, but only if the flow writes to a table it can reliably find. A practical tip: try it on a copy of the sheet or a handful of sample rows first and check the result before you apply it to the real data. That one habit catches almost every surprise while it is still cheap to reverse.
In Google Sheets
Power Automate's Excel Online (Business) actions work on Excel workbooks in OneDrive for Business or SharePoint; a Google Sheets file needs the separate Google Sheets connector, whose actions and requirements differ. The aim was to get you unstuck fast and leave you a little more capable than a copy-paste would. The answer is at the top and the detail above shows why it holds — so the next time a colleague asks, you can answer without reaching for search. If you take one thing from this page on “add a row to excel table dynamic power automate”, make it the order of checks rather than the individual clicks: confirm what is selected, apply the step, and look at the result before moving on. That small routine is what keeps Excel work predictable when the same task comes back in a slightly different workbook.
Common mistakes
- Pointing the action at a plain range — only Excel tables are listed.
- Using a file stored locally or in personal OneDrive when the connection is for OneDrive for Business or SharePoint.
- JSON keys that differ from the column headers in spelling or case, which leaves those columns empty.
- Renaming or deleting the table after building the flow, which breaks the action.
Frequently asked questions
Why does my table not appear in the action?
The range is not formatted as an Excel table, or the file is not in the OneDrive for Business or SharePoint location the connection can see.
How do I add a row when the file name changes?
Pass the file and table dynamically and supply the Row as a JSON object whose keys are the column headers.
Can I insert a blank worksheet row in the middle of the data?
Not with this action — it appends a record to the table. Sorting the table afterwards, or an Office Script, handles position.