Distinct - Filter [Blank Results]

Like (0) Share

Report

Posted on 21 Aug 2023 12:38:33 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

All responses (2)

Answers (1)

Verps 38 on 21 Aug 2023 at 14:58:45

Like (0)

Report

Re: Distinct - Filter [Blank Results]

Thank you!
Verified answer

Ami K 15,665 Super User 2024 Season 1 on 21 Aug 2023 at 13:51:18

Like (2)

Report
Re: Distinct - Filter [Blank Results]

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