The Lookup widget represents Dataverse “Lookup” columns.
| Property | Description |
| Configuration | Defines the FetchXML query that populates the values in the lookup. |
| Default Value | Pre-populates the Lookup field with a default value. Empty Does not set a default value. First Item Sets the default to the first value of the query result. Current Contact Sets the default to the current portal user (this assumed that the portal user is logged in – otherwise the value is set to null). This option is only available when the table selected in the form configuration is “Contact”. |
Configuring the Query
1) Opens the FetchXML editor.
2) Indicates the primary search column – used for type-ahead search (only one column can be selected).
3) Indicates if the field is visible in the lookup (at least one column will always be visible).
4) Indicates the direction and priority of the FetchXML result set.
5) Opens the custom formatting options (currently only available for Text and Date/Time fields).
6) Function to remove the field. (this will remove it from the FetchXML).
7) Function to drag & drop the order or the fields.
Examples
Sample FetchXML code:
<fetch>
<entity name="account">
<attribute name="name" />
<attribute name="telephone1" />
<filter>
<condition attribute="statecode" operator="eq" value="0" />
</filter>
<order attribute="name" />
</entity>
</fetch>