
Hi, I'm building an app for a university project, and have almost finished completely, however I am attempting to have a coloured box show up on a specific date if it corresponds to a date on SharePoint list. This much I have figured out, however, I would like to colour this box based on another value within the same SharePoint list.
I have already added a gallery not within the calendar with a formula that works specific to my list, but if I add the same logic to the rectangle within the calendar it does not work.
Here's a screenshot of what I am talking about
And here is the code I have used for changing the colour of the rectangle to purple down the bottom
Switch(ThisItem.Colour, "1", ColorValue("#ff6961"), "2", ColorValue("#8763d4"), "3", ColorValue("#c1cf94"), "4", ColorValue("#9daadf"))
The error states that Colour (From Thisitem.Colour) isn't recognized, this is a row in my SharePoint list and works just fine for the rectangle not within the calendar, but using this code on the rectangle within the calendar days itself does not work
Am I doing something wrong?
Thanks for any help!