Answered

loop table and extract value

(1) Share

Report

Posted on by nick9one1

321

I have a table I'm looping through and want to extract values in specific columns, then write them to an excel worksheet.

the table I'm looping looks like this;

currentitem2 looks like this

I have tried using the code

%CurrentItem2[3]%

to reference the 3rd column in current item which should be 'OPENING BALANCE'.
but it just writes '%CurrentItem2[3]%' in my excel sheet.

what am I doing wrong?

thank you

Categories:

Power Automate Desktop

I have the same question (0)

All responses (3)

Answers (1)

Suggested answer

trice602 16,048 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi there!

Try %CurrentItem2[2]% because if I remember correctly, this is 0 based and should be [2].

------------------------------------------------

⭐ If this was helpful, please like and check the box below "Does this answer your question" to help others find this too!

Always glad to help! 💯💯💯💯💯

Tom

Follow me on LinkedIn - Thomas Rice, PMP | LinkedIn

Was this reply helpful? Yes No
Verified answer

eetuRobo 4,484 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

You are mixing up Power Fx and regular flow syntax. Since it seems like you created a flow with Power Fx turned on then you can't use %CurrentItem2[3]% -syntax but the syntax is =CurrentItem2.Narrative

If you decide to recreate the flow without Power Fx enabled then @trice602's solution would be correct. In the regular PAD flow the index starts from 0 so the third index is 2. But in Power Fx the indexing starts from 1 so the third index is 3. But in Power Fx you can use the dot column name. Or if you don't know the column name you can use ReadCell() -function like this:
=ReadCell(CurrentItem2,3)

Was this reply helpful? Yes No
Suggested answer

Riyaz_riz11 4,048 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi,

Solution: Use Datarow Column Access Syntax

Instead of %CurrentItem2[3]%, you need to use one of these methods:

Method 1: Access by Column Index (Recommended)

%CurrentItem2[3]%

Wait, if that's not working, try:

Method 2: Access by Column Name

%CurrentItem2['Narrative']%

Method 3: Use Column Reference

%CurrentItem2.Narrative%

Step-by-Step Fix:

Check your variable syntax - Make sure you're using the correct variable reference format in the "Value to write" field.

Try this specific syntax for the 3rd column (Narrative):

%CurrentItem2.Narrative%

Or try accessing by column name:

%CurrentItem2['Narrative']%

If you want to access by index, the correct syntax should be:

%CurrentItem2(2)%

(Note: Using parentheses instead of brackets, and remember indexing starts from 0)

or your specific case where you want the "Narrative" column:

In the "Value to write" field, enter:

%CurrentItem2.Narrative%

For other columns, you would use:

Posting Date: %CurrentItem2['Posting Date']%

Value Date: %CurrentItem2['Value Date']%

Debit Amount: %CurrentItem2['Debit Amount']%

If I have answered your question, please mark it as the preferred solution ✅ . If you like my response, please give it a Thumbs Up 👍.
Regards,
Riyaz

Was this reply helpful? Yes No