cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
johnnmagne
New Member

Add to last row in Excel table

Hi!

I have built a form that when filed by teh user, Power Automate sends the data to a email recipient based on answers in the form, and then I add that data into an existing Excel sheet on Sharepoint. The data is added to the first row, but 

I want the data to be added to the last empty row, as I do edit the Excel sheet, addeing and deleting data 

manually also.

 

Any suggestions?

 

Best
Johnny

2 REPLIES 2
ScottShearer
Super User
Super User

@johnnmagne 

I just ran a quick test and confirmed that the Excel Online Add a Row to a Table does add a row to the bottom of a table and not the top.  Note that a new row is added at the bottom - data is not entered in an "empty" row.  Are you using the Excel Online Add a Row to a Table action?  If so, is it possible that you have a sort option in the Excel table that shows the last row first?

 

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott
divya-akula
Helper I
Helper I

@johnmagne

I tried it using the below flow and it worked fine for me as well

divyaakula_0-1636093507866.png

 

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!

Users online (3,498)