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

Like (0) Share

Report

Posted on 26 Feb 2023 21:53:03 by wolston

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?

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.

All responses (1)

Answers (0)

OkanMTL 703 Super User 2024 Season 1 on 27 Feb 2023 at 09:43:44

Like (0)

Report

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

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.