
Announcements
Hi All,
I have flow which gets values from SharePoint using Power automate flow and send mail to the user. Using Create HTML Table I'm getting the values. I have a field called Overall RAG (with Choices Red, Green, Amber). If the Overall RAG value is Red, I want this column background color to be Red. Likewise the same for Green and Amber. Using Compose I have given the replace code to get the background color for the Overall RAG column. The replace code is:
replace(replace(replace(body('Create_HTML_table'), '<td>Amber</td>', '<td background-color = "#FFA500" ></td>'), '<td>Green</td>', '<td background-color = "#008000" ></td>'), '<td>Red</td>', '<td background-color = "#FF0000" ></td>').
And given the output of Compose to the Send an email part. But the background color is not getting displayed for the column.
I have tried to give using the style tag in HTML table but still color is not getting displayed. I have attached screenshots for the same.
Any help/suggestion on this?
Thanks in adavnce.
While doing the replace you eliminate the values to be displayed. your table cells are now empty.