Answered

looping data table using for each

(1) Share

Report

Posted on by mitsurya

I am looping through the data table and writing the current item to text file. but it is not writing actual text, instead "System.Data.DataRow" as shown in the screenshot below. How can i convert for loop "currentitem" to the actual value?

When I use display message it is showing actual value.

Please advise.

Thanks,

Surya.

Categories:

Power Automate Desktop

All responses (5)

Answers (1)

Sort by

Verified answer

MichaelAnnis 5,727 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

So, a CurrentItem for a Datatable is an entire data row. I assume you want a single text value from that datarow.

The format for a single text of a column from the CurrentItem datarow would be %CurrentItem[ColumnName]%.

More information on this formatting can be found here:

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

Best of luck!
MaiPhuocHoang on at

Like
a
(0)

Report
Copy link

Link copied!

Hi sir,
So the syntax to get a single text of a column is %CurrentItem[ColumnName]%.

I wachted many videos and all used that syntax. But I don't now why I can not use it on my power automate. When I try the flow, it put the value "%CurrentItem[ColumnName]%" on the place.

When I place variant %CurrentItem['Ngay in HD']% for exp on the flow, It will show that the value is '="%CurrentItem['Ngay in HD']%"'.

Can you help me with this?
MarcDussault 12 on at

Like
a
(0)

Report
Copy link

Link copied!

Have you resolved this issue? I am running into a similar problem.
Nazmashaik 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello,

In the latest version of Power Automate, Power Fx is enables. Hence %CurrentItem[ColumnName]% expression is not giving the expected output.
Instead, you can use functions to retrieve the value of a column. Here is the syntax "=ReadCell(CurrentItem, ColumnIndex)". The column indexes start from 1, 2, 3, 4 etc.

For example, to get the value of first column in the currentItem inside a for each loop : =ReadCell(CurrentItem, 1)

Hope this resolve your issue!
Nazmashaik 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Marc,

Please checkout below solution.
Solved: Re: looping data table using for each - Power Platform Community (microsoft.com)