Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Note
Community interest groups have now moved from Yammer to Microsoft Viva Engage. To join a Viva Engage community and take part in the latest discussions, fill out the Request access to Finance and Operations Viva Engage Community form and choose the community you want to join.
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.