You’re offline. This is a read only version of the page.
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
I think you could add the filter inside the distinct, something like this:
Share
Report
All responses (
Answers (
2,637
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!
