Filter gallery based on checkbox value

[Iantaylor2050]

I have a powerapp gallery where i show all my academic records as per below screenshot.

There is a checkbox over the top of the gallery which states "Show Topper Only". Clicking on this should only show me first 3 topper rows from the gallery. However the code is not working properly and shows all records. May i know where i am going wrong?

Items property of Gallery

If(Checkbox3.Value,
        SortByColumns(
            Filter(
                Transaction,
                Email = User().Email
            ),
            "Price",
            SortOrder.Descending
        )
    ,SortByColumns(
    Filter(
       Transaction,
        Email = User().Email
    ),
    "DateTime",
    SortOrder.Descending
))

Topper Label visible property

If(
    First(
        SortByColumns(
            Filter(
                Transaction,
                Item_No= ThisItem.Item_No
            ),
            "Price",
            SortOrder.Descending
        )
    ).Price = Value(Label16_12.Text),
    true,
    false
)

[WarrenBelz]

@Iantaylor2050 ,

So where does the $17.95 come from ? I am getting further unclear here as there are prices both above and below it in the gallery and your Gallery Items is sorting by Price descending, so why are the two bottom records not on top ?

Also, you did not explain how the items less than $17.95 also had labels as your Visible code has the criteria that the price has to equal the value in that label (not less than or equal to as the label suggest).

To try and summarise this, the only possible way you can do what you want is to duplicate the logic in the Visible of those labels using AddColumns in the gallery Items then filtering these Items by the added column. I am currently simply quite unclear on the logic you are using to determine when to show them.

Please have a think about this as to how you would describe their visibility (or not) in a few concise points.

[Iantaylor2050]

Hi @WarrenBelz 

Below is my Transaction List which shows all records.

Now i want to create a similar view in Powerapps where i expect the below output. This view will only filter by current user(i.e. ian@abc.com) and show all the records for current user. Winner label is being shown only for the users who has purchased that item with highest price. 

Now i want to have a checkbox above the powerapp gallery to show only the winner rows. Once the checkbox is checked it should only show rows 2 and 3 as they are the winning rows. Hope the above explanation is clear. Looing forward to hear from you. Thanks.

[WarrenBelz · Accepted solution]

@Iantaylor2050 ,

As you know I have helped you in the past and will do so in the future, and please take this on board as constructive advice to help you get solutions easier, but it would have been really good if this was your first post rather than coming after asking all the questions seeking clarity on what was not evident (to me at least). @FLMike has made similar pleadings on this and other posts. What you are asking is far from straight-forward and really needs a complete understanding of the logic required - I think this may be what you are after

With(
   {
      _Data:
      Filter(
         Transaction,
         Email = User().Email
      ),
      _Top:
      AddColumns(
         GroupBy(
            Sort(
               Transaction,
               Price,
               SortOrder.Decending
            ),
            "Item Name",
            "Data"
         ),
         "Win",
         First(Data).ID
      ),
      _Filter:
      If(
         Checkbox3.Value,
         "Price",
         "DateTime"
      )   
   },
   SortByColumns(
      Filter(
         AddColumns(
            _Data:
            "Top",
            ID in _Top.Win
         ),
         !Checkbox3.Value || Top
      ),
      _Filter,
      SortOrder.Descending
   )
)

You can also change the Visible of your Label to

Top

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications)   Visit my blog Practical Power Apps

[Iantaylor2050]

Noted @WarrenBelz . From now on, I will make sure that my posts are much clearer and easier to understand.