Substituting a property value for display in a Datagrid component

In cases where you might want to request records using a certain property but display the information using a different property value, you can substitute the display property for the source property in a Datagrid component column.

In the App Builder designer, select the Datagrid component that is used to display the information you want.
On the Content tab, select the Columns section, and then click the name of the column in which you want the information to display.
In the Edit Datagrid Column dialog box, expand the Substitute Value section.
Select the Enable check box.
From the Data Service drop-down list, select the data service to serve as the source of the column display. This data service must contain both the property for the Source and the property for the Display Value.

Note: You can use only data services that do not use input parameters.
From the Source drop-down list, select the property to use as the source for the data.
From the Display Value drop-down list, select the property to use for the display of the specified source data.
Click Save.

The specified column displays the substitute property value instead of the source property value.