Answered

Enabling Colors from Site

(0) Share

Report

Posted on by audrieFCT

987

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!

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

hngdev 304 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
audrieFCT 987 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
hngdev 304 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
audrieFCT 987 on at

Like (0)

Report
Copy link

Link copied!

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?)

Was this reply helpful? Yes No
Verified answer

hngdev 304 on at

Like (1)

Report
Copy link

Link copied!

oh, I thought you need something to trigger the color change.
In your case, you can do ColorValue(LookUp(ConfigColor, Title = "Tan").Hex)

Was this reply helpful? Yes No
audrieFCT 987 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No