SharePoint Integration

Re: ComplexType fields and Sharepoint column types

chris leate — Fri, 11 Dec 2009 10:46:45 GMT

Hi Matey peeps,

You need to create a new column of the type person or group in your sharepoint library then populate it using the workflow. Read page 6 and on of this article http://www.silversandsassociates.com/HOW_TO_Populate_a_List_with_the_SharePoint_Users.pdf hope this helps

Chris

Re: ComplexType fields and Sharepoint column types

davehacker — Wed, 23 Apr 2008 12:45:42 GMT

I wound up writing a web part that implemented the ITransformableFilterValues interface. Within the web part code, I was able to use a person\group field as the filter. Then I connected the filter to the other web part that contained the list I wanted to filter. I don't know why it had to be that complicated, but I never found a way to filter using a person\group field from another list other than going to code. I'm fine with it because I like the control code gives us anyway.

I am pretty new to writing web parts, but the following walkthrough was very helpful. I wouldn't be surprised if you didn't want to go this route, but there is the link anyway:

http://msdn2.microsoft.com/en-us/library/ms499375.aspx

Re: ComplexType fields and Sharepoint column types

Clay Fox — Tue, 22 Apr 2008 20:59:21 GMT

Hey Martin. Sorry for the frustration.

I think in this case it is more of a SharePoint issue than InfoPath or an integration issue.

All of these products are made to work together and whenever you mix versions it makes things difficult.

If you need any help with architecture or creative solutions or just another prespective or to vent. Send me an email.

Re: ComplexType fields and Sharepoint column types

martin600 — Tue, 22 Apr 2008 19:59:22 GMT

I have the same problem.... did you find a solution?

I've spent all day transversing out of date examples and blogs simply because SP2007 isnt backward compatible.... i.e with the text strings and [me]

I hate this product so much

Re: ComplexType fields and Sharepoint column types

davehacker — Fri, 14 Mar 2008 15:11:31 GMT

Did anyone find a solution to this? I want to filter a list by [Me] but I get the "Filter value is not a valid text string" error.

Re: ComplexType fields and Sharepoint column types

enginarc — Thu, 22 Mar 2007 06:36:46 GMT

bejubi: I read that article, and same problem here. (SP2007)

However, I found a resource, which might lead to a better understanding of how SP2007 interprets our xml template data, and integrate to the form list.

2/5 and 3/5 would be helpful.

http://blogs.msdn.com/andrew_may/archive/2006/06/29/SharePointBeta2XMLDocumentParsers1.aspx

Thank you Greg, for your response.

Re: ComplexType fields and Sharepoint column types

bejubi — Wed, 21 Mar 2007 18:56:25 GMT

Greg,

Thanks for the quick reply!

Unfortunately, I don't think it's a value issue. I'm storing IDs that are integers in that field. It's the fact that I can't declare a "Person or Group" data type in my InfoPath form to be promoted in the SharePoint library.

It gets promoted as "Single line of text", and SharePoint won't allow the [Me] filter to be applied to that data type... only on the "Person or Group" data type.

Anyone else find a solution of some sort? This seems like a pretty common thing to want to do.

Thanks!

--Mark

Re: ComplexType fields and Sharepoint column types

Greg Collins — Tue, 20 Mar 2007 22:50:41 GMT

I haven't touched SP07 yet... but if it is text, you just need to find out what kinds of values that "single line of text" field contains, and then make the appropriate adjustments to match what it is expecting.

Re: ComplexType fields and Sharepoint column types

bejubi — Tue, 20 Mar 2007 21:35:53 GMT

I've read your article and it helped me get the list of users to populate the dropdown in my InfoPath form.

However, in Sharepoint 2007, because the column we create "Assigned To ID" is of type, "Single line of text" rather than "Person or Group" (a new type for Sharepoint 2007), when I try to apply the filter [Me] to that column, I get the following error: "Filter value is not a valid text string."

Any thoughts for Sharepoint 2007?

Thanks.

--Mark

Re: ComplexType fields and Sharepoint column types

Greg Collins — Mon, 19 Mar 2007 16:55:53 GMT

Have you seen this article? Use the SharePoint '[Me]' Filter with a Promoted Property
http://www.infopathdev.com/blogs/greg/archive/2005/09/08/Use-the-SharePoint-_27005B00_Me_5D002700_-Filter-with-a-Promoted-Property.aspx

ComplexType fields and Sharepoint column types

enginarc — Sun, 18 Mar 2007 16:57:09 GMT

Hi,

I want to define a "Person or Group" type field in an Infopath Form Template which I intend to use to filter the views in Sharepoint using [Me]

ex. Responsible field is me.

Is this possible by using ComplexType fields and defining a namespace?
or else method?

Kind Regards
Engin