Random list for ENUMLIST

[arindam_samant1]

Hello Experts,
In my application I would like to display data randomly in ENUMLIST & those random data will be coming from the spreadsheet. For example, in my spreadsheet, the available data in the column is:

Now, when I will execute my application, ENUMLIST will have data from this list but randomly like:

Next time it will be:

Hope I explained my requirement correctly. How could I validate this for my ENUMLIST?

Please suggest me.
Thanks,
Arindam

[Steve]

arindam.samanta:

I would like to display data randomly

Display where?

[arindam_samant1]

The field in the view. The field type would be ENUMLIST. For example, if you consider below screen:

The field Challenges is ENUMLIST and when user will see the appl

Thanks,
Arindam

[Steve]

If the values that will be populating your EnumList are values from a table’s key column, you can generate a list of (e.g.) 3 random values using this in the EnumList column’s Valid If expression:

TOP(
  ORDERBY(
    table[key-column],
    UNIQUEID()
  ),
  3
)

(with appropriate substitutions for table and key-column).

If the values that will be populating your EnumList are not values from a table’s key column, you’ll need to add another column to the table with the EnumList column that has the expression above as this new column’s App formula. Then, in the EnumList column’s Valid If, use the expression:

[that-new-column][enumlist-value-column]

(with appropriate substitutions for that-new-column and enumlist-value-column).