Update last line in Excel

(0) Share

Report

Posted on by RayRay

Hi there,

How can I update the last row in an Excel table if several row are the same?

last(body('In_Tabelle_vorhandene_Zeilen_auflisten')?['value'])?['DATUM']

This will not be the last date on the last row but the first last date

It would be great if someone can help me with this.

Best regard

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

efialttes 14,756 on at

Like (1)

Report

@RayRay

So, you do not need the last row, but the last row with any value assigned to column "ENDE", right?

I also assume body('In_Tabelle_vorhandene_Zeilen_auflisten')?['value'] is the output of a 'List rows present in a table' action block, right?

If so, there is an excellent explanation on how to proceed in the following post

https://powerusers.microsoft.com/t5/Building-Flows/Flow-that-checks-for-empty-cells-within-an-excel-table/td-p/206116

Please note the scenario descirbe in the post :

-is more complex than yours, in you case I guess it is enough to add the "Filter array" action block just after "List rows present in a table"

-assumes the opposite, i.e. the expression on the Filter Array described in the post [ equals(empty(item()?['date']), bool('True')) ] gets all rows with column 'date' empty, but you want to get all rows with column 'ENDE' not empty, so you will need something like [ not(equals(empty(item()?['ENDE']), bool('True'))) ]

Once you have all rows with column 'ENDE' not empty, you can apply last() expression to the output of 'Filter array' action block

Hope this helps

Was this reply helpful? Yes No
v-zhos-msft on at

Like (1)

Report

I have made some tests on my side. It has the same issue as yours.

As the pic shown, the value of row 23, 24 25 are same.

So when you enter the last 'DATUM' value in the 'Key value' field to update the row 25, but actually, the flow is get the row 23 to update.

As you can see, you need use the 'Key column' and 'Key value' to get the specific row in the 'Update a row' action .

So if there are several same rows, it will update the top one.

So I am afraid you need create another column here to enter different value to distinguish each row.

Best Regards,

Community Support Team _ Zhongys

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @RayRay ,

Was this reply helpful? Yes No