2
We have a Office 365 form which collects the data and then using Power Automate to add row in a Excel table. For some reason the data being inserted to row# 200 on wards instead of next available row which is row#28.
Any assistance would be much appreciated!
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.
Best of Luck!
Share
Report
All responses (
Answers (
