Need Sorting in Dropdown Form Control with Data Table Source

Hey Eric,

I hope all is good in your world!

You can apply a sort when you’re setting up the data source to the Nintex table as per the attached example below.  As I write this reply, there’s a bug which isn’t making all the columns in the table available to sort but this should be addressed in the next day or so.

Cheers,

Chris

Hi ​@Chris_Ben,

Hope you’re doing well. Thanks for the reply.

I tried your solution with selecting the Location in the Sorting setting. The dropdown form control is still sorting the values in the order they were entered and not alphabetically.

The images below are the configuration of the Data Variable for the Table data and the Choice - Single control. Any help is appreciated.

Hey Eric,

That’s really strange because I’ve just replicated your steps including exactly the same table/variable names and data and it’s working for me.  I also tried using the dataLocation | Rows collection as the data source (where we’d then ask you to specify the label and value) and also what you did by selecting dataLocation | Rows | Location and both returned a sorted list.

You definitely saved your update after changing the sorting parameter right?  Sometimes I forget to hit the update variable button because you have to scroll to see it (something I’ve been meaning to raise with the UX team).

If that’s not it, just to humour me, can you try rebuilding this example from scratch too?

Cheers,

Chris

Hey Eric, please see Chris’s question above! ​@bamaeric 

Thanks for the update ​@Chris_Ben.

This is getting more bizarre as I conduct more testing. I created a brand-new Data table and a new workflow with a start form. I configured the form with a new Choice - Single field and a new Table data form data variable. After publishing the workflow, the choices are sorted alphabetically on the new form. I even added new table rows, and it sorts correctly.

I went back to the original form to test. I deleted the Table data form data variable and the Choice - Single form control. I republished the form and closed the designer. I opened the workflow up again and created a new Table data form data variable with unsorted rows and configured a new Choice - Single control to use the data variable. I published the form again and it still displays the Locations unsorted.

Could it have anything to do with the fact that the workflow with the form and Data table were created before the recent bug fixes were implemented?