I am attempting to color code a calendar in a scheduling app according to the person scheduled. The app uses a SharePoint List of students, and a List of schedule entries with a lookup to the student list.
I have a collection of color values paired with numbers with 20 entries.
This is the fill value for the entry. It works fine up until I hit student ID values > 20.
My first thought was to use a variable to loop a decrement by 20 until var<=20, but I can't figure it out with the work around loops in PowerApps.
Is there a way to while loop a variable decrement for the fill? Or is there a better way to assign the colors in the first place?

Report
All responses (
Answers (