web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Reading the last row i...
Power Automate
Unanswered

Reading the last row in Excel and adding it (dynamic)

(0) ShareShare
ReportReport
Posted on by 6

Hello, 

 

iwant to write data to the last Excel spreadsheet. The problem or difficulty is that the path is a variable. If I enter the variable as a path, it also finds the file and I can have the information read out of a column. The problem is when I try to add a line I have to specify a line as well. Since the number of rows can change, I cannot always set this to a fixed value. I thought about setting the line once as a variable and writing the entries in the background and then always adding them up. Is there an easier way to do this ? Many thanks in advance.

 

 

Categories:
I have the same question (0)
  • DMKD1 Profile Picture
    6 on at

    Forgot to add it. That ist the Error Code

    { "status": 400, "message": "A value must be provided for item.\r\nclientRequestId: d4c586f6-9d21-40c5-a0b2-b5f0542377d5", "error": { "message": "A value must be provided for item." }, "source": "excelonline-je.azconn-je-002.p.azurewebsites.net" }

  • wskinnermctc Profile Picture
    6,519 Moderator on at

    Does your Excel file have Tables? If there are Tables then you should be able to use the Excel connector "Add a Row Into a Table" would always put data in the last row of a table without needing to know how many rows are present.

  • DMKD1 Profile Picture
    6 on at

    I agree. If I don't use a variable path, it works without having to specify a line. As soon as the path is variable, it expects a "line". In the specification of where the file is located, he also finds the correct table with the variable path. And in the "line" he expects an "object". When I try to add the line by hand it doesn't find anything.

  • wskinnermctc Profile Picture
    6,519 Moderator on at

    Before you Add a Row Into a Table can you first List Rows Present in a Table? Then get a count of the rows using length() on the output of values from the List Rows Present in a Table. Add 1 to the count, and then use that as the line number?

  • DMKD1 Profile Picture
    6 on at

    Could you show it with an example please? I'm not exactly sure how this should look like. 

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 250 Super User 2026 Season 1

#2
Expiscornovus Profile Picture

Expiscornovus 222 Most Valuable Professional

#3
Haque Profile Picture

Haque 174

Last 30 days Overall leaderboard