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 can i get datatabl...
Power Automate
Unanswered

How can i get datatable first row and specific column value without using loop

(0) ShareShare
ReportReport
Posted on by 162

My datable has 5 rows and 2 columns,

how can i get first row data of 2nd column?

I have the same question (0)
  • eetuRobo Profile Picture
    4,204 Super User 2025 Season 2 on at

    Like this:
    %datatable[0][1]%

    first square brackets which has 0 in it means row and the rows start from 0. Then the second square brackets is columns and 1 means second column since that too starts from 0.

    Example here:

    from this datatable we want to get value from first row second column which would be "Norris".

    eetuRobo_3-1713592666922.png

     

    eetuRobo_2-1713592541589.png

     

     

  • Deenuji_Loganathan_ Profile Picture
    6,250 Super User 2025 Season 2 on at

    Hi @MitheshRpa 

     

    Let's assume our datatable having the below values(Row Index starts always with 0):

    Deenuji_0-1713593956588.png

     

    Then our approach to access first row for second column would be like below:

     

    %DataTable[0]['Capital']%

     

    Deenuji_1-1713594050077.png

     

     


    Thanks,
    Deenuji Loganathan 👩‍💻
    Automation Evangelist 🤖
    Follow me on LinkedIn 👥

    -------------------------------------------------------------------------------------------------------------
    If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀

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