Announcements
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
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
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
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
@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.
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.
@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.
@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
@Anonymous
To increase visibility of the latest question, I suggest you post it as a new topic.
Thanks,
Hardit
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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 358 Most Valuable Professional
11manish 214 Super User 2026 Season 2
Mohsin Ali 185
