Unanswered

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

(0) Share

Report

Posted on by mertyuksel

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?

Categories:

Power Automate Desktop

I have the same question (0)

All responses (5)

Answers (0)

Srini007 3,327 Super User 2025 Season 2 on at

Like (1)

Report

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

Was this reply helpful? Yes No
Agnius Bartninkas Most Valuable Professional on at

Like (0)

Report

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.

Was this reply helpful? Yes No
mertyuksel 4 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Agnius Bartninkas Most Valuable Professional on at

Like (0)

Report

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.

Was this reply helpful? Yes No
johnnyongesa 8 on at

Like (0)

Report

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

Was this reply helpful? Yes No