Distinct - Filter [Blank Results]

(0) Share

Report

Posted on by Verps

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

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Ami K 15,679 Super User 2024 Season 1 on at

Like (2)

Report
@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() )

Was this reply helpful? Yes No
Verps 38 on at

Like (0)

Report

Thank you!

Was this reply helpful? Yes No