You are here

Power Apps get rid of Blank Value in dropdown filters -ClearCollect

The issue.  Using a DISTINCT function in my dropdown brought in the blank value some records had in that column(Field). I didn't need the filter to have the blank value for filtering.

Here's the code to get rid of the blank option in the dropdown list.

In my ClearCollect I set the Var for the dropdown "collectrecords".

 

In the Screen/ OnVisible I have this:

ClearCollect(collectrecords,{Result: "All"});
Collect(collectrecords, Distinct('YourTable','YourColumn'))

 

And on the DropDown/ Items I have this:

Filter(collectrecords, Not(IsBlank(Result)))

End results: