Unanswered

Format Date Colour based on Date Extract from SharePoint List sent via Email

(0) Share

Report

Posted on by GeorgeKh

Hi All,

I have created a Flow that automatically retrieves data from a SharePoint list and sends out an email daily. I have filtered the Status column so only the "WIP" data is issued and i have also formatted the Status Colour based on Status. There is a column marked Estimated Completion Date which i would like to format based on how close to that date it is. For example, if the completion date is due tomorrow i would like the colour to be amber if its due more than two days away i would like it to be Green, if its overdue i would like the date format to be red.. Any ideas on how i can achieve this

Flow looks like :

Select Statement is as follows:

Currently email output is as follows:

Any help would be appreciated.

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (0)

v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @GeorgeKh ,

Do you want to display the date in different colors, according to the interval between date and today, in the email?

Based on your description, I have made a simple test for your reference.

SharePoint list for test:

One Solution is to append each line of the list to a string.

In this way, we can set the line to different colors according to the date in each line.

Result:

Best regards,

Was this reply helpful? Yes No
rishabhkhanna1 56 on at

Like (0)

Report
Copy link

Link copied!

You can use HTML Formatting in compose action based on relevant logic in order to implement this.
Also, other than formatting based on logic for values specific to email, you can also perform column formatting by writing rules specific to that column in sharepoint list as well.

Was this reply helpful? Yes No
GeorgeKh 22 on at

Like (0)

Report
Copy link

Link copied!

Hi @rishabhkhanna1,
Do you have an example of how i can do this?
The formatting in the SharePoint list based on condition only works in the SP list and the formatting does not copy over to the table in the Email

Was this reply helpful? Yes No
GeorgeKh 22 on at

Like (0)

Report
Copy link

Link copied!

I have tried different logic within the Select statement as follows as a trial:
if(equals(item()?['CommittedDateofResolution'],'2022-12-12'),'red','yellow')

This logic works (was for testing only) however the output is the word "Yellow" as opposed to the color yellow. I would also like to know if there is logic for greater than or less than that i can use in this expression?

Was this reply helpful? Yes No