You’re offline. This is a read only version of the page.
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.
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.
Share
Report
All responses (
Answers (
703
