Get first free row on column from worksheet Action(Power Automate Desktop)
This action specifies a column in the active worksheet and retrieves the first empty row in that column.
This is a column-specified version of Get first free column/row from Excel worksheet Action.
This action is useful when there are multiple tables on the same sheet and you want to specify which empty row is which.
If there are multiple sheets, since the target to retrieve is the active sheet,
If you have multiple sheets, you should specify the sheet(s) in the Set active Excel worksheet Action.
How to use.
First, set up Launch Excel Action or Attach to running Excel Action and specify the target file.
Then, from Excel, Advanced, Drag Get first free row on column from worksheet Action.
Set parameters.
Parameters
Excel instance
Specify the target Excel file.
Specify the Variables produced for the Launch Excel Action or the Attach to running Excel Action.
Column
Retrieves from the specified column. 1 for column A, 3 for column C, and 4 for column D.
Specify 3 to target column C.
If you execute the action on the table below, the result will look like this (yellow is blank)
| Column | Result |
|---|---|
| 1 | 3 |
| 2 | 4 |
| 3 | 6 |
| 4 | 7 |
| 5 | 8 |
| 6 | 1 |
Variables produced
Sets the index of blank row.
On error
Error handling if necessary.
An error occurs if the retrieval fails for some reason, such as an invalid column specification.
For those who want to learn Office script effectively
The information on this site is now available in an easy-to-read e-book format.
Or Kindle Unlimited (unlimited reading).
You willl discover how to about basic operations.
By the end of this book, you will be equipped with the knowledge you need to use Excel Office Script to streamline your workflow.