This is extremely inefficient. If you then end up writing it as a single data row anyway, there is no point to add those items into a list in the first place. You could simply target each of the values in the Write to Excel worksheet. Also, this approach assumes there is a finite number of values to write, which is not robust at all.
The correct approach would be building a loop that writes each value individually in a separate cell and incrementing a column index. Somewhat like this:
- Loop from 0 to %DataFromWebPage.RowsCount-1%, increment by 1, store the index into %LoopIndex%
- Write to Excel worksheet the value %DataFromWebPage[LoopIndex][0]% (as it is probably a data table with a single column) into row 1 (or whichever row you want to write it to) and column %LoopIndex+1% (because LoopIndex is 0-based, but Excel columns are 1-based).
- End loop
-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.
I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.
