Transpose HTML table Rows & Columns and send the table as an email

(0) Share

Report

Posted on by sasidhar_mudra

166

@v-xida-msft ,

Hi,

You have been my saviour 🙂 I built multiple apps and my team is using the same from last one year now...

I came across a requirement for my team.

I want to send the HTML table as an email from PowerApps. I got what I am looking for. However, I want to transpose Rows and Columns. Attaching the code I used to get the HTML table. Request you to advise

HTML Table.jpg

HTML Table Email.png

Thanks

Sasidhar

HTML Table_Transpose.png

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

MatthewInwards 138 on at

Like (0)

Report

Hi @sasidhar_mudra ,

Could you be more specific as to how you would like to transpose the columns and rows.

Thanks
Matt 🙂

Was this reply helpful? Yes No
sasidhar_mudra 166 on at

Like (0)

Report

@MatthewInwards @The 3rd screenshot is the reference. I want Employee ID, Employee Name and Manager Name in the first column and the second column should show the relevant information.

Was this reply helpful? Yes No
MatthewInwards 138 on at

Like (0)

Report

So to be clear, this table will never have more than 1 records worth of data within it?

Was this reply helpful? Yes No
sasidhar_mudra 166 on at

Like (0)

Report

@MatthewInwards ,
Yes. Below is what i am looking for.

Regards
Sasidhar

Was this reply helpful? Yes No
Verified answer

sasidhar_mudra 166 on at

Like (1)

Report
@MatthewInwards ,

I got it. I did minute changes in the code and i was able to get what i was looking for. Thank you 🙂
"<h> Hi Team, </h>" & "<p>"& "Request you to process the below:" & "<p>" & "<table width='100%' border='1' cellpadding='5' style='border:1px solid black; border-collapse:collapse'>" & "<tr style='text-align:left'> <th>Employee ID</th>" & Concat(autoupdatefromexcel, "<td>" & 'Employee ID' & " </td>") & "</tr>" & "<tr style='text-align:left'> <th>Employee Name</th>" & Concat(autoupdatefromexcel, "<td>" & 'Employee Name' & " </td>") & "</tr>" & "<tr style='text-align:left'> <th>Manager Name</th>" & Concat(autoupdatefromexcel, "<td>" & 'Manager Name' & " </td>") & "</tr>" & "</Table>"

Regards
Sasidhar

Was this reply helpful? Yes No