Unanswered

Getting Last cell value of a Particular coloumn in a datatable.

(0) Share

Report

Posted on by Raj14

I have a Datatable called as "OutputDt" and in it, it has a coloumn called "id". i want the last row value of that "id" coloumn in Datatable. **In Power Automate Desktop**

Categories:

Power Automate Desktop

I have the same question (0)

All responses (2)

Answers (0)

Sort by

pengwei 139 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Raj,

You can first retrieve the column id as a list. Reverse it and get the first entry.

Was this reply helpful? Yes No
Agnius Bartninkas Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

You can access every row with an index like this: %OutputDt[RowIndex]['Id']%.
The index for the last row will be equal to the count of total rows in the table minus 1 (as indexes are 0-based in PAD). A data table has a property called .RowsCount that contains the number of rows in the table. So, you can do %OutputDt[OutputDt.RowsCount-1]['Id']% to get the value from the last row in the column named 'Id'.
-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution.
If you like my response, please give it a Thumbs Up.
If you are interested in Power Automate, you might want to follow me on LinkedIn at https://www.linkedin.com/in/agnius-bartninkas/

Was this reply helpful? Yes No