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 / Extract data from web ...
Power Automate
Unanswered

Extract data from web page creating multiple Excel sheets instead of one from a loop.

(0) ShareShare
ReportReport
Posted on by

I have created this flow.

1. however, each time it goes through the loop it is creating an Excel file. so if I want to loop 500 times it will create 500 Excel sheets. I don't want that. I just want one Excel sheet with all the data. what am I missing?

 

wolston_0-1677448059680.png

 

2. also, I tried to record a copying function to copy an href link. If I want to copy h3 text, I do it two times and then power automate understands and marks the rest of the h3 on the page. however when I try to do it with the href it does not automatically recognize all hrefs. how do I reconcile that? I have also tried to add 'send right click' and copy link that way but it still does not seem to recognize it.

I have the same question (0)
  • OkanMTL Profile Picture
    703 Super User 2024 Season 1 on at

    Hi,

     

    You are using the wrong actions.

    You got to use action insert row into excel worksheet.

    Now you can write all your data into one worksheet.

     

    But your workflow is also missing something. You want to have your excel action within your loop

    OR

    You want to make an empty datatable before your loop, within your loop add your data to the datatable you made after the loop add the data to you excel worksheet. I would try the first one :).

     

    If you have more questions let me know. But this should work.

     

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!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 605

#2
Valantis Profile Picture

Valantis 340

#3
11manish Profile Picture

11manish 284

Last 30 days Overall leaderboard