Site icon Kaizen.Personal computer work.

Get first free row on column from worksheet Action(Power Automate Desktop)

Japanese version.

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.

BGM. Music by mubert.com

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)

ColumnResult
13
24
36
47
58
61

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.

Links

Excel Actions.

Exit mobile version