FIll label in calendar with 4 condition

(0) Share

Report

Posted on by DanieleZanchi93

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?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Rajkumar_M 3,747 Moderator on at

Like (0)

Report
Copy link

Link copied!
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.

Was this reply helpful? Yes No
DanieleZanchi93 25 on at

Like (0)

Report
Copy link

Link copied!

hi @Rajkumar_404 ,

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

Was this reply helpful? Yes No
Verified answer

Rajkumar_M 3,747 Moderator on at

Like (0)

Report
Copy link

Link copied!
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.

Was this reply helpful? Yes No
DanieleZanchi93 25 on at

Like (1)

Report
Copy link

Link copied!

@Rajkumar_404
thank's for the solution!!!!!!

Was this reply helpful? Yes No