cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SoufTC
Helper I
Helper I

Formatting column on SharePoint according to today's date

Hello, I try to formatting on SharePoint columns according to today's date. 

The list comes from a form created on Power Apps. 

 

1\Here are the fields concerned

SoufTC_0-1611925860116.png

Automation is based on the following condition :
IF (Status = Planned )& (Planned date < today's date ) THEN StatusPublished and Published date = Planned date.

 

Here is the result according today's date (29/01/2021)

 

Capture.PNG

I don't know if this is possible? Thank's in advance

1 REPLY 1
manuelstgomes
Super User
Super User

Hi @SoufTC 

 

It's possible, but you have to work a little with the "advanced formatting".

 

Here's a tutorial on how to do that.

 

Can you please check if and let me know if you have any questions?

 

Cheers
Manuel

-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

 

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (2,273)