Unanswered

Conditional Formatting within Send an Email V2

(0) Share

Report

Posted on by 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

Categories:

General topics

I have the same question (0)

All responses (16)

Answers (0)

Andrew_J 1,962 Moderator on at

Like (0)

Report
Copy link

Link copied!

@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

Was this reply helpful? Yes No
JAB331 33 on at

Like (0)

Report
Copy link

Link copied!

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:

Was this reply helpful? Yes No
VictorIvanidze 13,079 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
JAB331 33 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
VictorIvanidze 13,079 on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Andrew_J 1,962 Moderator on at

Like (0)

Report
Copy link

Link copied!

@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

Was this reply helpful? Yes No
JAB331 33 on at

Like (0)

Report
Copy link

Link copied!

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):

Was this reply helpful? Yes No
Andrew_J 1,962 Moderator on at

Like (0)

Report
Copy link

Link copied!

@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

Was this reply helpful? Yes No
Andrew_J 1,962 Moderator on at

Like (0)

Report
Copy link

Link copied!

@JAB331

I note your other post

https://powerusers.microsoft.com/t5/Building-Flows/Flow-to-send-an-email-when-dates-ae-expiring-doesn-t-work-when/m-p/2693948#M302646

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

Was this reply helpful? Yes No