how to change the date field color in calendar

[Anonymous]

Hi,

i want to change the date field color based on a text box value

If total_value.text >= 8 then green else red

also based on another factor if either leave or holiday toggle is on the another color other than green & red.TIA

[PowerAddict]

Hi @Anonymous 

Can you provide a little more detail? How is the calendar set up? Is it a gallery? Knowing this can help me better answer your solution. 

---
If you like this reply, please give kudos (Thumbs Up). And if this solves your problem, please mark this reply as a solution by selecting Accept as Solution. This makes it easier for others to find answers to similar questions. 

Thanks!

Hardit Bhatia

Microsoft Business Applications MVP

Blog | Twitter | LinkedIn | Facebook | YouTube  |  Email

[Anonymous]

Hi @PowerAddict  , the calendar is a gallery, here is the screenshot of the form from where condition is to be built up, based on the total text box value, leave & holiday toggle

[Florian_Kleinz · Accepted solution]

Hi,

basically you need to apply the following formula to your day label:

If(ThisItem.Value>=8;Green;Red)

But I think since this component is a little more complex and you want to highlight the date's day you probably need to implement the following:

If(Value(Self.Text)>=8;Green;Red)

Best regards

Florian

[Anonymous]

@Florian_Kleinz it worked, thank you, but i have a doubt it isn't remaining static, only when i click on the date its showing the color.

Currently i have put the formula in selected date fill, is it right? or should i put it in selected date color or in color?

Note:I want the color to be static for the dates for which the form is filled.

[Florian_Kleinz]

Hi,

it seems like you are using a component, since SelectedDateColor and SelectedDateFill are no default properties.

You need to change the Label Fill inside the component. Color only chages Font Color.

Best regards

Florian

[Anonymous]

@Florian_Kleinz, fill makes the entire gallery go green or red based on total, tried with color same thing is happening with fonts.

can we make it static for a particular date in the calendar.

[Anonymous]

Hi,

@Florian_Kleinz,@PowerAddict 

I want to implement the following condition, can you please help me with this

If(date picker date = calendar date & (total text box value >= 8), Green, Red ), also want to add another color based on a toggle how to get this result in power apps

[PowerAddict]

@Anonymous 

To increase visibility of the latest question, I suggest you post it as a new topic. 

Thanks,

Hardit