Hi, I would like to change the colour of the words in my browse gallery but I am unable to do so. I have attached a picture of my APP and the formula I am using for the browse gallery is:
Sort(Filter('New Input', FilterTextBox.Text in 'Module (PMD):'.Value & 'Module (SMD Cell 1 Line A):'.Value & 'Module (SMD Cell 1 Line B):'.Value & 'Module (SMD Cell 2 Line A):'.Value & 'Module (SMD Cell 2 Line B):'.Value & 'Module (FMD):'.Value), Status_x0020_of_x0020_Defect_x00.Value, Descending)
I would like to do it such that when the status of defect is "Open 未解决", the colour of the specific gallery is red and while the status of defect is "Closed 已解决", the colour of the specific gallery is green.
I have tried adding the formula
If(Status_x0020_of_x0020_Defect_x00.Value = "Open 未解决", Color.Red, Color.Green)
But I keep encountering errors. Also, I tried to add this formula using a semicolon but the system keeps showing the error of "Expected Operator".
Can anyone help me with this please?
Thank you!
