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?
First free row does not work when you have an empty row in between populated rows
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.
I use Excel when creating flow in Automate tool. My question about Power Automate Tool.
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.
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
WarrenBelz
146,776
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
66,093
Most Valuable Professional