Skip to main content

Notifications

Community site session details

Community site session details

Session Id : LDhWpwI6EnrHggVt3jS96Q
Power Automate - Power Automate Desktop
Unanswered

How can I get LAST ROW of Excel file in PowerAutomate?

Like (0) ShareShare
ReportReport
Posted on 13 Sep 2023 18:53:17 by 4

 

 

 

I am importing data from Power Vİrtual Agents to Excel via Power Automate. I need to keep the data last row in Excel the varriable. Excel is dynamically updated. I want to get last row in Excel. I have an Excel file. It has 3 column in a table. I want to get the last row of which is the column I want. But unfortunately I couldnt it. I need help about that.  I want to take columns in the last row and compare them.  These data are date and time. 

 

My second question is that there is date and time data in the cell i will import from excel. Can I compare  the sizes of this data? 

 

  • johnnyongesa Profile Picture
    8 on 05 Jun 2024 at 05:21:48
    Re: How can I get LAST ROW of Excel file in PowerAutomate?

    First free row does not work when you have an empty row in between populated rows

  • Agnius Bartninkas Profile Picture
    10,045 Most Valuable Professional on 14 Sep 2023 at 06:36:09
    Re: How can I get LAST ROW of Excel file in PowerAutomate?

    Do you mean a cloud flow in Power Automate? If that's the case, you're in the wrong forums, because this forum is intended for Desktop flows using Power Automate Desktop. That is why we recommended using actions that are specific to Power Automate Desktop.

     

    The correct forum to post cloud flow related questions is here: https://powerusers.microsoft.com/t5/Building-Flows/bd-p/BuildingFlows 

     

    See this article on how to get the last row in an Excel table using Power Automate cloud flows: https://www.powertechtips.com/get-last-excel-row-power-automate/

    -------------------------------------------------------------------------
    If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.

    I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.

  • mertyuksel Profile Picture
    4 on 14 Sep 2023 at 04:15:04
    Re: How can I get LAST ROW of Excel file in PowerAutomate?

    I use Excel when creating flow in Automate tool.  My question about Power Automate Tool.

  • Agnius Bartninkas Profile Picture
    10,045 Most Valuable Professional on 14 Sep 2023 at 03:11:46
    Re: How can I get LAST ROW in Excel?

    As Srini mentioned, you can use the Get first free column/row from Excel worksheet that will give you the first free row. This means that your last row is %FirstFreeRow-1%, as the first free row is the row right after the last non-empty row.

     

    To your other question, yes, you should be able to use date and time values in comparisons. Depending on whether Excel interprets it as a valid date and time, you may either be able to do the comparison right after you read data from Excel, or (if it doesn't interpret it as a date and stores it as a text), you may need to use Convert text to date time on it first.

    -------------------------------------------------------------------------
    If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.

    I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.

  • SriniK Profile Picture
    3,043 Super User 2025 Season 1 on 13 Sep 2023 at 19:57:46
    Re: How can I get LAST ROW in Excel?

    Hi @mertyuksel 

     

    You can use Get First free row on column action, so this will give you the free row index

     

    If you find this reply helpful, please consider giving it a LIKE AND

    If this reply answers your question or solves your issue, please ACCEPT AS SOLUTION

     

    Thanks,

    Srini

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

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Leaderboard > Power Automate - Power Automate Desktop

#1
eetuRobo Profile Picture

eetuRobo 108 Super User 2025 Season 1

#2
CU12050101-0 Profile Picture

CU12050101-0 22

#3
Nived_Nambiar Profile Picture

Nived_Nambiar 20 Super User 2025 Season 1

Overall leaderboard
Loading started