Hello,
I have not been able to find an answer for this particular scenario. My end goal is an email with a color-coded table based on certain values in the table. Example below.
I have a PowerBI query that returns a table. I want to color code based on conditional formatting for certain values and send this in an email. My current process runs through a list of departments to run the query and email to each. Set variable (department), run a query against a dataset, select to format the columns, create html table from select output, compose using basic html for borders and background color then if the table is not empty, send an email.
Using compose doesn't allow custom coloring based on columns since its pulling Output from Select.
I have attempted to remove Create HTML table step and do compose based off Select output, but it didn't return a table at all.
I attempted Initialize variable type string, append to string variable using <td data-tag="green"> and output of Select but this didn't return a table at all.
I am new to HTML, JSON etc. and am stuck. Has anyone had success with this?
Current flow:
Goal result:
