How to fill row color of HTML table using criteria and SendEmailV2

(0) Share

Report

Posted on by flowslcaplikas

How to fill row color with criteria which is sent via Office365Outlook.SendEmailV2 HTML table?

Current Output:

Selected Item	Item	Item Group	Item ID	Item loaded	Item Load original	Item loaded check	Date and Time	Creator
171	171	GRP	1	true	true	true	2099-99-99 10:15:44	NA
171	915	GRP	2	true	false	false	2099-99-99 10:15:44	NA
171	171	GRP	3	true	true	true	2099-99-99 10:15:44	NA
171	171	GRP	4	true	true	true	2099-99-99 10:15:44	NA
171	915	GRP	5	true	false	false	2099-99-99 10:15:44	NA
171	171	GRP	6	false	true	false		NA
171	171	GRP	7	false	true	false		NA

Wanted output:

If Item_loaded = true and item_loaded_check = false, then red.

if Item_loaded = false and item_loaded_check = false then yellow.

Selected Item	Item	Item Group	Item ID	Item loaded	Item Load original	Item loaded check	Date and Time	Creator
171	171	GRP	1	true	true	true	2099-99-99 10:15:44	NA
171	915	GRP	2	true	false	false	2099-99-99 10:15:44	NA
171	171	GRP	3	true	true	true	2099-99-99 10:15:44	NA
171	171	GRP	4	true	true	true	2099-99-99 10:15:44	NA
171	915	GRP	5	true	false	false	2099-99-99 10:15:44	NA
171	171	GRP	6	false	true	false		NA
171	171	GRP	7	false	true	false		NA

Current Code:

Office365Outlook.SendEmailV2(
 "Name.name@name.nt",
 "CheckList",
 "<h3></h3>" &
 "<strong></strong>" &
 "<table width='100%' border='1' cellpadding='5' style='border:1px solid black; border-collapse:collapse'>" &
 "<tr style='background-color:#efefef'>
 <th>Selected Item</th>
 <th>Item</th>
 <th>Item Group</th>
 <th>Item ID</th>
 <th>Item Loaded</th>
 <th>Item Load Original</th>
 <th>Item Loaded Check</th>
 <th>Date and Time</th>
 <th>Creator</th>
 </tr>
 <tr>" &
 Concat(colExternalLoading,
 "<td>" & varselecteditemid& " </td>
 <td>" & item & " </td>
 <td>" & itemgroup & " </td>
 <td>" & itemid& " </td>
 <td>" & loaded & " </td>
 <td>" & loaded_original & " </td>
 <td>" & load_check & " </td>
 <td>" & Text(date_loaded, "yyyy-mm-dd hh:mm:ss") & " </td>
 <td>" & User().FullName & " </td>","</tr><tr>"
 
 )
 &
 "</table>",
 {
 IsHtml:true
 }
));

Thank you.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

flowslcaplikas

94 on at

Like (0)

Report

Copy link

Link copied!

How to fill row color with criteria which is sent via Office365Outlook.SendEmailV2 HTML table?

Current Output:

Selected Item	Item	Item Group	Item ID	Item loaded	Item Load original	Item loaded check	Date and Time	Creator
171	171	GRP	1	true	true	true	2099-99-99 10:15:44	NA
171	915	GRP	2	true	false	false	2099-99-99 10:15:44	NA
171	171	GRP	3	true	true	true	2099-99-99 10:15:44	NA
171	171	GRP	4	true	true	true	2099-99-99 10:15:44	NA
171	915	GRP	5	true	false	false	2099-99-99 10:15:44	NA
171	171	GRP	6	false	true	false		NA
171	171	GRP	7	false	true	false		NA

Wanted output

If Item_loaded = true and item_loaded_check = false, then red.

if Item_loaded = false and item_loaded_check = false then yellow.

Selected Item	Item	Item Group	Item ID	Item loaded	Item Load original	Item loaded check	Date and Time	Creator
171	171	GRP	1	true	true	true	2099-99-99 10:15:44	NA
171	915	GRP	2	true	false	false	2099-99-99 10:15:44	NA
171	171	GRP	3	true	true	true	2099-99-99 10:15:44	NA
171	171	GRP	4	true	true	true	2099-99-99 10:15:44	NA
171	915	GRP	5	true	false	false	2099-99-99 10:15:44	NA
171	171	GRP	6	false	true	false		NA
171	171	GRP	7	false	true	false		NA

Current Code:

Office365Outlook.SendEmailV2(
 "Name.name@name.nt",
 "CheckList",
 "<h3></h3>" &
 "<strong></strong>" &
 "<table width='100%' border='1' cellpadding='5' style='border:1px solid black; border-collapse:collapse'>" &
 "<tr style='background-color:#efefef'>
 <th>Selected Item</th>
 <th>Item</th>
 <th>Item Group</th>
 <th>Item ID</th>
 <th>Item Loaded</th>
 <th>Item Load Original</th>
 <th>Item Loaded Check</th>
 <th>Date and Time</th>
 <th>Creator</th>
 </tr>
 <tr>" &
 Concat(colExternalLoading,
 "<td>" & varselecteditemid& " </td>
 <td>" & item & " </td>
 <td>" & itemgroup & " </td>
 <td>" & itemid& " </td>
 <td>" & loaded & " </td>
 <td>" & loaded_original & " </td>
 <td>" & load_check & " </td>
 <td>" & Text(date_loaded, "yyyy-mm-dd hh:mm:ss") & " </td>
 <td>" & User().FullName & " </td>","</tr><tr>"
 
 )
 &
 "</table>",
 {
 IsHtml:true
 }
));

Was this reply helpful? Yes No

Verified answer

iAm_ManCat 18,256 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hey @flowslcaplikas

We can format the row conditionally during your Concat action, like this: (EDIT, removed the last <tr> as was duplicated during concat)

Office365Outlook.SendEmailV2( "Name.name@name.nt", "CheckList", "<h3></h3>" & "<strong></strong>" & "<table width='100%' border='1' cellpadding='5' style='border:1px solid black; border-collapse:collapse'>" & "<tr style='background-color:#efefef'> <th>Selected Item</th> <th>Item</th> <th>Item Group</th> <th>Item ID</th> <th>Item Loaded</th> <th>Item Load Original</th> <th>Item Loaded Check</th> <th>Date and Time</th> <th>Creator</th> </tr>" & Concat(colExternalLoading, "<tr " & If(loaded && !load_check, "style='color: red;'>", !loaded && !load_check, "style='color: orange;'>", ">" ) & "<td>" & varselecteditemid& " </td> <td>" & item & " </td> <td>" & itemgroup & " </td> <td>" & itemid& " </td> <td>" & loaded & " </td> <td>" & loaded_original & " </td> <td>" & load_check & " </td> <td>" & Text(date_loaded, "yyyy-mm-dd hh:mm:ss") & " </td> <td>" & User().FullName & " </td>","</tr>" ) & "</table>", { IsHtml:true } ));

Chers,

Sancho

Was this reply helpful? Yes No