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

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Pivot column in sharep...
Power Automate
Answered

Pivot column in sharepoint List with Power automate

(0) ShareShare
ReportReport
Posted on by iglesias6 50

Hey Guys!

 

I have the following sharepoint list:

 

iglesias6_0-1713193237919.png

 

 

I would like to create a new sharepoint list that gives me the following:

Cust_HighLevelVertical    Customer Name

Education                         New York City... ; Palm Beach Country... ; University of IOWA ; john hopkins university

Finance                             Banco Santander Rio S.A

 

Is there a way to create a flow with power automate to do this? How?

 

If not possible, how is the best way to do this?

 

Thanks a lot!

Categories:
General topics
  • Verified answer
    Chriddle Profile Picture
    Chriddle 8,729 Super User 2026 Season 2 on at

    Chriddle_0-1713195102486.png

    Compose

    [
	{
		"Name": "name 1",
		"HighLevel": "Education"
	},
	{
		"Name": "name 2",
		"HighLevel": "Finance"
	},
	{
		"Name": "name 3",
		"HighLevel": "Education"
	},
	{
		"Name": "name 4",
		"HighLevel": "Education"
	},
	{
		"Name": "name 5",
		"HighLevel": "Finance"
	}
]

     

    Select

    From

    xpath(
	xml(json(concat('{"Root":{"Item":', outputs('Compose'),'}}'))),
	'//HighLevel[not(preceding::HighLevel=.)]/text()'
)

    Map Education

    item()

    Map Name

    join(
	xpath(
		xml(json(concat('{"Root":{"Item":', outputs('Compose'),'}}'))),
		concat('//Item[HighLevel="', item(), '"]/Name/text()')
	),
	' ; '
)

     

    Chriddle_1-1713195242428.png

     

  • iglesias6 Profile Picture
    iglesias6 50 on at

    Can you give me some explanations of what you are doing? Also, I have like one hundred different names. Is there a way to do this dynamic?

     

    Also, would you share with me that flow??

  • Chriddle Profile Picture
    Chriddle 8,729 Super User 2026 Season 2 on at

    Can you give me some explanations of what you are doing?

    The Select's From creates a list of distinct HighLevels

    In Map Name the xpath() creates an array of Names with that HighLevel which is then joined into a string.

     

     

    Also, I have like one hundred different names. Is there a way to do this dynamic?

    This is dynamic and can handle hundreds of different names

     

     

    Also, would you share with me that flow??

    I already deleted it, but these are only 2 actions. Just create them 😉 

  • iglesias6 Profile Picture
    iglesias6 50 on at

    All right!

    But I am not getting how I get a new sharepoint list out of this. I created one, and I want to put this outcome in it:

    iglesias6_0-1713268959212.png

     

    iglesias6_4-1713270765484.png

     

    So, when I test it, I get this:

     

    iglesias6_5-1713270860333.png

     

     

    And I would like to get this:

     

    Cust_HighLevelVerticalCustomer Name
    EducationNew York City... ; Palm Beach Country... ; University of IOWA ; john hopkins university
    FinanceBanco Santander Rio S.A

     

    I should be getting only once the "Education" row, only once the "Finance" row and so on. Also, I don´t want to get the "Name:name1" and that stuff. I believe I am not getting something from your response from before, sorry for that.

     

    Can you explain me again how I can get this outcome?

  • Chriddle Profile Picture
    Chriddle 8,729 Super User 2026 Season 2 on at

    The Apply to each has to loop over body('Select')

    The create Item's Title has to be items('Apply_to_each')['Education']

    Customer value has to be items('Apply_to_each')['Name']

  • iglesias6 Profile Picture
    iglesias6 50 on at

    Following this steps, I am getting this:

     

    iglesias6_0-1713273015802.png

     

     

    Just in case, I am sharing my flow:

     

    iglesias6_1-1713273056731.png

     

    Why it is 

    "The create Item's Title has to be items('Apply_to_each')['Education']" 

    Shouldn´t it be something that includes all of my Cust_HighLevelVertical column?

  • Chriddle Profile Picture
    Chriddle 8,729 Super User 2026 Season 2 on at

    My flow uses my data (in the Compose). And I use other property names.

    Therefore you have to integrate your data into my flow.

     

    One way (not the most elegant, but probably the easiest) is to include an additional Select right after your Get items:

    From: the values of your Get items

    Map Name: Customer Name (from the Dynamic Content)

    Map Education:  Cust_HighLevelVertical (from the Dynamic Content)

     

    Then replace my data in the Compose' with the body of this new Select.

     

  • iglesias6 Profile Picture
    iglesias6 50 on at

    Okey, I didnt get that you wanted to use another names and stuff, my bad.

     

    Now I am following better but I dont understand how my compose would be. Can you enter into detail there?

     

    iglesias6_0-1713278668858.png

     

    I know this is wrong, but how should it be?

  • Chriddle Profile Picture
    Chriddle 8,729 Super User 2026 Season 2 on at

    Clear the Compose's Input.

    Then add the expression body('Select_2')

  • iglesias6 Profile Picture
    iglesias6 50 on at

    Alright! This worked almost perfectly.

     

    I got this error only:

    The 'inputs.parameters' of workflow operation 'Create_item' of type 'OpenApiConnection' is not valid. Error details: The API operation 'PostItem' requires the property 'item/Customer' to be a string of maximum length '255' but is of length '332'.

    iglesias6_0-1713279424821.png

     

    Do you know how this can be fixed?

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Mohsin Ali Profile Picture

Mohsin Ali 424

#2
11manish Profile Picture

11manish 328 Super User 2026 Season 2

#3
M Bilal Khan Profile Picture

M Bilal Khan 274

Last 30 days Overall leaderboard

Featured topics

Known issue with browser automation in Power Automate for Desktop on Google Chrome 146 and 147
Share your ideas and struggles with building Power Automate flows!
Survey: Power Automate mobile app
How to Ask for Help with Your Power Automate Workflow
Start and wait for an approval action
Restore a deleted flow
List of actions cheat sheet for Power Automate Desktop
Welcome to the Power Automate forum!

Product updates

Microsoft Power Platform Community release plans