cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper V
Helper V

Proper use of the expression last() with "List rows present in a table"

 After using a "List rows present in a table" blockI want to access the last row. How is that accomplished? the block will return an object and not an array, but the object contains an array, so I need to drill one level. What is that syntax?
1 ACCEPTED SOLUTION

Accepted Solutions
Dual Super User III
Dual Super User III

Hi!

Assuming you did not renamed your action block, I would try with

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

 

Great stuff here

https://powerusers.microsoft.com/t5/General-Power-Automate/How-to-get-last-row-values-in-an-excel-us...

 

Hooe this helps



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



View solution in original post

1 REPLY 1
Dual Super User III
Dual Super User III

Hi!

Assuming you did not renamed your action block, I would try with

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

 

Great stuff here

https://powerusers.microsoft.com/t5/General-Power-Automate/How-to-get-last-row-values-in-an-excel-us...

 

Hooe this helps



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Top Solution Authors
Top Kudoed Authors
Users online (11,871)