CATEGORY
Microsoft 365 Excel
Microsoft has done a remarkable job bringing Excel to the cloud as part of Microsoft 365, and this area is about what that unlocks once your spreadsheets live online. A workbook in the cloud is not just a file you open in a browser, it becomes something the Power Platform can read from, write to, and act on automatically. Here I show you how to take your everyday Excel files and wire them into automated workflows. Think along the lines of pulling data out of a table so a flow can process it, adding new rows without opening the app, and using a spreadsheet as a lightweight data source that other systems can tap into. These are the tasks that quietly eat your time when you do them by hand, and they're exactly the ones worth automating.
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.
Power Automate: Office 365 Excel - Get a Row action
Returns a single Excel row by key column value.
Power Automate: What is a Key Column in Excel?
Power Automate: Office 365 Excel - Delete Row action
Removes a row from an Excel table by key column value.
Power Automate: Office 365 Excel - For a selected row Trigger
Fires when a user selects an Excel row via the Power Automate add-in.
Power Automate: Office 365 Excel - List rows present in a table Action
Returns all rows from an Excel table. Requires table-formatted data.