An interesting issue I just came up the other day. Using browser based Infopath (drop down) with a data connection to a SharePoint list using Blackpearl 0807. Adding additonal items the list caused my newly added list items are not alphabetized. The way you need to handle this is to create a xml connection using the following example:
1. Navigate to the SharePoint site that contains the list, for example:
http://contoso/sites/sales/Sales%20Contacts/Forms/AllItems.aspx
2. Go to “Modify settings and columns”
3. Copy the List={GUID} portion of the URL and paste this into a buffer like a Notepad window.
4. In Notepad, create the following URL (the blue portion us taken from the step 1 URL, and the red portion must be added.
http://contoso/sites/sales/_vti_bin/owssvr.dll?Cmd=Display&List={GUID}&XMLDATA=TRUE&noredirect=true
I used this handy dandy tool to get my GUID:
GUID Tool:
http://blogs.msdn.com/b/ronalus/archive/2007/09/08/a-little-guid-picker.aspx
For more information use this blog:
http://blogs.msdn.com/b/infopath/archive/2007/01/15/populating-form-data-from-sharepoint-list-views.aspx?PageIndex=6#comments
