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
You're Invited to Keeping It Real with the Power Platform
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Pivot the HTML table
Power Automate
Answered

Pivot the HTML table

(0) ShareShare
ReportReport
Posted on by guanel1 49
I want to display the data from multiple SharePoint columns in a cleaner way.
Currently, I am just numbering each item and then having the data displayed like this as part of the email body: 
1. Project Name: Lucid
2. Project Number: 12345D
3. Region: AMERICAS
4. Function: Customer Support
5. Cost Role: Level 2
6. Start Date: 1/1/2024
7. End Date: 12/31/2024
 
But I would like to display in more of a table format...however I cannot seem to get the column names to all show up in one column and the values for those columns to show up in the value column. 
I want to "pivot" the table like this: 
Categories:
Building flows
I have the same question (0)
  • Verified answer
    David_MA Profile Picture
    David_MA 14,295 Super User 2026 Season 1 on at
    I think you will need to provide more detail on exactly what you need and how you are currently getting the values. Based on what you show, I would just tell you to put the e-mail action into HTML code view and hard code the table into the e-mail and populate the cells in the column on the right with the values from your SharePoint list.


  • guanel1 Profile Picture
    guanel1 49 on at
    As I am only pulling in one row of data into the email, this is how the data is determined.
    The data I want in column A is the column names that are listed in SharePoint
    The data in column B would be the actual data in that specific row. 
     
    for example: I want all the data from row 12 in the SharePoint to be sent to the owner of that row. So I would also only be pulling in one set of data from one row. 
     
    So I only want to pull in that row's data. 
    I believe that the hard coding option is the best way to do this. 

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
You're Invited to Keeping It Real with the Power Platform

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 569

#2
Valantis Profile Picture

Valantis 484

#3
Vish WR Profile Picture

Vish WR 460

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
Flows are not visible for users who sign in with their personal accounts
Start and wait for an approval action
Restore a deleted flow
List of actions cheat sheet for Power Automate Desktop
Question for everyone : How are you using Create Text GPT in AI Builder?
Welcome to the Power Automate forum!

Product updates

Microsoft Power Platform Community release plans