ComplexType fields and Sharepoint column types - InfoPath Dev
in

InfoPath Dev

Use our Google Custom Search for best site search results.

ComplexType fields and Sharepoint column types

Last post 12-11-2009 02:46 AM by chris leate. 10 replies.
Page 1 of 1 (11 items)
Sort Posts: Previous Next
  • 03-18-2007 09:57 AM

    ComplexType fields and Sharepoint column types

    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
  • 03-19-2007 09:55 AM In reply to

    Re: ComplexType fields and Sharepoint column types

  • 03-20-2007 02:35 PM In reply to

    • bejubi
    • Not Ranked
    • Joined on 03-20-2007
    • Posts 2

    Re: ComplexType fields and Sharepoint column types

    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
  • 03-20-2007 03:50 PM In reply to

    Re: ComplexType fields and Sharepoint column types

    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.
  • 03-21-2007 11:56 AM In reply to

    • bejubi
    • Not Ranked
    • Joined on 03-20-2007
    • Posts 2

    Re: ComplexType fields and Sharepoint column types

    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
  • 03-21-2007 11:36 PM In reply to

    Re: ComplexType fields and Sharepoint column types

    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.
  • 03-14-2008 08:11 AM In reply to

    Re: ComplexType fields and Sharepoint column types

    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.

  • 04-22-2008 12:59 PM In reply to

    Re: ComplexType fields and Sharepoint column types

    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 

  • 04-22-2008 01:59 PM In reply to

    Re: ComplexType fields and Sharepoint column types

    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.

  • 04-23-2008 05:45 AM In reply to

    Re: ComplexType fields and Sharepoint column types

    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

  • 12-11-2009 02:46 AM In reply to

    Re: ComplexType fields and Sharepoint column types

    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

Page 1 of 1 (11 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.