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 get the value o...
Power Automate
Answered

How to get the value of new row while in current row data table?

(0) ShareShare
ReportReport
Posted on by 357

Hi, Team, 

I am new to power automate desktop

 

I want to check the value of next row while I was in current row is it possible? 

Yes then provide the solution to me.

 

Thank you so much in advance!!

Cheers.

I have the same question (0)
  • Verified answer
    UshaJyothiKasibhotla Profile Picture
    225 Moderator on at

    Hi @Sanket1 

    You can use find and replace datatable activity and there you can give input as current item or curren row....as follows 

    Loop through the data table and current row will be the each row 

    Use find and replace datatable activity and select find 

    Give value to find is %currentrow+1%

    Then you will get the index of the next row

    Use that index in the display message or wherever you need to use.....

     

    Hope this helps

    Usha 

  • Sanket1 Profile Picture
    357 on at

    Not working current item +1 

    It's adding 1 value every where

     

    Like column 1 data 

     

    Ord138595 1

    Ord82838 1

  • Sanket1 Profile Picture
    357 on at

    Such Bad response rate in power automate, 

  • UshaJyothiKasibhotla Profile Picture
    225 Moderator on at

    Currentitem.index+1

    Take set variable activity 

    Counter =0

    above for each and 

    Set the variable to

    counter= counter+1

    At the above of end (for each)

    Now counter gives the current row index 

    So you can give that counter+1 in find and replace activity....

    Hope this helps 

    Usha

  • Sanket1 Profile Picture
    357 on at

    Thank you so much...Usha

  • Verified answer
    Sanket1 Profile Picture
    357 on at

    1000086306.jpg

    I did as you said but did not getting the next row while while I was in current row

     

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 284 Super User 2026 Season 2

#2
trice602 Profile Picture

trice602 188 Super User 2026 Season 2

#3
11manish Profile Picture

11manish 144 Super User 2026 Season 2

Last 30 days Overall leaderboard