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
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (2,994)