InfoPath Dev

I answered my own question.  You can order them by enerting in the sort order in the data connection to SharePoint

I'm ulling the names of list items into a dropdown in infopath.  The data in the dropdown is showing up in the order it was entered into the list.  I need the dropdown to be alphabetical.  How do i order the dropdown? Thanks,

Patrick  thanks for the responce.  From what I have been able to tell this is a regular problem for people trying create dynamic links to SharePoint documents.  For the moment I have asked the users not to use spaces in thier file names while I work out a fix.  As you have stated doing this in InfoPath with Translate and Concat ...

How can I convert a string such as "https://portal.com/test text.doc" to "https://portal.com/test%20text.doc".   I am pulling in SharePoint list field that has a URL in it.  I am then placing that information a HyperLink control on the form.  When I test the link in the client (InfoPath) the ...

I am trying to filter a SharePoint Library using a drop down in an InfoPath form.  I have a SharePoint document library with clients documents in it. I have added a metadata field called "Client Name".  I created an InfoPath form with a drop down that I have populated with the same Client ...

I'm using InfoPath 1020 and a browser based form. In SQL i have a table of Sales Opportunities details. I have created a form based on the Database Template using that table as the main data source. When I query the data by Opportunity Name, it returns multiple records as there are several opportunities with the same name. ...

When you creat a new form you have to select Database.  This will allow you to connect to the database and query the tables.  When creating a new form select File --> New --> Advanced Form Templates --> Database.  If you are speaking about adding a secondary data once you have created a form and then querying it, ...

 Are you having issues connecting to a database in InfoPath or connecting to multiple databases?

Could someone please direct me to a complete list of the keys available when using the GetMyInfo method? I'm trying to figure out the key for Department and Manager are.  And yes I did try department and manager.  :)

Anson, thank you very much. I didn't know you could expand the expression that way.  This is a big help.