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?
Solved! Go to Solution.
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.
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?
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?)
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
The largest Power BI, Power Platform, and Data conference in New Zealand