Unanswered

SharePoint List - Change dropdown font colour if corresponding column is blank/empty

(0) Share

Report

Posted on by Rob_CTL

Hi,

I have a dropdown control that is populated by a SharePoint list, that is setup like the one below:

The DropDown in PA is populated from the values in column "Title". As you the other column (Value) in most cases has a value listed but Item 3 is empty. What I'd like to be able to do is if a user selects Item 3 from the dropdown the font colour will change to RED to alert the user there is no value associated to that item. This is what I've tried so far but I can't get it to work, this is in the "Color" property on the dropdown.

If(IsEmpty('TestList'.'Value'),Red,Black)

Hopefully this idea will work, the ideal would be to hide Item 3 from the drop down completely but that might be a step to far to achieve.

Thanks in advance for any help.

Rob

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report
Re: SharePoint List - Change dropdown font colour if corresponding column is blank/empty

@Rob_CTL

You will not be able to set the color of the individual item IN the dropdown list, but you can change the color if the selected item has a blank value.

Change your Color formula to the following:

If(IsBlank(Self.Selected.Value), Red, Black)

I hope this is helpful for you.

Was this reply helpful? Yes No
Verified answer

Rob_CTL on at

Like (0)

Report

Re: SharePoint List - Change dropdown font colour if corresponding column is blank/empty

@RandyHayes thanks for the reply, the solution didn't quite do what I wanted. I've come up with a work around that uses a couple of hidden boxes to post a message on the screen then the value is empty.

Thanks

Was this reply helpful? Yes No