Skip to main content

Notifications

Community site session details

Community site session details

Session Id : +Uip84ZiWXL8ScPGIclKQU
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,025 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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

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

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,776 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,093 Most Valuable Professional

Leaderboard