We have NWC form where we placed a "Data Lookup" field to bring data about Customers list.
The data connection is coming from simple SharePoint list.
We are mainly displaying the:
- Customer Name in the "Option Label"
- A calculated column of all the customer information in the "Option Value"
Now, The customer Name lookup is looking to be all over the place (not sorted). it seems to be sorted by SharePoint ID.
We are going to continue to add to this list so we will never be able to maintain sorting on the SP ID!!
In Nintex forms on O365 or on-premise, we were able to specify the "view" that we're pulling the information from. So I could really sort it however I want and that's what will show on my control... But there is no such option in Nintex Workflow Cloud forms...
So.... how can I sort the retrieved data from the SP connection in ascending order in NWC forms?!
help!