Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

InfoPath and SharePoint 2010

Posted on 2014-04-15
4
642 Views
Last Modified: 2014-04-15
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
Comment
Question by:amarelv
  • 2
  • 2
4 Comments
 
LVL 28

Expert Comment

by:clayfox
ID: 40002097
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
 

Author Comment

by:amarelv
ID: 40002216
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
 
LVL 28

Accepted Solution

by:
clayfox earned 500 total points
ID: 40002255
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
 

Author Comment

by:amarelv
ID: 40002273
Thank you so much for your feedback.   Have a great day.
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Scenario: Let’s say you have a quote worksheet in Excel that you use to work up sales figures and such for your clients. You utilize SharePoint to manage and keep track of these documents. You would like values from your worksheet to populate Sh…
For SharePoint sites, particularly public-facing ones, there are times when adding JavaScript, Meta Tags, CSS Styles or other content to the page <head> section is more practical than modifying master pages.  For instance, you could add the jQuery l…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question