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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / FIll label in calendar...
Power Apps
Answered

FIll label in calendar with 4 condition

(0) ShareShare
ReportReport
Posted on by 25

Hi everyone,

i built a calendar in power apps like a youtube video from Shane Young; and it's work.

i need to fill the label depending on the conditions.  

I write a formula with three condition and it's work but when i try to add a fourth condition I cannot write the correct formula. the formula whit trhee condition is this

 

If(
    LookUp(Input14,Self.Text=Text(Created,"dd/mm"), true ),If(Sum(Filter(Input14,Self.Text=Text(Created,"dd/mm")&&Priorit_x00e0_>0),Priorit_x00e0_)>0,Color.Red,Color.Yellow),
        RGBA(0,0,0,0))
 
 
i need in the last part of IF to insert the condition when the day is < of today the label became green otherwise the label is RGBA(0,0,0,0).
 
Could you plese help me?
Cattura3.PNG
Categories:
I have the same question (0)
  • Rajkumar_M Profile Picture
    3,747 Moderator on at

    Hi @DanieleZanchi93 

     

    Try this formula,

     

    If(
    LookUp(Input14, Self.Text = Text(Created, "dd/mm"), true),
    If(
    Sum(Filter(Input14, Self.Text = Text(Created, "dd/mm") && Priorit_x00e0_ > 0), Priorit_x00e0_) > 0,
    Color.Red,
    Color.Yellow
    ),
    If(
    DateValue(Self.Text, "dd/mm") < Today(),
    Color.Green,
    RGBA(0, 0, 0, 0)
    )
    )

     

    Thanks!

     

    If my response has been helpful in resolving your issue, I kindly request that you consider clicking "Accept as solution" and "giving it a thumbs up" as a token of appreciation.

  • DanieleZanchi93 Profile Picture
    25 on at

    hi @Rajkumar_404 ,

     

    i tried the formula but appear an error . I try to review the formula but dosen't workerrore.PNG

  • Verified answer
    Rajkumar_M Profile Picture
    3,747 Moderator on at

    Add Text() function.

     

    DateValue(Text(Self.Text, "dd/mm")) < Today()

    (Or) 

     

     DateValue(Text(Self.Text, "dd/mm", "en-GB")) < Today() //Assuming "en-GB" as the locale for "dd/mm" format

     

    If(
    LookUp(Input14, Self.Text = Text(Created, "dd/mm"), true),
    If(
    Sum(Filter(Input14, Self.Text = Text(Created, "dd/mm") && Priorit_x00e0_ > 0), Priorit_x00e0_) > 0,
    Color.Red,
    Color.Yellow
    ),
    If(
    DateValue(Text(Self.Text, "dd/mm")) < Today(),
    Color.Green,
    RGBA(0, 0, 0, 0)
    )
    )

      

    Thanks!

     

    If my response has been helpful in resolving your issue, I kindly request that you consider clicking "Accept as solution" and "giving it a thumbs up" as a token of appreciation.

  • DanieleZanchi93 Profile Picture
    25 on at

    @Rajkumar_404 

    thank's for the solution!!!!!!

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 529 Most Valuable Professional

#2
Haque Profile Picture

Haque 230

#3
Kalathiya Profile Picture

Kalathiya 217 Super User 2026 Season 1

Last 30 days Overall leaderboard