Pivot the HTML table

(0) Share

Report

Posted on by guanel1

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)

All responses (2)

Answers (1)

Verified answer

David_MA 12,980 Super User 2025 Season 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
guanel1 49 on at

Like (1)

Report

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.

Was this reply helpful? Yes No