Answered

Indication gallery from gallery

(0) Share

Report

Posted on by mhuhka

I am developing a form for accounting for used material on construction sites. Now I am faced with the problem of displaying problematic positions. If Label2 is greater than label1, then the bell should light up red, if less, then green, but the bell always lights up red. I tried to write formula:

If(Value(label2.Text) > Value(Label1.Text); Red; Green),

but it always lights up red. Any ideas?

Categories:

Building Power Apps

U12.jpg

I have the same question (0)

All responses (8)

Answers (2)

StalinPonnusamy Super User 2024 Season 1 on at

Like (0)

Report

Hi @mhuhka

Your formula looks good.
From the screenshot, 80 is Label 2 and 50 is Label 1?. If this is true then works well. Can you check the label name for each? and Can you show me where it's not working?

Was this reply helpful? Yes No
mhuhka 38 on at

Like (0)

Report

Hi @StalinPonnusamy
My formula only works for the first entry from the gallery. The screenshot (check attachements) shows the situation with two positions. On one - the rule is fulfilled, on the second - it is not. I am trying to get a red indicator if at least one of the positions for writing is not executed.

U13.jpg

Was this reply helpful? Yes No
StalinPonnusamy Super User 2024 Season 1 on at

Like (0)

Report

Hi @mhuhka

Are you using a gallery or multiple forms on that screen?

If you use multiple forms then you will be having multiple controls. We need to write the same logic for each form.

Was this reply helpful? Yes No
mhuhka 38 on at

Like (0)

Report

Hi @StalinPonnusamy

I am using two galleries based on tables in OneDrive. The gallery2 sorts the material from construction sites in the gallery1.

Was this reply helpful? Yes No
StalinPonnusamy Super User 2024 Season 1 on at

Like (0)

Report

Thanks, @mhuhka for the explanation. You have 2 or more items in gallery 2. The formula is overwriting one another. For example, In this case, 2nd time is overwriting the first one

Label 1 Label 2
Item 1 80 147
Item 2 80 50

To solve this, you can sort the gallery2 to display label1 in descending order.

Was this reply helpful? Yes No
StalinPonnusamy Super User 2024 Season 1 on at

Like (1)

Report

Hi @mhuhka

Please let us know if anything needs on your post. We can help with this.

Please do not forget to give kudos if you find the suggestion helpful or Accept it as a solution if works fine to help other users to find it useful.

Was this reply helpful? Yes No
Verified answer

mhuhka 38 on at

Like (0)

Report

Hi @StalinPonnusamy
You are a great man!

Sorting the Gallery didn't work. I thought about my problem for a long time, but as soon as you wrote, an idea came to my mind. I calculated the necessary formula without referring to the Gallery (Label1, Label2), I did it using a table on Onedrive and Filter function for ThisItem. And it worked! Thank you for trying to help!

Was this reply helpful? Yes No
Verified answer

StalinPonnusamy Super User 2024 Season 1 on at

Like (0)

Report

Hi @mhuhka
That's great. Nice job.

Please close the post so that it helps others.

Was this reply helpful? Yes No