SharePoint Integration

Re: Help with Sharepoint query...

Hilary Stoupa — Wed, 08 Sep 2010 15:27:25 GMT

I misled you, I'm afraid -- I didn't realize that calculated SharePoint columns wouldn't be available in a data connection. Apparently, even if you use an owssvr.dll connection to return XML you will have additional gunk on the string that you won't want.

This may be something that can only be done with qRules or code....

Re: Help with Sharepoint query...

Sailor — Wed, 08 Sep 2010 14:02:17 GMT

Ok well I tried what you suggested by creating a calculated field (ApplicationVersion) in sharepoint which joins the Application_Name and Version into one. It's not pretty, but I guess it would work. Now when I look at the retrieve data connection in Infopath this new column is not available. This list has only one view (All Items) and shows the new column just fine. I can't seem to use this new column in my form. What am I missing?

Re: Help with Sharepoint query...

Hilary Stoupa — Tue, 07 Sep 2010 23:31:04 GMT

No, not in a drop down. Definitely in a text or expression box, but not for drop down entries.

Re: Help with Sharepoint query...

Sailor — Tue, 07 Sep 2010 23:24:31 GMT

Hi,

Yes, I didn't really want to do that because it will be very messy (VERY wide drop down for some). Though out of curiousity I decided to try this, but after creating a new calculated column in my Sharepoint list Infopath won't see it. When I go through Data Connection Wizard my field "ApplicationVersion" doesn't appear as an available column.

Would there be a way to do this just in the form itself? Concatenate the ID field and the Application_Name and use that somehow to create a unique name? I'm not sure.

Re: Help with Sharepoint query...

Hilary Stoupa — Tue, 07 Sep 2010 22:27:43 GMT

You will always get the first version if the app names are the same. I think what I'd do is have another column in my list that combines the name and the version into a single field and use that for my drop down.

Re: Help with Sharepoint query...

Sailor — Tue, 07 Sep 2010 16:01:19 GMT

Ok. Now I do need help. I'm sorry I'm keeping my on thread going here...On further exam there is a problem because some of my items in the first column (Application_Name) in sharepoint are duplicates and by using rules the version column is always the same.

Here is what I did so far.

AppName (drop-down) has a rule to set the value of AppVersion = @Version[@Application_Name = AppName]

Like I said, it populates the text field but somehow I need to have the ID field or something in here so it can handle duplicate values of AppName.

My example above is the perfect situation. It will list Program 2010 twice in the dropdown but both choices will put 1.12 in the version field.

Application_Name Version

Program 2010                     1.12
Program 2010                     2.0
Something Else                  1.5

Anyone?

Re: Help with Sharepoint query...

Sailor — Tue, 07 Sep 2010 15:46:09 GMT

Further searching led me to this post which ultimately solved my problem. I wasn't using the right search terms before!!

http://www.infopathdev.com/forums/p/13285/47528.aspx

Help with Sharepoint query...

Sailor — Tue, 07 Sep 2010 13:45:17 GMT

Hello,

I am still very new to this, so I think this is a very basic question but I don't know how to go about it. I have 2 fields on the form that I want populated from a sharepoint list. Application_Name and Version. The Application_Name is a drop-down combo box and the Version is just a text box. I want the the 1st drop down to allow the user to pick the application from a list then have the Version go into the 2nd field.

In the Sharepoint list these are separate columns like so.

Application_Name Version

Program 2010                     1.12
Program 2010                     2.0
Something Else                  1.5

So the two columns need to be joined in the drop-down but shown in separate boxes on the form.