Solved: Create multiple collections and display them in combo-box

Create multiple collections and display them in combo-box

Hello, I would like to create and display several collections. My intention is to display only selected values in the cmb_Object_FORM_screen field as required below:

If in the cmb_Region_FORM_screen field:

1) the selected value is X then display in the cmb_Object_FORM_screen field in the drop-down list only the values: 1, 2, 3, 4

2) the selected value is Y then display in the cmb_Object_FORM_screen field in the drop-down list only the values: 5, 6, 7

3) the selected value is Z then display in the cmb_Object_FORM_screen field in the drop-down list only the values: 8, 9, 10

I have entered the following in the OnStart property of the start page (App):

ClearCollect(
col_X,
["1", "2", "3", "4"]
);
ClearCollect(
col_Y,
["5", "6", "7"]
);
ClearCollect(
col_Z,
["8", "9", "10"]
)

In the cmb_Object_FORM_screen field in the Items property, I refer to the collection by:

If(
locSelectedRegion = "X",
col_X,
locSelectedRegion = "Y",
col_Y,
locSelectedRegion = "Z",
col_Z,
[]
)

After running RunOnStart, I can see that the X and Y collection has been created and I can refer to it correctly in the rest of the app, but my app does not see the Z collection. Are there any limits on the number of collections that can be created? What could be the error?

Quick Links