Answered

Why does my data goes to the end of an empty excel table?

(0) Share

Report

Posted on by SharlW

My set up is: MS form data goes into my Excel doc via Power Automate/Auto cloud flow, BUT the data goes to the end of the Excel table. This leaves the 500 rows above the data empty.

What am I missing so that the data starts at row 2 then a new row each time a form is complete?

Thanks in advance for your help!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

timl 37,199 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi @SharlW

This is probably because there is empty content between the first row of data and row 500.

What I'd suggest is that you open your spreadsheet, select all the rows between row 3 and beyond 500, and use the right-click Delete menu item. If you save the Excel file, the next row should hopefully insert at the top.

Was this reply helpful? Yes No
SharlW 5 on at

Like (0)

Report
Copy link

Link copied!

Worked like magic! Thank you @timl . Much appreciated.

Was this reply helpful? Yes No