You can configure the sort operation in the read operation properties to retrieve the entities in ascending or descending order. You can provide several sort filters. The Data Integration Service processes the sort filters from in the order you configure in the read operation properties.

For picklist fields, the Data Integration Service sorts the returned rows based on the Option Set label stored for the field on Microsoft Dynamics CRM. For lookup fields, the Data Integration Service sorts the returned rows based on the name of the lookup record.