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 / Appending Data on a lo...
Power Automate
Answered

Appending Data on a loop for DataFromWebPage extraction

(0) ShareShare
ReportReport
Posted on by 697

Hello,

 

So I have a very simple loop that searches for a branch, extracts data, then goes to the next branch, extracts data, etc. However it sadly overwrites the data. I want it to append to the same variable, and then once it's done with all 23 branches I will want it to export that to a single excel file. I tried doing it by adding the data to a list : 

 

CharlesBrewer_0-1718218053490.png

But then that it ends up doing it like below (I am only testing with 2 branches), and I'm not even sure how to deal with that data honestly. I tried to push that into excel and it just pushed all the data into 2 cells 😞

CharlesBrewer_1-1718219330127.png

 

 

  • Verified answer
    CU16071609-1 Profile Picture
    6,255 Moderator on at

    @CharlesBrewer 

     

    I think above data looks fine only. Once your iteration is completed then you can use for each loop and write the first data table into excel then get last free row details and again write with second data table and follow the same approach in iteration mode. Hope it helps!

     


    Thanks,
    Deenuji Loganathan 👩‍💻
    Automation Evangelist 🤖
    Follow me on LinkedIn 👥

    -------------------------------------------------------------------------------------------------------------
    If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀

  • CharlesBrewer Profile Picture
    697 on at

    That was so obvious I'm sad, I'm not sure why I was trying to put it into a list first. I've never tossed stuff into an excel, thanks 😄

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 Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 227 Super User 2026 Season 2

#2
11manish Profile Picture

11manish 221 Super User 2026 Season 2

#3
Mohsin Ali Profile Picture

Mohsin Ali 132

Last 30 days Overall leaderboard