Unanswered

Add to last row in Excel table

(0) Share

Report

Posted on by johnnmagne

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

Categories:

Using flows

I have the same question (0)

All responses (2)

Answers (0)

Sort by

ScottShearer 25,290 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

@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?

Was this reply helpful? Yes No
divya-akula 47 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No