cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Tpollock
Regular Visitor

Power Automate DataFromWebpage writing back to Excel

Hey everyone,

I am a self taught person and been using Power Automate for some web scraping and other automated process.  Really enjoy using power automate and learning how it works.  I have finally got to a point where I am stumped.  I have a flow that is built and works really well.  I am just trying to figure out how to improve it.  The flow looks at a excel spreadsheet and flows a URL link listed in the spreadsheet.  Than it extracts the data that I want to pull.  Have no issue till I get to the data table and writing it back to the excel file.  I have attached a screenshot of what I am trying to figure out.  To write back to the same row but move columns I have to add an action for each item in the data table.  I feel I should be able to use a loop for this, but cant seem to get it to work correctly.  Any help on solution would be great.  

 

The next issue I am having goes with this as well.  If the data I pull from the website is already in a table and the number of items in the table change per url link how do I get the flow to keep running without putting up an error.  For example say the first table I get data from has 4 columns and 6 rows I would build the flow for this like the attachment.  But say the next item in the excel sheets url has 4 columns and only 3 rows.  The Flow will crash because it cant write back.  I have tried to use a Label with a On error, but that doesn't work for some reason.  Worst yet say I get a data table that has 4 columns and 10 rows, now I have missed out on data when writing it back to excel. 

 

Any help with this would be great. 

1 REPLY 1
Tpollock
Regular Visitor

Any help on this would be greatly appreciated.

 

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (1,921)