Unanswered

How to insert row to excel properly in Power Automate Desktop?

(0) Share

Report

Posted on by ken7

I am extracting data from web(data are come from the same webPage) and I want to put them into an excel file

I have done this steps, but when I use for each to loop through the merge list, some of the data in dataFromWebPage that stored in the merge list will lost.

There should be 12 record in dataFromWebPage and 7 record in dataFromWebPage2 , but the final outcome in excel will be 13 rows only, anyone know how to deal with it?

Categories:

Power Automate Desktop

All responses (5)

Answers (0)

Sort by

Daniel_Pa 244 on at

Like
a
(0)

Report
Copy link

Link copied!

Can you provide some more information?
Why are you using two "Extract data from web page"? Does the variables DataFromWebPage and DataFromWebPage2 contain the expected number of entries?
Can you share an image from your variables pane and the content of the two variables?

What is the purpose of inserting new lines? Are you filling in a spreadsheet already containing data? If not, you can just write the list into the desired cell, and it will fill in the values downwards.
ken7 4 on at

Like
a
(0)

Report
Copy link

Link copied!

sure, I am trying to scrap data from a public webpage, but the web page is kind of dynamic, when I expand one section, the other section will be collapse, I am new to power desktop and I can't find a better way to select all of the information I want( i.e all the subtitle and last update time that shows only when section expanded)
Here is the flow variables

variable value in output list
and actual outcome in excel

How can I achieve by filling in the desired cell? Each record have two columns, would it be autofill also?
Daniel_Pa 244 on at

Like
a
(0)

Report
Copy link

Link copied!

Ahh.. The issue seems to be you are using "Merge list" to merge two "Data tables" - thus you list will contain only two items, the two tables.
Thus, you are only looping twice, first inserting the the 12 item table, and then shifting it down once, before inserting the 7 item list on top of it.

Since it seems you are only working with those two list, you could "Write to Excel worksheet" on A1, then "Get first free column/row from Excel" and write the second table to the first free row.

If you need more tables eventually, you could use you loop to get the first free row for each table you want to write and then write to that location.

I hope this makes sense, if not, let me know and i will try to illustrate it.
ken7 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Thx, this seems overall ok now, however there will be strange blank rows created, do you know what leads to the problem?
Daniel_Pa 244 on at

Like
a
(0)

Report
Copy link

Link copied!

Are you reusing the same spreadsheet? Make sure to select the rows and delete them, not just the content of the cells.
Alternatively, try using the "Launch Excel" with at blank sheet.

If that doesn't work, please send a screenshot of the process and I'll take a look.