Fill Color in the Label

[Premwong13]

This is my Excel table, table3. Each months have its own color.

I would like to fill in the Label in PowerApp.

My problem is I need to color the Label with the color that match to my indication, which I've indicated in Excel.

The name of color is in Title5. And When I indicade the blank label with 

Label5

It'll show "Purple". 

But when I combine it with 

Color.Lebel5  

or

Color.Lebel5.Text

Not thung happen, but error.

Could you guys guide me how todeal with this?

Thanks

[SimonPiquer · Accepted solution]

Hi!

You could either set the color value to either:

ColorValue(ThisItem.Color)

or

ColorValue(Label5.Text)

Please give that a shot!

[Premwong13]

Thank you so much,Simon!

ColorValue(Label5.Text)

It works! 

---

@SimonPiquer wrote:

Hi!

You could either set the color value to either:

ColorValue(ThisItem.Color)

or

ColorValue(Label5.Text)

Please give that a shot!

[Premwong13]

Another Problem, like Light Blue. 

When it's in a code, it's invalid due to a space bar.

How could I solve that? 

[SimonPiquer · Accepted solution]

Try this instead in that case:

ColorValue(Concat(Filter(Split(Label5.Text,""),IsMatch(Result, "^[a-zA-Z]")),Result))

It should make sure no special characters are taken from the label, only A-Z.

[Premwong13]

Thank you so much! 

[ktaber317]

Neither of these worked for me. Do you have any other suggestions?

I turned around and answered my own question. You have to use the Hex Color and not the RGBA