Sorting in InfoPath

Question

I have an InfoPath form with a drop-down-list, where the datasource is based on a sharepoint list. The listentries however seem to be random.

Is there any way to sort the data?

Answer 1

This should help: http://www.joellipman.com/articles/microsoft/sharepoint/519-sort-order-a-dropdown-list-in-ms-infopath-without-programming.html

Answer 2

What version of InfoPath are you using. Check out this post on how to create a xml datasource connection to the SharePoint list. This is for InfoPath 2007. http://blogs.msdn.com/b/infopath/archive/2007/01/15/populating-form-data-from-sharepoint-list-views.aspx Sometimes this method could be blocked by IT.

Answer 3

I think list items sort by word order. By the way, a few days ago, I had the same problem and I solved like this:

1. Right click the dropdown
2. Select the "Dropdown Properties"
3. Below "Dropdown Options" you will see the data source. Click to "Add" button. It will open another window. Select "New Connection" and then "Get Data" and click next.
4. Then select "SharePoint Library or List"
5. On the next window, select your source list and click next.
6. Then you will see all columns of your source list. You can sort your source list by any column. If you want a custom order, you can add a new column to your source list and sort this list by this column.

Hope this helps.

Erben.