Hi all
I need to loop columns in a table of an Excel Online file stored on Sharepoint.
Each column needs to be saved to an array. Then that array needs to be appended to an array of arrays.
For example
| Fruit | Vegetables | Animals |
| Apple | Lettuce | Cow |
| Pear | Carrot | Dog |
| Banana | Broccoli | Cat |
Result should be:
[
[Apple, Pear, Banana],
[Lettuce, Carrot, Broccoli],
[Cow, Dog, Cat]
]
It seems to be impossible unless I initialize an array variable for each column or do it in Office Script. I want to avoid the latter due to the Run Script daily call limitations. Is there a more dynamic solution within Power Automate someone has come up with?
