web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details
Power Apps - Building Power Apps
Answered

Distinct Filter and Sort on Gallery

Like (0) ShareShare
ReportReport
Posted on 17 Aug 2017 17:54:40 by 112

Hey all,

 

I am looking to make a Tablet view of the ticket system that I am currently working on at the moment.Capture.PNG

 

As you can see with the image, I have buttons and I have a gallery below the buttons. I have two goals to be accomplished with this.

  1. What I am trying to do is have a gallery or buttons, which ever is easier, to display the status of the tickets. Using the Gallery, do I use:
    distinct(filter(datasource, status))
     

    The buttons are an easy fix since you can just use UpdateCOntext and use a global variable, but they dont look pleasing to the eye vs the gallery. 

  2. The other thing I am trying to get to work is with this selection of the status, in another gallery, I will show the tickets with said selected status. EX I select "in progress tickets", all the in progress tickes will show and vice versa. TicketView is the variable that sets the filter on the gallery.
  3. Filter(Tickets_1,If(TicketView = "Open", show all open tickets, If(TicketView = "In Progress", show all in progress tickets, If(...........))))

Any help would be appriciated. Thank you in advance!

Categories:
I have the same question (0)
  • Verified answer
    Community Power Platform Member Profile Picture
    on 18 Aug 2017 at 13:39:34
    Re: Distinct Filter and Sort on Gallery

    Change Gallery1.Item to

    Distinct(Tickets_1, Status.Value)

    Change the Label to

    ThisItem.Result

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

MS.Ragavendar – Community Spotlight

We are honored to recognize Ragavendar Swaminatha Subramanian as our September…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 982 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 396 Super User 2025 Season 2

#3
Power Apps 1919 Profile Picture

Power Apps 1919 356

Last 30 days Overall leaderboard