The action is to get +1 of the last number of rows and columns where data exists on the active sheet.
Since the target to retrieve is the active sheet, if there are multiple sheets, you should also specify the sheets in the Set active Excel worksheet Action.
- 1. How to use.
- 2. For those who want to learn Power Automate Desktop effectively
- 3. Links
- 3.1. Excel Actions.
How to use.
Specify the target Excel file.
FirstFreeColumn & FirstFreeRow
FirstFreeColumn is set to the number of columns and FirstFreeRow to the number of rows.
If used for a worksheet like the one below, FirstFreeColumn=6 and FirstFreeRow=7.
When used on a worksheet like the one below, FirstFreeColumn=8 and FirstFreeRow=9
As you can see, even if there are blank rows/columns or rows/columns with half-data, they will still be counted.
Error handling is performed as needed.
Failed to retrieve first free column/row
This is an error when processing fails, such as when data exists up to the last row or column in Excel.
For those who want to learn Power Automate Desktop 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 Power Automate Desktop to streamline your workflow.