Update last line in Excel

[Haufe]

Hi,

Please, i need always update the last line in an Excel when i press the button of the flow.

Thanks!

Best regards. 

[v-yamao-msft · Accepted solution]

Hi @Haufe ,

Do you want to update the last row in an Excel table every time you press a button?

Please check the following flow for a reference.

Add the button trigger.

Add action List rows present in a table.

Add action Update a row, select the Key column from the dropdown, then in the Key value field, input the following code:

last(body('List_rows_present_in_a_table')?['value'])?['Subject']

Then update the Start date with function utcnow(‘yyyy-MM-dd’).

Best regards,

Mabel

[Haufe]

Hi v-yamao-msft,

Thank you so much for the asnwer, it worked.

Best regards,