Same as https://powerusers.microsoft.com/t5/Power-Automate-Desktop/Add-Row-to-Excel-from-a-Form-on-random-row-instead-of-next/m-p/1270735#M6866
The solution is below:
Get Last Row only works if all data/formatting is cleared from all blank cells extended below the bottom of your data.
For instance, if you manually were to open this workbook, and press Ctrl + End, which cell gets selected? My guess is the last column on row 199, which is why it is putting the next available row as 200.
To clear all blanks, do this with your bot:
Send Keys {Control}(a) #Select All
On the Home Ribbon, click Find & Select, Go To Special #use the recorder if you need to walk the bot through this
Blanks -> OK #If you can't find the window selector for "Blanks", use Send Keys {Alt}(k) instead
Again on the Home Ribbon #with all the blank cells highlighted
Click Clear -> Clear All
Then "Select cell A1"
Then "Save Excel".
This will reset the last row, so when you use "Get Last Row" command in PAD, it will actually get the last row of data and not some ghost row down below.
