Enabling Colors from Site

[audrieg]

So I bet we've all had that day where a customer will change color palettes a few times, and have us playing with shades of grey for an hour....argh! Well, I have this idea that I would like to use with all my Power Apps where I save the color in the SharePoint site in a list that the end user can change on demand! (Doesn't that sound enabling!? (smiles)

Here is the list I made (plus I made a connection to "ConfigColor" list in the Power App):

Note: dispite the display you see below for the second column - the internal name is just "RGB"

Then I created a Square Shape in my app, and in the Fill property I added this expression which is returning BLACK for some reason). LookUp(ConfigColor, "Tan" in "Title").RGB)

If I type the string in manually into the Fill property it's correctly color - but not via the filter. Can anyone help, is my idea a dud?

Thank you!

[hngdev]

Yes, you can implement that by using ColorValue and Hex value, like this:

 

And the source

Hope this helps. 

Link to ColorValue: https://powerapps.microsoft.com/en-us/tutorials/function-colors/

Also, you can also do that with RGBA: same link as above.

[audrieg]

Thank you for your suggestions. However, you're using Excel but I am not permitted to use excel due to concurrent user limitations (we have hundreds of users who will hit these forms concurrently which Excel does not support). Can the same thing be done using SharePoint list as I described?

[hngdev]

Hi,

I believe that the same goes to SharePoint List, just import the list and you're good to go. Also, You don't have to change anything but the datasource and the table names.

[audrieg]

I really appreciate your help, here's what I did with result in screen shot (remember I am filling a 'shape' with color, just in case that matters - your screen shot looks like buttons)

1. I changed the Hex column values to include the # before the Hex value.

2. I copied your expression (only replacing the column headers with the ones I have in my list), but it's still coming up black. Error saids: This function can only be used in Action rules. (Is the fill property the wrong property for this?)

[hngdev · Accepted solution]

oh, I thought you need something to trigger the color change.

In your case, you can do ColorValue(LookUp(ConfigColor, Title = "Tan").Hex)

[audrieg]

Bingo! Thanks so much for sharing ColorValue() with me and adjusting to the SharePoint requirement! You rock!