web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Automate - Power Automate Desktop
Suggested answer

How to reference an item in a data table?

(0) ShareShare
ReportReport
Posted on by
Hello, I am working with a table variable in Power Automate, and I have a loop that iterates through each row of the table. Each row is stored in the variable currentItem. I need to reference a specific column within the current row (currentItem). However, when I select dynamic content, only currentItem appears as an option, and I cannot see the columns individually. I have tried expressions like currentItem()?['ColumnName'], but I keep encountering syntax errors, such as "unexpected characters." How can I reference a specific column in the current row within a loop? Thank you!
Categories:
I have the same question (1)
  • Suggested answer
    DP-03101916-0 Profile Picture
    2 on at
    How to reference an item in a data table?
    I had the same question and was able to solve it through the following syntax:
     
    CurrentItem.ColumnName
     
    For example:
     
    CurrentItem.HourlyRate
  • Suggested answer
    VishnuReddy1997 Profile Picture
    2,602 Super User 2025 Season 2 on at
    How to reference an item in a data table?
    Hey Hi,
     
    Please find the solution.
     
     
    Please try this syntax : %CurrentItem['HeaderNameinExcel']%
     
     
    (Note:- if you got your solution you can mark as solution and gives kudos)
     
    Thanks & Regards
    Vishnu Reddy

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Tom Macfarlan – Community Spotlight

We are honored to recognize Tom Macfarlan as our Community Spotlight for October…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 533 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 368 Moderator

#3
Expiscornovus Profile Picture

Expiscornovus 290 Most Valuable Professional

Last 30 days Overall leaderboard