Answered

How to change color of text in table based on value

(0) Share

Report

Posted on by animartis

Hello all,

I am building a quality control flow that will send an email report to individuals with a table of 10 questions and pass value (Yes, No, Needs work, N/A) based on data from a SharePoint List. I'm using Send an Email (v2) with an HTML body to build the table. Everything looks great, but I would really love to color code the pass value, e.g., Yes = Green, No = Red, Needs work = Yellow, etc.

Does anyone have a solution or suggestion on how to do this?

Thanks!

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (1)

Hardesh15 7,087 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@animartis You need to replace complete TD with your color code if it equals to yes. Use one compose and pass

<td style="color:Green;font-weight:bold;">Yes</td> then use equals() for color code.

Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

@Hardesh /Gopenly.in

Was this reply helpful? Yes No
animartis on at

Like (0)

Report
Copy link

Link copied!

Thanks for the response, Hardesh. I understand the HTML piece but am having a hard time figuring out how to call the right variable (compose) based on the answer in the SharePoint List for each question. Any advice on that front?

Was this reply helpful? Yes No
Verified answer

hhaliman 48 on at

Like (0)

Report
Copy link

Link copied!

You can use conditional switch action to do this https://www.enjoysharepoint.com/power-automate-switch-case/
You just need to change the "switch on" field with your sharepoint column for "value", and change the "IT", "Administrator" with "Red", "Gree", etc

Was this reply helpful? Yes No
animartis on at

Like (0)

Report
Copy link

Link copied!

Thanks @hhaliman. So by that rationale, considering I have 10 different SharePoint List 'answers' to my 10 questions with 4 possible answers (Yes, No, Needs Work, N/A), am I correct in assuming that I will have to create 10 different case statements (1 for each answer)? I was hoping there was a way to use one case statement that said, "If any answer is Yes, pass this HTML code for the color GREEN." Almost like a lookup based on the answer.

Was this reply helpful? Yes No
Hardesh15 7,087 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@animartis You can rename the compose action. Go to compose action setting then rename. When you will select dynamic content it will reflect under your compose name.

Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

@Hardesh /Gopenly.in

Was this reply helpful? Yes No