Complete Guide to Power Automate Excel Online (Business) Actions: How to Manipulate Excel Files in Flow
I needed to manipulate Excel files stored in SharePoint document libraries, so I researched the available Excel actions. Here’s a comprehensive summary of what I found.
This action retrieves worksheet information. When executed, it returns key properties of the worksheet including “ID,” “Name,” “Visibility,” and “Position” as shown in the images below.
This action creates a table within an Excel worksheet. When executed, a table is created in Excel as shown in the image below. Note: You can specify the worksheet by using “!” in the [Table Range] field.
This action retrieves a row from a table by specifying a key column and its value. For example, when retrieving a row where the “Title” column equals “B”, you’ll get the following result. Note: Similar to a LookUp function, if multiple rows match the condition, only the first matching row will be retrieved.
This action updates a row in the table. Similar to the Get Row action, you specify the target row using a key column. Also like the Get Row action, if multiple rows match the condition, only the first matching row will be updated.
This action deletes a row from the table. As with the previous actions, you specify the target row using a key column. If multiple rows match the condition, only the first matching row will be deleted.
This action retrieves all rows from a table. Since it returns a list of values, you’ll typically need to use an “Apply to each” loop when working with the results.
Here’s what the execution result looks like:
This action is commonly used when you need to delete all rows or perform a complete search through the table.
This action adds a key column to the table. Here’s what happens when executed: Note: Although it’s called a “key column,” it appears to simply add a regular column (as far as I understand).
コメント