cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
lazy
Frequent Visitor

Datatable Slicing

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

1 ACCEPTED SOLUTION

Accepted Solutions
fraenK
Memorable Member
Memorable Member

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...

 

View solution in original post

3 REPLIES 3
fraenK
Memorable Member
Memorable Member

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
Frequent Visitor

Awesome!

Set variable to %DataTable[1]% worked

Retrieve data table column into list action also works!

lazy
Frequent Visitor

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

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Top Kudoed Authors
Users online (3,276)