html cell background-color

(0) Share

Report

Posted on by GeekAlf_Pro

402

Hi there,

i have a collection, and i want to send a email in an html format.

i want furthermore display cell's color depending on the status value.

i mess to achieve that last point, and i don't know if it's possible in Powerapps or if i have to do it in power automate

The basic html code is the following

<td style=""background-color:red;"">" & Statut & " </td>

i tried something like that, but without succes

If(Ldlv_Rapport.Statut in "HS";
 <td style=""background-color:red;"">" & Statut & " </td>);
 Ldlv_Rapport.Statut in "HS après intervention";
 <td style=""background-color:Orange;"">" & Statut & " </td>);
 white)

i want to have something like that

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

WarrenBelz 153,026 Most Valuable Professional on at

Like (0)

Report
Hi @GeekAlf_Pro ,

Following the logic you posted, try this

"<td bgcolor =" & If( Ldlv_Rapport.Statut in "HS"; "#FF0000"; Ldlv_Rapport.Statut in "HS après intervention"; "#FFA500"; "#FFFFFF" ) & ">" & Statut & " </td>"

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
GeekAlf_Pro 402 on at

Like (0)

Report

Hello @WarrenBelz

thanks for taking time to answer.
unfortunatly, i have this message
it says "impossible to use Table in this context"

Was this reply helpful? Yes No
WarrenBelz 153,026 Most Valuable Professional on at

Like (0)

Report
@GeekAlf_Pro ,

I cannot test this presently, but what happens when you do this

"<td bgcolor = #FF0000">" & Statut & "</td>)"

Was this reply helpful? Yes No
GeekAlf_Pro 402 on at

Like (0)

Report
with your code slightly modified, all the column is red

<td bgcolor = #FF0000>" & Statut & "</td>

Was this reply helpful? Yes No
GeekAlf_Pro 402 on at

Like (0)

Report

i think that it is not the code with the color that's the problem
but the fact that i can't use the value of the status, hence the message "impossible to use a table in this context"

Was this reply helpful? Yes No
Verified answer

WarrenBelz 153,026 Most Valuable Professional on at

Like (1)

Report
@GeekAlf_Pro ,

Then the other code should work and display the different colours. Try this, but it is really the same

With( { wColour: If( Ldlv_Rapport.Statut in "HS"; "#FF0000"; Ldlv_Rapport.Statut in "HS après intervention"; "#FFA500"; "#FFFFFF" ) }; "<td bgcolor =" & wColour & ">" & Statut & " </td>" )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
GeekAlf_Pro 402 on at

Like (0)

Report
Thanks a lot @WarrenBelz

the "with" helps me a lot and i replaced the "ldlv_rapport.statut" by "ThisRecord.statut" and it works fine !

here is the final code
"& With( { wColour: If( ThisRecord.Statut in "HS"; "#FF0000"; ThisRecord.Statut in "OK après intervention"; "#FFA500"; ThisRecord.Statut in "OK"; "#b0f2b6"; "#FFFFFF" ) }; "<td bgcolor =" & wColour & ">" & Statut & " </td>" )&"

Was this reply helpful? Yes No