I have a SharePoint list with custom form and within a dropdown, the field colour is determined by the selection. This is my formula - If(DataCardValue2.Selected.Value = "Request Complete", Color.LightGreen, DataCardValue2.Selected.Value = "In Progress", Color.Lavender, DataCardValue2.Selected.Value = "In Query", Color.LightCoral, DataCardValue2.Selected.Value = "HR/Payroll to Test", Color.Gold, DataCardValue2.Selected.Value = "Testing Issues", Color.Pink, DataCardValue2.Selected.Value = "Testing Complete", Color.MediumPurple, DataCardValue2.Selected.Value = "Cancelled", Color.Red, DataCardValue2.Selected.Value = "SAP Team to Action", Color.Plum, DataCardValue2.Selected.Value = "MSS Access Required (SAP Team use only)", Color.YellowGreen)
This works well, except for on the initial creation of a new item. The user will click on the 'Request Status' dropdown and the options in blue text can be chosen, but they are difficult to read against the form background (see images 1 and 2 on attachment). However, when a status is already selected then the user changes to a different status, the options are easier to read (see images 3 and 4). Can someone help with this, is there a solution? Ideally I'd have a default value already populated on creating a new item, but this didn't seem to work.
