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
Unanswered

Get Excel Row Number

(0) ShareShare
ReportReport
Posted on by 50

It seems that I have the same problem, but I don't understand the solution. Can you please help?

 

How do I get Excel Row Number as a reference that I can use in the email?

 

Excel_row_id.png

Categories:
I have the same question (0)
  • David_MA Profile Picture
    12,908 Super User 2025 Season 2 on at
    Re: Get Excel Row Number

    There may be other ways to do this, but the simplest method I use is to add a column to the table named row with the following formula:

    =ROW()

    This gives you the row number directly within the table in the spreadsheet.

  • EugeneKreger Profile Picture
    50 on at
    Re: Get Excel Row Number

    I totally get it, but I need to understand those 'other' methods, adding another column to the table is what I'd like to avoid.

  • Verified answer
    v-liwei-msft Profile Picture
    on at
    Re: Get Excel Row Number

    Hi @EugeneKreger 

     

    You can get the Row number by creating a variable.
    Apply to each increments the variable by 1 each time it traverses a row.

    vliweimsft_0-1668060426097.png

    vliweimsft_1-1668060446197.png

     

    Best Regards,

    Levi

     

  • EugeneKreger Profile Picture
    50 on at
    Re: Get Excel Row Number

    That sounds like a good solution, should work for me well, thank you.

  • EugeneKreger Profile Picture
    50 on at
    Re: Get Excel Row Number

    Here is my full flow, sorry for messy snapshots. Can someone help me to implement above incremental variable. Trouble I have so far is that every 5000 row it will reset and start over again, and I don't know how work around this. 

     

    1.PNG

    2.PNG

    3.PNG

    4.PNG

    5.PNG

    6.PNG

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
Tomac Profile Picture

Tomac 497 Moderator

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 477 Super User 2025 Season 2

#3
chiaraalina Profile Picture

chiaraalina 242

Last 30 days Overall leaderboard