Manage better SharePoint lookup value error during smartform sorting

In a SmartForm view, linked to SharePoint multiple lookup value, trying to add sort on the multiple value column, we can see the following message:

The field 'Contributors' of type 'LookupMulti' cannot be used in the query sort expression.

Reproduction steps:

• A) Create Sharepoint list 'Contributors'

• B) Create a Sharepoint list 'MainList', add column with lookup on 'Contributors'

• C) Create some entries in 'Contributors'.

• D) Create more than 10 entries in the main list

• E) Deploy the corresponding smartObject

• F) Create a view on 'MainList' displaying column 'Contributors (Value)'

• G) Run this list

• H) Try to sort the column 'Contributors (Value)'

Result:

The field 'Contributors' of type 'LookupMulti' cannot be used in the query sort expression.

Expected result:

It would be good if it were implemented in K2 as it is in SharePoint, and the sorting function for fields with multiple lookups is disabled.

Alternatively, one could also catch the error in the code and display a user-friendly message.

We worked on this issue firstly with support case N°705408.