cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Different colours in browse gallery

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!

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-yuxima-msft
Community Support
Community Support

Hi @Anonymous,

 

Do you want the Open to show Red and Closed to show Green?

If you want change the text’s color,you can try this:choose the text and its Color: If(ThisItem.Status = "Open",Red,Green)

 

20190215textcolorapptest.jpg

 

Hope this can be helpful.

Best Regards.

Yumia

View solution in original post

2 REPLIES 2
v-yuxima-msft
Community Support
Community Support

Hi @Anonymous,

 

Do you want the Open to show Red and Closed to show Green?

If you want change the text’s color,you can try this:choose the text and its Color: If(ThisItem.Status = "Open",Red,Green)

 

20190215textcolorapptest.jpg

 

Hope this can be helpful.

Best Regards.

Yumia

View solution in original post

Anonymous
Not applicable

Hi, thank you very much! 

 

This works perfectly! 🙂

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Top Solution Authors
Top Kudoed Authors
Users online (75,562)