web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate - Building Flows / Building a Flow: Micro...
Power Automate - Building Flows
Unanswered

Building a Flow: Microsoft Excel - Unpivot Data using Data Transform function

(0) ShareShare
ReportReport
Posted on by GBLM2020 4

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!

Categories:
Flow Mobile App
Business Process Flows
I have the same question (0)
  • Unknown geen idee Profile Picture
    Unknown geen idee 1,757 on at
    Re: Building a Flow: Microsoft Excel - Unpivot Data using Data Transform function

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Congratulations to the October Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 691 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 431 Moderator

#3
developerAJ Profile Picture

developerAJ 266

Last 30 days Overall leaderboard

Featured topics

Share your ideas and struggles with building Power Automate flows!
Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans