Dropdown shows extra blank option

[WalterWong]

Hi

My setup for Order Type dropdown list field.

[Order Type] field is Column Type: Enum

Suggested Values: @PARAM[Order Type Vi]   |  Allow other values: No  |  Auto-complete other values: No

@PARAM[Order Type Vi] field is Column Type: Text with 7 values in Google Sheet column. I have made sure all cells and rows after 7th row is blank without any formatting.

Google Sheet Data

Google Sheet Data

AppSheet Dropdown List

AppSheet Dropdown

There is 8th blank option that shows up, then disappears after user click or tap anywhere on the screen.

How to restrict the blank option from showing up?

Thanks,

[Suvrutt_Gurjar]

Please check if the table @PARAM[  has an extra row with key after the row having the value "Internal" in column [Order Type]. If so please delete that key column, if there are no values elsewhere in the row.

[TeeSee1 · Accepted solution]

I am guessing your @PARAM table has more than 7 rows (the table contains other cols which have more than 7 values)

If my assumption is correct then the system is picking up the blank value in your Order Type col.

In order to exclude any blank values try something like

SELECT(@PARAM[Order Type Vi], ISNOTBLANK([Order Type Vi]))

as your suggested values  expression.

[TeeSee1]

Basically the same as what @Suvrutt_Gurjar suggested.

[WalterWong]

Hi

@Suvrutt_Gurjar @TeeSee1 Thanks for your inputs.

@TeeSee1 You are right.

I'm using @Param table to store all dropdown list variables for multiple columns. There are about 30 columns.

Your suggestion works. Thanks for your solution.