cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Hiritik
New Member

Power Automate Desktop Web recorder

Hi All,

I am trying to use Power automate desktop web recorder to search anything over google and later extract all the links on that page in an excel file.

I want the storage to start from cell A2 onwards in excel but its starting from cell A1 and overwriting my header in cell A1.

 

Please help !!
Thanks in advance 🙂 

3 REPLIES 3
Shalu
Microsoft
Microsoft

Hello @Hiritik ,

 

Please note, when the data is extracted using "Extract data from Webpage", it always creates a new Excel Instance and the data gets stored on Cell A1.

Shalu_0-1621994084058.png

 

If you would like to add header to the extracted data, please use "Insert Row to Excel Worksheet" as shown below:

Shalu_1-1621994129680.png

 

So the flow can look like this, In this way the Row 1 can remain with headers:

 

Shalu_2-1621994200656.png

 

I hope the above proves to be helpful.

 

If this post helps, then please Accept it as the solution to help the other members find it more quickly.

 

Regards,

Shalini M

PiperDan
Helper I
Helper I

great reply and great examples

Shalu
Microsoft
Microsoft

Thank you, @PiperDan 

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Users online (3,611)