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 / Append new data to nex...
Power Automate
Unanswered

Append new data to next riteow in Excel

(0) ShareShare
ReportReport
Posted on by 4

Hi All,

 

Trying to do a daily scrape on website.  Everything works, but would like the daily result to be added on the same Excel file in the next row.  Tried adding "Insert row to Excel" but still overwrite the 1st row.  Any advice?

 

Attached screenshot of the flow.

 

Many thanks.

scrape sc 2.PNG
I have the same question (0)
  • MichaelAnnis Profile Picture
    5,727 Moderator on at

    I’ve never tried to use the insert row feature, but you are writing to A1, so it’s always going to write to A1. 

    if you insert “above” row 2. Then you would want to write to row 2. 

    if you want to write to the bottom of your excel worksheet, you could find first free row and then write to it. 

    if there is more than 1 result in AmazonResults, then you need a new loop to insert and add per result. 

    good luck!

  • Jay2222 Profile Picture
    4 on at

    Hi MichaelAnnis.

     

    Thanks for your reply, appreciate it.

     

    I tried modifying it to use the Get first free row as per screenshot,  will this be a better option?  However it is still not inserting below.

     

    Any thoughts?

     

    Thank you

    scrape sc 3.PNG
  • MichaelAnnis Profile Picture
    5,727 Moderator on at

    Can you please share the result of AmazonResults.

     

    if you don’t know, in the upper right corner, click the x then find AmazonResults, right click and go to view. I’m interested to see the type of variable it is and the data inside. 

  • Jay2222 Profile Picture
    4 on at

    The view button is not clickable as per screenshot.  

     

    Many thanks!

    scrape sc 5.jpg
    scrape sc 4.PNG
  • MichaelAnnis Profile Picture
    5,727 Moderator on at

    You have to run it. After you run it, AmazonResults should be populated with data, then view will work. You can put a stop by left clicking on the number below “extract web page data”. A press play, it will stop immediately after populating AmazonResults, and we can see what it is. 

    It should be a table.  But I’m interested if it’s 1 row or many rows, is the title a row, or in the header where it should be, because all that dictates what we do next. 

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

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Vish WR Profile Picture

Vish WR 470

#2
Haque Profile Picture

Haque 416

#3
David_MA Profile Picture

David_MA 344 Super User 2026 Season 1

Last 30 days Overall leaderboard