@rwittels
I would still recommend a gallery for this to reduce your overhead.
You can set the colors and backgrounds based on the data in the Gallery.
So, your items property on the Gallery would be:
With({_top3: First(SortByColumns('Quiz Scoreboard', "Score", Descending), 3)},
ForAll(Sequence(CountRows(_top3)),
With(_record: Last(FirstN(_top3, Value))},
{Nickname: _record.Nickname,
Score: _record.Score,
Place: Value
}
)
)
)
The Label for the Nickname in your Gallery would be:
Text property : ThisItem.Nickname
Fill: Switch(ThisItem.Place, 1, Gold, 2, Silver, 3, GoldenRod) - GoldenRod is as close as a named color to bronze.
The significance of this is that your items in the Gallery will have the nickname, the score and the Place (1st, 2nd, 3rd - 1,2,3) that you can then use on properties in the gallery to color as you need.
I hope this is helpful for you.
