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.
