web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Gallery filter with Di...

Power Apps

Unanswered

Gallery filter with Distinct

(0) Share

Report

Report

Posted on by phillyd023

I know how to do filters in a gallery fairly well.

a coworker of mine did a distinct formula for me that listed all of the dates from a sharepoint list and removed the duplicates

SortByColumns(Distinct('Rack Audits',Date),"Value",SortOrder.Descending)

How do i change this formula to add a filter from a dropdown menu named dropdown1_2 because i only want to see the distinct dates from the dropdown menu that is selected.

thanks

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

madlad 2,637 Moderator on at

Like (0)

Report
Copy link

Link copied!
I think you could add the filter inside the distinct, something like this:

SortByColumns( Distinct( Filter( 'Rack Audits', dropdown1_2.Selected.*FieldIfNeeded* = *AppropriateField* ), Date ), "Value", SortOrder.Descending )

Just make sure to swap in the appropriate column to filter by, and the appropriate field of the dropdown's data if it's needed.

Hope this helps!

Was this reply helpful? Yes No

Join the conversation