Power Automate: Office 365 Excel - Update a Row action
Updates an Excel row matched by a key column. Works on SharePoint, Teams, and OneDrive files.
This is my growing reference for Power Automate actions, the building blocks you drop into a flow to get work done. Every week I take one action, put it through its paces, and write up exactly how it behaves. You'll find detailed pages on the actions you reach for constantly, like the "Filter Array" action for trimming a dataset down to the rows you want, and the "Parse JSON" action for turning an API response into usable dynamic content. I cover loops and collections with the "Apply to each" action and the "Append to array variable" action, files with the "Office 365 Outlook Get Attachment" action and the "Excel Run script" action, and dates with the "Add to Time" action. Approvals get their own deep dives across the "Create an approval" action and the "Start and wait for an approval" action. Each entry covers inputs, outputs, configuration, and limitations.
Updates an Excel row matched by a key column. Works on SharePoint, Teams, and OneDrive files.
Returns a single Excel row by key column value.
Adds a key column to an Excel table so other Excel actions can reference rows.
Removes a row from an Excel table by key column value.
Returns an Outlook email by Message ID.
Creates a file in OneDrive for Business.
Deletes a OneDrive for Business file by file ID.
Forwards an Outlook email with optional comments.
Flags an Outlook email by Message ID.
Deletes an Outlook email by Message ID.
Subtracts a value from an Integer or Float variable.
Adds a value to an Integer or Float variable.