Datatable Slicing

[lazy]

I have a datatable that has two columns.

How do I slice the second only to write to an Excel worksheet?

I tried

%DataTable[:][1]%

but this returned the second row!

I thought that the datatable was addressable like Python dataframes

[fraenK · Accepted solution]

PAD only knows data table and data row, not columns, so you can loop through the rows of a column by %DatatableVariableName[i]['ColumnName']% or just get a column as a list:

https://docs.microsoft.com/en-us/power-automate/desktop-flows/actions-reference/variables#retrieveda...

https://docs.microsoft.com/en-us/power-automate/desktop-flows/variable-data-types#advanced-data-type...

[lazy]

Awesome!

Set variable to %DataTable[1]% worked

Retrieve data table column into list action also works!

[lazy]

Good to know that slicing by rows works though, e.g., %DataTable[3:]% returns all rows from the fourth!💡