cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
LeeB_CDN
Helper III
Helper III

TextBox Fill Conditional Formatting based on ComboBox InputTextPlaceholder Default Value

Good day, Geniuses 

 

Trying to change the Fill field in a Textbox to white if a ComboBox InputTextPlaceholder value is at the default "Find Items". This process is happening within an existing "If" statement which changes the Textbox Fill to red or green based on a date comparison... 

Here is the existing working formula residing in the Fill property of the Text box.

If(DateDiff(DatePicker1.SelectedDate, DateValue(TextPMeterDate.Text), Months) > -12, LightGreen, LightPink)

 

Thanks for anyone's assistance and time! 

 

Lee_B

1 ACCEPTED SOLUTION

Accepted Solutions
poweractivate
Community Champion
Community Champion

@LeeB_CDN 

 

IsEmpty(SomeCombobox.SelectedItems)

 

Put something like this IsEmpty above in an outer condition to see if nothing is selected of a Combobox. Then put your existing condition inside for the no side (not empty) - on the yes side you can put the White color. Check if it helps as starting point.

View solution in original post

2 REPLIES 2
poweractivate
Community Champion
Community Champion

@LeeB_CDN 

 

IsEmpty(SomeCombobox.SelectedItems)

 

Put something like this IsEmpty above in an outer condition to see if nothing is selected of a Combobox. Then put your existing condition inside for the no side (not empty) - on the yes side you can put the White color. Check if it helps as starting point.

View solution in original post

LeeB_CDN
Helper III
Helper III

poweractivate! You nailed it... I was trying IsEmpty and IsBlank but couldn't get the syntax to work... Here is the functional code: 

If(IsBlank(ComboCalGear.Selected), White, DateDiff(DatePicker1.SelectedDate, DateValue(TextPMeterDate.Text), Months) > -12, LightGreen, LightPink) 

Love this forum! Thanks again. 

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (1,624)