Problems with migrated 2007/2010 Infopath browser based form

• Wednesday, May 16, 2012 6:27 PM

   

   
  

  0

  Hi Everyone,

  Just completed a migration of SharePoint from 2007 to 2010. Uggraded all the forms to InfoPath 2010.

  All works well except for one area. Let me see if I can explain....

  I have a user control list which is a secondary data connection to my form that contains

  1. Name1 - Holds a persons name
  2. User_Name1 - Holds the UserName() of Name1

  I have a form with the following fields.

  1. Name2 - Holds a person name
  2. User_Name2 - fills in UserName() for active user when form loads
  3. Check box with conditional formatting.

  in the past when the form was opened and User_Name2 = User_Name1 where Name2=Name1 then the check box would be enabled, and user could "sign" the form. In 2007 looked like this:

  User_Name1 = translate(@User_Name2[Name2 = @Name1], "ABCDEFGHIJKLMNOPQRSTUVWXYZ", "abcdefghijklmnopqrstuvwxyz")

  This has all worked fine until I upgraded the form and now my UserName Data Connection shows a folder with three choices DisplayName, AccountId and AccountType. 

  I have tried using the DisplayName in the secondary data connection but it doens't work and to make matters worse I have to translate the usernames to be sure they are the same case.

  User_Name1 = translate(DisplayName[Name2 = Name1], "ABCDEFGHIJKLMNOPQRSTUVWXYZ", "abcdefghijklmnopqrstuvwxyz")

  Any ideas??

  ---

  LMP

  • Reply
  • Quote