Hi There,
I would like to know if it would be possible to build a complex html table like so,
The rows are grouped by Site then by Product.
Looking at https://powerusers.microsoft.com/t5/Creating-Apps/Send-email-HTML-format-problem/td-p/121228
@timl & @jhn1 methods seems promising. In their example, the rows are in one column but thats where I'm stuck. I'm not sure how to take their method to produce the above desired layout.
The goal is to push the html table to a word and PDF document.
Kind Regards,
So far I've been able to produce this,
Code:
"<!DOCTYPE html>
<html>
<head>
<style>
thead {background: #195870;}
table, th, td {
border: 1px solid black;
}
</style>
</head>
<body>
<table class=,table,>
<thead>
<tr>
<th class=,sr-only,>Site</th>
<th class=,sr-only,>Products</th>
<th scope=,col,>Details</th>
<th scope=,col,>Unit Cost</th>
<th scope=,col,>Total</th>
</tr>
</thead>
<tbody>
<tr>"
& Concat(Sort(Gallery1.AllItems,Site & Supplier),"
<td colspan=,1,><br>""Site: "&Site&"</td>
<tr>
<td> <th scope=,row, class=,sr-only,>"&Service&"</th>
<tr>
<td><td align=center>"&Supplier&"</td><td align=center>"&BillingAmount&"</td><td align=center>"&BillingMarkup&"</td>
</tr>"
)&"
<tr>
<th scope=,row, class=,sr-only,>Total</th>
<td><td>Test</td>
</tr>
</tbody>
</table>"
Still figuring out how to group them by Site and Product.
More Progress,
Following another example : https://powerusers.microsoft.com/t5/Creating-Apps/Send-email-HTML-format-problem/td-p/121228
Current result and the example of the end goal. Just need to figure out how to group "Products" now. Getting close.
Managed to get the items aligned but its pulling blank products,
It shouldnt show Product 3 under Site 1, there is no Products3 under Site 1, likewise for Site2.
Clear(TableRows);
Clear(galleryGrouped);
Clear(galleryGrouped2);
ClearCollect(galleryGrouped,
GroupBy(Gallery, "Site", "Service")
);
///Supplier is items/////
ClearCollect(galleryGrouped2,
GroupBy(Gallery, "Service", "Supplier")
);
ForAll(galleryGrouped,
Collect(TableRows,
{SortCol: Site & "0",Value:"<tr><td colspan=""2"" style=""Background-color:gray;"">" &
Site & "</td></tr>"}
);
ForAll(galleryGrouped2,
Collect(TableRows,
{SortCol: Site& Service & "0",
Value:" <tr>
<td> <th scope=,row, class=,sr-only,>"&Service&"</th>"
}
));
ForAll(Service,
Collect(TableRows,
{SortCol: Site& Service & "1",
Value:" <tr>
<td> <th scope=,row, class=,sr-only,>"&Supplier&"</th>" & "
<td> <th scope=,row, class=,sr-only,>"&BillingAmount&"</th>" }
))
)
Helpful resources
Community Blog
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Power Apps Community Call- January
Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST
Global Power Platform Bootcamp
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
Power Platform Community Conference On Demand
Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!
