• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 708
  • Last Modified:

InfoPath and SharePoint 2010

Hi All,

I have done the following:

1. I have MS SQL database server
2. I have a table with name "QA"
3. I created an external content type with name "ECT_QA" against table "QA"
4. I created a custom list with name "QA List"
5. I created form using InfoPath 2010.

What I'd like to do is add "Person/Group Picker" to the form in InfoPath but I'm getting the following error message:

Error Message
Is it not possible to add Person/Group Picker to an External Content Type in InfoPath 2010?

Thanks in advance for your help!
0
amarelv
Asked:
amarelv
  • 2
  • 2
1 Solution
 
Clay FoxDirector of Business IntegrationCommented:
Are you using BCS to have the table as a list in SP or is this a supplementary list of data?

The people picker is a bit particular. If you create the column in SP as a person type and then create a connection to it in IP I know it works. The issue is that IP wants to be able to store the data correctly, so the control can only be bound to certain fields.
0
 
amarelvAuthor Commented:
I'm using BCS connection to have table as a list in SP.  Can you please provide me any ideas how I can add new column (People/Group picker) in InfoPath via BCS connection?
0
 
Clay FoxDirector of Business IntegrationCommented:
The trick is that the person or group column type is a lookup and is a bit funky.  I am not able to find any guidance on what the compatible SQL column type would be. Guessing there is probably not one.
You may have to just use a string field and create your own person lookup.  You can create a secondary connection to the getuser web service of SP and then have a drop down list to select a user and store it as text type of thing.
0
 
amarelvAuthor Commented:
Thank you so much for your feedback.   Have a great day.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now