
Hi, I was wondering if it was possible to use Power Automate to unpivot certain columns of data? I have a massive file of data but I need to unpivot only certain columns. Is this possible. The steps are the following:
1. Extract a copy of the data from sharepoint (key word is copy - I do not want to edit the format of the original file)
2. Once file is open, extract the data from a certain sheet and only extract certain columns
3. Take the columns and unpivot the data (which I would the data transform function manually)
Is this at all possible? Let me know. Thanks!
Dear G,
Did you investigate the use of office scripts? These can be called from PowerAutomate, but work within the Excel application. I cannot think of trying to unpivot inside PowerAutomate, unless there is some kind of specific action for this (am sure you checked this already).
Suggest you try out office scripts in simple way first (get it to work) and then see if you can do unpivot.
There are plenty of references in the videos/forums on how to first start with office scripts.
Happy flowing,
Koen