Power Platform Community Forum Thread Details

Hi,

What should I write to be able to select only one Column, but all its items, from the Table.
To be able to use it in 'For each'.
My data table comes from a CSV file and I use 'Read CSV File'

Categories:

Power Automate Desktop

Hi @fgonzalez515

To select the column from the row %CurrentItem%, use the expression %CurrentItem['ColumnName']%

for example: if you need to select the let's say first column - use %CurrentItem['Nro']% to select the Nro column

https://learn.microsoft.com/en-us/power-automate/desktop-flows/variable-data-types#datatable

, Also i could see that in your datatable - First row is not considered as headers, to consider it as header- use the follow option on in read csv action

Thanks & Regards,
Nived N

Stay connected:
LinkedIn | YouTube | Blogs

Was this answer helpful?
If yes, please mark it as the solution by selecting the checkbox in the discussion thread.
Your feedback motivates me to keep contributing. Thank you!