Newbie Questions

Re: Sort Sharepoint Lists Alphabetically

slloyd — Tue, 30 Sep 2014 15:22:32 GMT

Looks like it's working now! Maybe something had to be re-indexed. Thanks so much for the help! Cheers, Shawn

Re: Sort Sharepoint Lists Alphabetically

Hilary Stoupa — Tue, 30 Sep 2014 14:41:55 GMT

Yeah, sorry - I think the stuff you are finding about having to do something special for sorting may be based on older versions of IP where there wasn't an option for sorting. I can take a look at your form if you like - just attach it under the Options tab.

Re: Sort Sharepoint Lists Alphabetically

slloyd — Tue, 30 Sep 2014 00:29:09 GMT

Sorry, I have very little experience with InfoPath. The form connects to a normal list in Sharepoint online. If I set the data connect to sort by first name it works perfectly in Filler. However the Webform defaults to ID. I've read you have to do some xml voodoo with the lists GUID in order for Infopath to sort alphabetically in a web form. The previous link i posted mentioned using owssvr dll to extract the XML. I barely have a grasp on this. Really just trying to follow a recipe here. If there's a better way I'd love to hear about it. Thanks! Shawn

Re: Sort Sharepoint Lists Alphabetically

Hilary Stoupa — Tue, 30 Sep 2014 00:21:13 GMT

Is the data connection directly to the list? Or is it an owssvr dll data connection? I'm confused. :)

In the past, when I create a normal list data connection and set it to sort by a specific column, it works in the browser and the filler.

Re: Sort Sharepoint Lists Alphabetically

slloyd — Tue, 30 Sep 2014 00:11:52 GMT

Thanks for the quick reply! Right, sorry it's a web form. I've already set the Data Connection to sort by the correct column. Works perfectly in InfoPath Filler just not in a browser. Is that what you mean. ? -Shawn

Re: Sort Sharepoint Lists Alphabetically

Hilary Stoupa — Tue, 30 Sep 2014 00:07:28 GMT

You can sort a list data connection in the list connection itself - when you add the data connection to the list you can pick a field to sort by.

So - I'm not sure if you need to use owssvr.dll?

Sort Sharepoint Lists Alphabetically

slloyd — Mon, 29 Sep 2014 23:58:59 GMT

Have been scouring the forums for a way to sort drop down lists who's data source comes from a SharePoint list using the owssvr.dll method described here: http://blogs.msdn.com/b/infopath/archive/2007/01/15/populating-form-data-from-sharepoint-list-views.aspx Seems to fail every time with "Error Cannot complete this action. Please try again. Troubleshoot issues with Microsoft SharePoint Foundation." We are running Sharepoint 2013 in Office 365. Wondering if that could be the issue. Thanks, Shawn