Unanswered

Color signalization in Storage App

(0) Share

Report

Posted on by Joao3

Greetings,

Me and a colleague from work are creating a Storage App using PowerApps for our company, we currently have a list with all the products from the storage, and we have a column that calculates when a product reaches the minimum quantity. We want to know if it is possible to have a signalization with colors, so it´s easier to know which product is reaching its minimum quantity. We are thinking of showing a yellow signalization when a product reaches a certain quantity just a bit above the minimum and a red signalization when the product actually reaches it´s minimum quantity. And when the quantity is way above the minimum then it would be a green signalization.
Is it possible to do that, and if so, what is the best way we can do it?

Thanks in advance.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

rubin_boer 4,843 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

hi there @Joao3

sure you can use switch for this (here it is the fill property of the label control.)

Switch(true,
Value(Self.Text) >5 && Value(Self.Text) < 10, Yellow,
Value(Self.Text) <= 5, Red,
White)

if the value is between 5 and 10, 5 being your minimum you will get yellow, and equal or below your minimum it will be red.

Have fun

Was this reply helpful? Yes No
Joao3 45 on at

Like (0)

Report
Copy link

Link copied!

Rubin, how are you?
So, your point was good, but we can't get this visualization inside PowerApps, I will send you a picture, and show you where this part of the colors would be.
So where do I enter this code so that it returns these colors, can you make an example for me to understand better? With the values as you show in your image.

Remember that the products are registered as SharePoint lists.
Any questions we are at your disposal.

Café = Coffe.
Área = Area
Produto necessário para compra = Product required for purchase.
Estoque = Stock.

Was this reply helpful? Yes No
rubin_boer 4,843 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

hi @Joao3 , the label which reflects the stock levels i assume is the Estoque. So if Estoque is for e.g. 9 its yellow and 4 red then the label fill property will have the formula as given.

please give it a try

Was this reply helpful? Yes No
Joao3 45 on at

Like (0)

Report
Copy link

Link copied!

Hello Rubin, how are you?

I am applying this method that you told me, but man I am having difficulties.
I am a "beginner" in power platform, could you please help me in how to do this part?

The piece of code that is being marked by the arrow, is just a Filter by department, I wanted to be able to include it in this code that you

Thank you in advance

Was this reply helpful? Yes No