Conditional Formatting within Send an Email V2

[JAB331]

Hello,

I have a flow that sends an email weekly showing a number of dates from a SharePoint list for certificate expirations, what I would like to do is conditionally format all dates within the email that are within 10 days of today's date to be red and bold. I don't even know if this is possible let alone where to start so any help would be great.

Thanks

[Andrew_J]

@JAB331 

As a suggestion I would use an HTML table that way you can format the cell output you need if I am reading your query correctly.  If that is the case then look at the below by @DamoBird365 :

https://www.youtube.com/watch?v=LQumCR1B-q0&t

He guides you through this type of thing.  I hope you can work through the above and get to where you need.

Regards,

Andrew

[JAB331]

Hello,

Thank you for the suggestion, the issue I am having with this is each email includes every single expiry date for every person in the sharepoint list, rather than just the row relevant to the specific person, hopefully these screenshots make it clearer what I am working with:

[VictorIvanidze]

Create a static HTML table formatted as you wish. Use it in your flow.

[JAB331]

I'm really sorry but I don't understand what the difference would be or how I would do that?

[VictorIvanidze]

I just tried to tell you what your question is about HTML, not about Power Automate.

Can you create a static HTML file that will display the table according your needs?

If yes, I'll try to help you to adopt this HTML code for your flow.

[Andrew_J]

@JAB331 

Spend sometime looking at the video, the video will give you something like the following:

The above is basically a task list.

Perhaps you could send us your flow so we can see what you have done so far.  Hopefully you can expand the steps so we can see the dynamic content.  Otherwise neither of us can help further.

Regards,

Andrew

[JAB331]

The flow sends an email when any date in any column is within 10 days of todays date
(I have an issue when there is a blank but that is a separate issue):

[Andrew_J]

@JAB331 

In my opinion your flow is wrong, but there are many ways in being able to acheive anything. I cannot even see the HTML table in the output but more a straight list of items.  But even without this your process is still confusing.  I can see that you have a vertical list in the flow but it is how the orignal SharePoint List is formated that is the issue.  Can you send us an image of this please.

Regards,

Andrew

[Andrew_J]

@JAB331 

I note your other post

https://powerusers.microsoft.com/t5/Building-Flows/Flow-to-send-an-email-when-dates-ae-expiring-does...

This has some of the information I need but not all I need to see the first column that may have a name of a person that holds the certifcate that is about to expire as indicated by the magenta line.

Lets stick to one post about the subject to avoid confusion.  Can you delete the other post please.

Andrew

[JAB331]

Hi Andrew,

I sincerely appreciate any help and I apologise for the double post, I thought it was best to do that for two separate issues but I will delete it.

This is the data missing from the sharepoint list but there are 15 columns

At this stage I am happy to change the formatting for the list and the flow as I am really just trying things out to see if it is possible.

This is the email including the HTML table

[Andrew_J]

@JAB331 

So we need flow that takes the list for each member of staff and check if there is any expiry date 10 days before it is due.

FLOW APP	NOTES
Recurance	Set to daily
Compose	use adddays(utcnow(), -10)
Get Items	use the filter to check weach of the 15 expirey dates in turn  BIOSET eq 'COMPOSE' then the rest in order.  If you do not want to do it this way you can add a FILTER app after the GET ITEMS and do it that way.  But the idea is to get the list of items down to 0 or many.

The above should give you an output of names and expiry dates that meet your needs.  But it would be good to see what you do get as an output of the above.  I can see some that might give us some data.

We then need to use this data to construct an HTML table that might look like:

NAME	EXP 01	EXP 02	EXP 14
Name 1		DATE	DATE
Name 4	DATE		DATE
Name 9		DATE	DATE

You can format the above a lot better but lets get the basics in place first, I can send you the CCS of my example in a future post.

Once you have the above you can add to an email and send you every day if it meets the crirtera. 

Have a look at putting the above in place and let me know where you get stuck.

Regards,

Andrew

[JAB331]

Hi Andrew,

Thank you, I am a complete beginner so to clarify I am using the Odata Filter on the get items function to check whether each column is equal to the output of the compose action?

[Andrew_J]

@JAB331 

Yes at the following:

So condtion would be Query 01 and Query 02 and Query etc like the below example:

where Query 01 = BIOSET eq 'COMPOSE' modifiy for the rest.  All the column names are Case specific, so if you put a lower case charecter in place of an upper case it will not work as you want.

Andrew

[JAB331]

Hi Andrew,

I have created the following:

But I only get the following error when testing:

[Andrew_J]

@JAB331 

I am sorry but I gave you some incorrect advice above and I know why you got the error above.  I know you want one weekly email but I think you will only be able to have a number of weekly emails with indvidual results on them. 

I spent a bit of time trying to educate myself on this last night, UK and could not make what yo want to do work as yet. 

As time is moving on on this I would suggest that we proceed with the following:

The above would give you a table like the following:

But you will need to produce the above for each date item column. Then once the HTML table is generated you can send yourself an email.

I appoligise for all the other work I will have put you into but I cannot find a way to have all users with all columns on one HTML table per week.  The issue I am having is some colums in my test list have blanks or are empty.  And we need to also deal with all condtions in the HTML table via an expression.  I can currenlty get some to work but not all.

I will continue to work on this if you want as it interests me but that is as far as I can get at the moment.

Regards,

Andrew

[JAB331]

Hello Andrew,

Sorry for the slow reply, unfortunately that solution will not work for me. There are blank lines but what I am considering is adding a date long in the past for the blanks and then adding a condition to ignore columns that are before a certain date.

Any help you can give is greatly appreciated.