Power Platform Community Forum Thread Details

Pie Charts have an ItemcColorSet which lets you specify a list of colors for each additional slice. Other items do not.

For instance, I have a Gallery with many rectangles that I want to color based on other content. I have a solution, but I am interested in a more elegant solution. Below is the formula I am currently using, but my criteria is much more complicated, so things are not as pretty.

RGBA(
LookUp(colorcode, ThisItem.data = criteria, Num),
LookUp(colorcode, ThisItem.data = criteria, Num),
LookUp(colorcode, ThisItem.data = criteria, Num),
LookUp(colorcode, ThisItem.data = criteria, Num))

Each LookUp corresponds to a different color. The first one is the Number for Red, the next is Green, and so on. All of the information is in a table colorcode.

Is there a way to pull up all four of those numbers in one lookup instead of four? Finding other solutions to this would help with creating universal styles more easily.

Categories:

Building Power Apps

I've been using the Table() function more often lately. It has been very useful for creating controls that understand arguments for navigation. For instance, a Dropdown menu could use the following formula in its Items property:

Table(
{Num: 1, Screen: Login},
{Num: 2, Screen: Home})

Note that there are not quotation marks around Login and Home. That is because the Table function can understand those objects instead of text.

Then you could set Dropdown.OnChange to:

Navigate(ThisItem.Screen,Fade)

It works like a charm for navigation.

I think the same mechanism could be very useful for setting up color charts. Allowing the Table function to handle colors would be an easy way to make color lookup more efficient. For instance:

Table(
{Num: 1, Colour: RGBA(#,#,#,#)},
{Num: 2, Colour: RGBA(#,#,#,#)},
{Num: 3, Colour: RGBA(#,#,#,#)},
{Num: 4, Colour: RGBA(#,#,#,#)})

Then objects in that gallery could adopt the color using:

ThisItem.Colour

Community site session details

RGBA Color LookUp

Helpful resources

News and Announcements

Quick Links

Season of Sharing Community Challenge Winners!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to the September Top 10 Community Leaders!

Leaderboard > Power Apps

Featured topics

Product updates