CSV Upload EnumList ValidIf Error

I have an EnumList in which the allowed options are controlled by a ValidIf constraint, based on selection on another field.

SWITCH([REQUEST TYPE],
	"IPG", LIST("Visa","Mastercard","JCB","CUP"),
	"EMAILPAY", LIST("Visa","Mastercard","JCB","CUP"),
	"Online SIP", LIST("Visa","Mastercard"),
  "MKI", LIST("Visa","Mastercard","JCB","CUP"),
  "EMOTO", LIST("Visa","Mastercard","JCB","CUP"),
	LIST("Visa","Mastercard","Bancnet Debit",
  			"BPI Debit","JCB","CUP","AMEX","AliPay","Ayala Card","Petron Card")
)

When entered manually, it works perfectly fine.
3X_f_a_faedf310ed956fa2377fede4219e0a5e67d33b06.png

However, I have activated the CSV upload option, and entries are entered separated by comma.
3X_d_2_d22457904e4e45410cf037edeb8ad49ab7fe564d.png

However, appsheet rejects this. It only goes through if only one item is entered in the CSV column.
3X_8_1_8151740cd6f1eb1f231a382bd5c8369836ef3f44.png

Any help please.

0 38 1,004
38 REPLIES 38
Top Labels in this Space