cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
UK_Mike
Post Prodigy
Post Prodigy

Get First Free Row In a Table When The Table Has Empty Rows Above The Table

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.

1 ACCEPTED SOLUTION

Accepted Solutions
UK_Mike
Post Prodigy
Post Prodigy

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 😂

View solution in original post

4 REPLIES 4
UK_Mike
Post Prodigy
Post Prodigy

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. 

Helpful resources

Announcements
 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Top Solution Authors
Users online (1,586)