ansaurus

Question

InfoPath 2007 drop down populates from MOSS07 list, but doesn't Alphabetize

Answer 1

A:

Looks like View-based sorting is not supported in browser-enabled form templates because it requires manual hand editing of the view XSL file Refer

Options you have are

Hand edit the xsl
Write custom code on the load event and sort it

For more tricks refer to this link

One good example that works like charm is here

Kusek 2009-07-30 07:59:44

I tried editing the XSL but that doesn't appear to be working. I'll try the custom code next but i was really hoping for something more simple. Thanks though

Burbidge87 2009-07-30 17:12:07

Try the final Link that I have added, solution that is proposed in that article works and you do not need any custom code or editing of XSL. I tested it

Kusek 2009-07-30 18:05:12

The problem with that is it is using a SharePoint 2003 list and not SharePoint 2007. When i try it, I keep getting errors stating url not valid.

Burbidge87 2009-07-30 19:56:07

Ok i found an answer and got it to work, although the only way it works is if i save the file to its resources (which then makes the drop down static and not dynamic).

Burbidge87 2009-07-30 20:12:54

SharePoint 07 answer can be found here http://social.msdn.microsoft.com/Forums/en-US/sharepointdevelopment/thread/5527fa34-655d-4990-a45c-283c94484566

Burbidge87 2009-07-30 20:13:50

I used the same URL and is working well in the2007

Kusek 2009-07-31 06:46:17

Ok we figured out the problem. The URL works, however due to some Cluster issue, it only works when I try to open the form directly from the web server and not the Load Balancer. But other than this problem, your solution worked, thank you.

Burbidge87 2009-07-31 16:37:51

Answer 2

+1 A:

Instead of adding the List as a Data Source, add the Data View XML of the list as the data source.

You can locate the Data View XML of the list by using this URL:

<Site URL>/_vti_bin/owssvr.dll?Cmd=Display&List={<GUID of the List>}&XMLDATA=TRUE&SortField=<Internal name of the Field that you want to Sort>&SortDir=Asc

Use this XML file as the data source in your InfoPath form, the dropdowns will be sorted according to the field you have specified.

ashwnacharya 2009-07-31 12:37:22

ansaurus

tags:

views:

answers:

InfoPath 2007 drop down populates from MOSS07 list, but doesn't Alphabetize

related questions