Form showing dropdown menu in different order between mobile and desktop

[Joshua_Bad]

I am trying to use a drop-down list in one of my forms. I am using this formula to validate a column of values in table “Constants” to appear in the drop-down list however between the desktop viewer and the mobile view the dropdown items are in a different order:
SELECT(
Constants[Location],
IFS(
[_THISROW].[Profile Type] = “Leader”, [ConstantID] <> 6,
TRUE, [ConstantID] = 6
)
)

I want the mobile version to have the same order as the desktop. Is there a setting I’m missing or is this a known issue? I know I can sort these the text alphabetically and that shows up the same between mobile and desktop but this dropdown without any sorting isn’t consistent between the two.

[Steve]

If you don’t explicitly sort a list, you really can’t assume it will always be sorted in any particular order. Sort your list explicitly.

[WillowMobileSys]

As @Steve mentions, you need to apply an explicit order to your data. You will want to use the ORDERBY() function to apply that order.

The reason each device might have a different order is, as a distributed system, they each get their very own copy of the data. The rows can be loaded and later added in a different order to the table on each device - depending on activity and parallel processing.