cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mhuhka
Frequent Visitor

Indication gallery from gallery

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?

2 ACCEPTED SOLUTIONS

Accepted Solutions
mhuhka
Frequent Visitor

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!

View solution in original post

StalinPonnusamy
Community Champion
Community Champion

Hi @mhuhka 

That's great. Nice job.

 

Please close the post so that it helps others.

View solution in original post

8 REPLIES 8
StalinPonnusamy
Community Champion
Community Champion

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?

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.

StalinPonnusamy
Community Champion
Community Champion

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.

Hi @StalinPonnusamy 

 

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

StalinPonnusamy
Community Champion
Community Champion

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 1Label 2
Item 180147
Item 28050

 

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

StalinPonnusamy
Community Champion
Community Champion

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.

mhuhka
Frequent Visitor

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!

View solution in original post

StalinPonnusamy
Community Champion
Community Champion

Hi @mhuhka 

That's great. Nice job.

 

Please close the post so that it helps others.

View solution in original post

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

secondImage

Power Apps Community Call

Please join us on Wednesday, October 20th, at 8a PDT. Come and learn from our amazing speakers!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Top Kudoed Authors
Users online (2,005)