News and Announcements icon

Power Platform CommunityForums Power Apps - Building Power Apps Change text box color ...

Power Apps - Building Power Apps

Unanswered

Change text box color based on date in Holiday Calendar

(0) Share

Report

Report

Posted on by CU30071822-0

Hello!!!!

Is it possible to change the color of a text box if the date on a label is a holiday?

I have created a holiday table:

This is my label and the syntax in my label

This is my text box i want to change the color if its label is a holiday date based off of the Holiday table.

Appreciate the help!!!

All responses Img

All responses (2)

Answers Img

Answers (0)

CU30071822-0 on at

Like (1)

Report

Re: Change text box color based on date in Holiday Calendar

Thank you so much Tina!!!! it worked great. I changed it to the fill property ..... appreciate your response.
v-hanytian-msft Microsoft Employee on at

Like (0)

Report
Re: Change text box color based on date in Holiday Calendar

Hi @jubae22 ,

We made a sample for you.

Dataverse:

Color of Text Box(TextInput):

If(CountRows(Filter(Holidays,Text('Hoiiday Date',"[$-en-US]mm-dd-yyyy") = Label1.Text))>0,Color.Red,Color.Black)

If you want to change another properties instant of font color, this is the reference Document.
Text input control in Power Apps - Power Apps | Microsoft Learn

Hope this will help you,
Best Regards,
Tina