cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mikelpower
Level: Powered On

Add Blank/Null to Dropdown list

Hi,

 

I have a Gallery that I need to filter by the field "Country".

 

Initially I set the Item.Distinct(DG_tb_Main;Country) and it works fine, but now I see that I need to set it blank /null because otherwise it would be filtering all the time by the selected country.

 

I was trying to do something like  Item.[Distinct(DG_tb_Main;Country);"     "] but is not working. (using ; due to my location).

 

Any simple solution to this?

 

Regards and thanks!

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Add Blank/Null to Dropdown list

Hi @mikelpower,

If you want to add a blank item in the dropdown list ,you can set its Items property to a collection.

 

I assume that I have a table named ‘test4with country column .

You can set OnVisible property of the screen to :

ClearCollect(countrywithblank,Distinct(test4,country),{Result:""})

You can set the collection ‘ countrywithblank as the Items property of your dropdown control .

 

Regards,

Eason

Community Support Team _ Eason YU
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
Community Support Team
Community Support Team

Re: Add Blank/Null to Dropdown list

Hi @mikelpower,

If you want to add a blank item in the dropdown list ,you can set its Items property to a collection.

 

I assume that I have a table named ‘test4with country column .

You can set OnVisible property of the screen to :

ClearCollect(countrywithblank,Distinct(test4,country),{Result:""})

You can set the collection ‘ countrywithblank as the Items property of your dropdown control .

 

Regards,

Eason

Community Support Team _ Eason YU
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
mikelpower
Level: Powered On

Re: Add Blank/Null to Dropdown list

Thanks!!