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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / How to reference an it...
Power Automate
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!
I have the same question (1)
  • Suggested answer
    VishnuReddy1997 Profile Picture
    2,656 Super User 2026 Season 1 on at
    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
  • Suggested answer
    DP-03101916-0 Profile Picture
    2 on at
    I had the same question and was able to solve it through the following syntax:
     
    CurrentItem.ColumnName
     
    For example:
     
    CurrentItem.HourlyRate

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 589

#2
Valantis Profile Picture

Valantis 328

#3
David_MA Profile Picture

David_MA 284 Super User 2026 Season 1

Last 30 days Overall leaderboard