web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Changing Date Value Co...
Power Apps
Unanswered

Changing Date Value Color if Date falls on Weekend

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hello, 

 

So I have a gallery list with events and the dates they occur on, I want the dates that occur on a weekend to be highlighted in Green and the ones that are on weekdays in black normally. I keep trying a bunch of codes out but nothing is working for me. 

 

What code should I be putting in the colors field to be able to only have the weekends as green? 

 

Here are a few I have tried, that make the most sense to me, but still won't work: 

If(Date(ThisItem.'Occurs On ') = Date("Friday" Or "Saturday"),Green, Black)

If(ThisItem.'Occurs On ' = "Friday" Or "Saturday",Green, Black)

 

 

 

Categories:
I have the same question (0)
  • Verified answer
    Digital Profile Picture
    1,207 on at

     

    How about formatting date as text then comparing text to text?

     

    If(

    Text(ThisItem.'Occurs On ',"dddd") = "Friday" Or Text(ThisItem.'Occurs On ',"dddd") = "Saturday",

    Green,

    Black

    )

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 796 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 327 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard