Insert blank row at the end

[MarkusEng1998]

I can insert a blank row using this code:

= Table.InsertRows(Source, 0,{Record.FromList(List.Repeat({""},Table.ColumnCount(Source)),Table.ColumnNames(Source))})

but the zero inserts at the beginnng of the table.

I would like to insert the blank row at the last row.

I tried using Table.PositionOf(Source, RowAsRecord) but do not know how to extract the RowAsRecord.   

 Table.LastN(Source, 1)    // locates the row, but is not a record type.

     Finally I tried converting it to a record, but is not in the format [name="", value=""]

Record.FromTable(Table.LastN(Source, 1))

Hence, this code does not work:

= Table.InsertRows(Source, 

  Table.PositionOf(Source, 
		Record.FromTable(Table.LastN(Source, 1))),
		
  {Record.FromList(List.Repeat({""},Table.ColumnCount(Source)),Table.ColumnNames(Source))})

Please advise. Thank you!

[MarkusEng1998]

Thank you @watkinnc that was easy!

[watkinnc · Accepted solution]

Replace the "0" with Table.RowCount(Source). This will give you the row count, which is one more than the zero based index of the last row.

--Nate