Unanswered

Second to last row in a table

(0) Share

Report

Posted on by Noah100

Hello Community!

I am needing a solution for getting the second to last row in a table using an expression. Filtering data in List rows present in a table does not work for my specific needs. I know that last(body('List_rows_present_in_a_table')?['value']) will get me the very last row in a table and it returns the data that I want. I need an expression that will get me the second to last row so that I can have all of the data from both rows in separate compose actions.

Thank you,
Noah

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

SanmeshG 1,947 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi @Noah100 ,

I am assuming that you want the second row from the bottom of the table. This we can get by calculating the length of the array and skipping the first few rows.

first(skip(outputs('List_rows_present_in_a_table')?['body/value'],sub(length(outputs('List_rows_present_in_a_table')?['body/value']),2)))

Also an additional point the above expression will return an object , if you want an array then you can use the array function along with the above expression. The expression if you want an array will be as below,
array(first(skip(outputs('List_rows_present_in_a_table')?['body/value'],sub(length(outputs('List_rows_present_in_a_table')?['body/value']),2))))
Hope this helps!

If this solves your problem , please give this answer a thumbs up and accept it as a solution.

Thanks,

Was this reply helpful? Yes No
Chriddle 8,513 Super User 2025 Season 2 on at

Like (1)

Report
Copy link

Link copied!
Reverse the array, skip one item and then take the first one:
first(skip(reverse(your_array), 1))

Was this reply helpful? Yes No