Edit

Share via

Choose function (Access custom web app)

  • Article

Returns the item at the specified index from a list of values.

Important

Microsoft no longer recommends creating and using Access web apps in SharePoint. As an alternative, consider using Microsoft PowerApps to build no-code business solutions for the web and mobile devices.

Syntax

Choose (IndexNumber, Value, [Value_n])

The Choose function contains the following arguments.

Argument name Description
IndexNumber
An integer expression that represents a 1-based index into the list of the items following it.
Value
List of values of any data type.

Remarks

If the provided IndexNumber is not an integer, then the value is implicitly converted to an integer.

If the index value exceeds the bounds of the array of values, Choose returns NULL.