Edit

GUIDVALUE ER function

  • Article

The GUIDVALUE function converts the specified input of the String type to a data item of the GUID type.

Syntax

GUIDVALUE (input)

Arguments

input: String

The valid path of a data source of the String type.

Return values

GUID

The resulting globally unique identifier (GUID) value.

Usage notes

To do a conversion in the opposite direction (that is, to convert specified input of the GUID data type to a data item of the String data type), you can use the TEXT function.

Example

You define the following data sources in your model mapping:

  • A myID data source of the Calculated field type that contains the expression GUIDVALUE ("AF5CCDAC-F728-4609-8C8B- A4B30B0C0AA0")
  • A Users data source of the Table records type that refers to the UserInfo table

You can then use an expression such as FILTER (Users, Users.objectId = myID) to filter the UserInfo table by the objectId field of the GUID data type.

Additional resources

Text functions