cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Re: Distinct Filter and Sort on Gallery

What is the type of Status column in your datasource?

 

Is it a lookup field?

If yes try to do this

ThisItem.Result.Value
Daemagor
Level: Powered On

Re: Distinct Filter and Sort on Gallery

Crap, yeah that would do it. Although its not showing all the status' that are in the Datasource. I have atleast 5 Open TIckets and you only see Completed Capture.PNG

Anonymous
Not applicable

Re: Distinct Filter and Sort on Gallery

Change Gallery1.Item to

Distinct(Tickets_1, Status.Value)

Change the Label to

ThisItem.Result

View solution in original post

Daemagor
Level: Powered On

Re: Distinct Filter and Sort on Gallery

Thank you so much! I have one last question. If I want to show All Tickets, how would I do that? Since it only shows the values in the datasource. Should I just make shift one using rectangles and a button overlaying it?

Anonymous
Not applicable

Re: Distinct Filter and Sort on Gallery

Hi @Daemagor

 

I don't think you can have it in the Gallery to list All Tickets. Maybe have a button next to it which says Show All Tickets

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 396 members 6,795 guests
Please welcome our newest community members: