cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Salamander94
Level: Powered On

Make the Browse Screen Change Colors Depending on field

So I am creating an inventory app.  I want the browse screen to display items in a seperate color (or atleast the text) based on how much of that item is left. 

Basically if there's only 1 monitor left in our inventory I want that section to be highleted in red so I know to order more.  I also don't need it to do this for every item.  Just specific ones.  Is this possible?   I keep trying things like:

If(Quantity <= 3, RGBA(100,0,0,0), RGBA(0,0,0,0))

Obviously with different "RGBA", but you get the gist.  Is this even possible?  If not any cool suggestions?

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Make the Browse Screen Change Colors Depending on field

@Salamander94 

Ah ha...now we see the issue.  PowerApps sees your Quantity column as a text column.

So, change your TemplateFill to the following:

If(Value(ThisItem.Quantity) <= 1, DeepPink, 
   Value(ThisItem.Quantity) <= 3, LightSalmon, 
   Value(ThisItem.Quantity) <= 10, LightSkyBlue, 
   LightGreen
)

And now you should see some colors!

 

Since you pulled this from Excel, you might want to double back on the Excel file and look at the formatting for the Quantity column.  Something is confusing PowerApps to think it is a text column.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.

View solution in original post

13 REPLIES 13
Super User
Super User

Re: Make the Browse Screen Change Colors Depending on field

@Salamander94 

Yes, this is all quite possible.  

If you are looking at changing the color on text on Labels, look at the Color property on them.  There you can add the formula you had to make the colors changed based on conditions.

Have you tried any of that and run into issues?

Also, you can certainly use the RGBA function to create colors, but you can also use the names of the colors if that becomes easier for you to read.

If(Quantity <= 3, Red, Black)

I hope this is helpful for you.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.
Community Support Team
Community Support Team

Re: Make the Browse Screen Change Colors Depending on field

Hi @Salamander94 ,

How do you list your inventory items within your app? Using a Gallery?

Do you want to render the Gallery Items in different color based on the Quantity column value?

 

Based on the needs that you mentioned, I assume that you use a Gallery within your app to list your Inventory items, is it true?

I have made a test on my side, I think the If function could achieve your needs. I have made a test on my side, please consider take a try with the following workaround:10.JPG

 

11.JPG

Set the TemplateFill property of the Gallery to following:

If(
    ThisItem.Quantity <= 1, RGBA( 255, 20, 147, 1 ), 
    ThisItem.Quantity <= 3, RGBA( 255, 160, 122, 1),
    ThisItem.Quantity <= 10, RGBA( 135, 206, 250, 1),
    ThisItem.Quantity > 10, RGBA( 144, 238, 144, 1 )
)

On your side, you should type the following formula:

If(
    ThisItem.Quantity <= 1, 
RGBA(100, 0, 0, 1), /* <-- The last argument of the RGBA() function here should be 1 rather than 0 */
RGBA(0, 0, 0, 0) )

12.JPG

Note: If you want to display a color using RGBA() function, the last argument should be 1 rather than 0, otherwise, the corresponding color would not be displayed. The last argument of RGBA() function represents the Alpha value, 1 represents the fully opaque, 0 represents the fully transparent.

More details about the RGBA() function, please check the following article:

RGBA() function

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Salamander94
Level: Powered On

Re: Make the Browse Screen Change Colors Depending on field

I tried this and it didn't work unfortunetely.  Although I'm sure I'm doing something wrong.  I selected the browse gallerey and enterened in this for the template fill:

If(ThisItem.Quantity <= 1, RGBA(255, 20, 147,1), ThisItem.Quantity <= 3, RGBA(255, 160, 122, 1), ThisItem.Quantity <= 10, RGBA(135,206,250,1), ThisItem.Quantity > 10, RGBA(144,238,144,1))

That didn't change anything.  I wasn't so sure where to put the second line of code you provided so I selected the browse screen and for the "fill" area I started to try and enter

If(ThisItem.Quantity

, but it would't recognize the field.  I'm assuming I'm entering it into the wrong place?  Also, I do have a search bar and what not so my "item" code area looks like this:

SortByColumns(Search(items1, TextSearchBox1_1.Text,"Item","Location","Make","Title"), "Title", If(SortDescending1, Descending, Ascending))

Thanks for all your help!

Super User
Super User

Re: Make the Browse Screen Change Colors Depending on field

@Salamander94 

 

Adjusting the TemplateFill on the Gallery will alter the background color of an individual row based on your formula.  Changing the Fill property of the Gallery will alter the background color of the entire Gallery.

 

So, in your case, if you're trying to change the background color of the row based on the value, then you will want to change the TemplateFill property on the Gallery.

Using your existing formula (with the color names used rather than the RGBA values - for clarity) and a slight change to the final "else" part of the formula, try this in your Gallery's TemplateFill property.

If(ThisItem.Quantity <= 1, DeepPink, 
   ThisItem.Quantity <= 3, LightSalmon, 
   ThisItem.Quantity <= 10, LightSkyBlue, 
   LightGreen
)

If that does not provide any results, then we should look at your Quantity and make sure you are actually getting a number there you expect.  With the above formula you *should* see colors...at least DeepPink or LightGreen.

 

 

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.
Salamander94
Level: Powered On

Re: Make the Browse Screen Change Colors Depending on field

Well hello again Randy!  You've helped me before and I wanted to take a minute to say thanks in case I didn't last time.  At any rate this did not work for me.  It didn't change any colors.  I did use it in the gallery's template fill section.  Just in case you need to know the data is coming from an excel document on one drive.  Let me know what other information you need.


 

Super User
Super User

Re: Make the Browse Screen Change Colors Depending on field

@Salamander94 

No problem...happy to help.

So this seems a little unusual.  Let's take a couple of steps to troubleshoot:

1) Change your TemplateFill property to : LightGreen - you should see all the items in LightGreen background.  Do you?

2) Do you have a label in your Gallery for the Quantity?  If so, what does it show on a couple - are they valid numbers?  If you don't have a quantity label, put a label in your Gallery and set the Text property to ThisItem.Quantity - does it show a proper number?

 

Let's start with that and see what you get.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.
Salamander94
Level: Powered On

Re: Make the Browse Screen Change Colors Depending on field

Yes, using just "light green" works.  Yes I do have a label for the quantity.  It is set as "ThisItem.Quantity"

Super User
Super User

Re: Make the Browse Screen Change Colors Depending on field

@Salamander94 

Okay...that is good.  We're making progress.

Now, look at one of your list items and its Quantity value (let's say it says 3).

Change your TemplateFill property to the following:

If(ThisItem.Quantity=3, LightGreen)

That one row with the 3 in it (or whatever quantity you picked) should be LightGreen...is it?

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.
Salamander94
Level: Powered On

Re: Make the Browse Screen Change Colors Depending on field

This did work, but I had to use quotation marks around the 3. 

If(ThisItem.Quantity = "3", LightGreen)

It didn't work without them.  I also tried using "<=" instead of "=" but that didn't work.

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 218 members 5,200 guests
Please welcome our newest community members: