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
Solved! Go to Solution.
Hi!
You could either set the color value to either:
ColorValue(ThisItem.Color)
or
ColorValue(Label5.Text)
Please give that a shot!
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.
Hi!
You could either set the color value to either:
ColorValue(ThisItem.Color)
or
ColorValue(Label5.Text)
Please give that a shot!
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!
Another Problem, like Light Blue.
When it's in a code, it's invalid due to a space bar.
How could I solve that?
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.
Thank you so much!
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