Hi Team,
Any idea on how to remove the blank results when doing a Distinct - Filter combo? My result shows blanks π Here's the formula I used
Distinct(Filter('SPLiust', Product = Dropdown1.Selected.Value, 'Issue Type'= Dropdown1_1.Selected.Value, Title=Gallery1.Selected.Value),'Background or Other Info')
Code to show the results
ThisItem.Value
Thank you!
@Verps - one (non-delegable) method:
Filter(
Distinct(
Filter(
SPLiust,
Product = Dropdown1.Selected.Value,
'Issue Type' = Dropdown1_1.Selected.Value,
Title = Gallery1.Selected.Value
),
'Background or Other Info'
),
Value <> Blank()
)
MS.Ragavendar
32
Michael E. Gernaey
19
Super User 2025 Season 1
WarrenBelz
18
Most Valuable Professional