Fernitudela.dev

In this post and video, we are going to see how to get an enum value label from a table field to bind it to the model in the model mapping.

Requirement:

We need to export the label enum value of the field DocumentState from PurchTable table.

How to:

First of all, once we are in the model mapping, we need to create a data source of type Enumeration under the Dynamics 365 for Operations (don’t get confused by the one under the Data Model node):

Let’s call it the same name as the base enum “VersioningDocumentState”. A new object with all the different enum values will be created:

ListOfFields

This added base enum will be useful for us, because we can use the function LISTOFFIELDS to create a calculated field based in it. The calculated field will be a record list with the different elements as rows, and we create it as follows:

We go to edit formula and we type the next expression LISTOFFIELDS(VersioningDocumentState). The result:

The function LISTOFFIELDS also accepts as a second parameter the language, make sure you send the report language in case you are having any issues with translations.

But as we see there, we don’t have any field for the enum element value itself, for which we could filter using the table field value… so we need to create it.

GetEnumValueByName

We’ll need to create a nested CalculatedField under the $DocumentStateList, as follows:

We set the formula to GETENUMVALUEBYNAME(VersioningDocumentState,@.Name)

Bind it to the model string node

Now that we have a list with the different enum elements, including the value, we can bind it to the model string node using the where function to filter the value in the table.

Click on the node to bind with in the Data Model part, Edit:

And the formula will look like:

FIRSTORNULL(WHERE(‘$DocumentStateList’, ‘$DocumentStateList’.’$EnumValue’ = @.DocumentState)).Label

where the WHERE function is filtering the $DocumentStateList using the $EnumValue calculated field by the actual table field value. Afterwards, we need to use the FIRSTORNULL function before accessing the Label property, since the Where returns a list and we couldn’t access the properties directly of a list, so, as we know we are filtering by a non duplicates field, we can use the FIRSTORNULL function to get the record filtered without fear, and so access the LABEL that is going to be bound.

In conclusion

Something very common and simple like binding Enum fields is a little more complex than what we might think initially, this is the way I found to deal with them and once you know it, it’s pretty straightforward. If you know better solutions for it, please let me know!