Announcements
Hi All,
More often than not data or a data table starts at A1.
There are occasions where this data has empty rows above for whatever reason.
So lets assume my data starts at A5, how do I get the first free row in this range ?
Thanks, Mike.
Hmmmmmmmmmmmmm,
I think I figured it out, read range which gets me all the data.
In the data table I have the last row which gives me what I wanted.
LOL 😂
Just for future reference, FirstFreeRow, in my experience, is the same as you pressing Control + End and then it just gives the next row from the active cell. So it should still work in this scenario.
Jaysus !!! I always thought that only worked when inside the range 🙄
I will stick with the read range so I can store the result for later use in the flow but good to know.
Cheers Mike.
Unfortunately Ive already marked myself as solution 😂
No worries. I found that out the hard way. Because clearing contents doesn’t change the End row, you have to physically delete the blank rows at the bottom, click in the normal range, and save to reset the End row.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 237 Super User 2026 Season 2
David_MA 227 Super User 2026 Season 2
Mohsin Ali 194
