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

Notifications

Announcements

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 2025 Season 2 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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 501 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 323 Moderator

#3
abm abm Profile Picture

abm abm 237 Most Valuable Professional

Last 30 days Overall leaderboard