Solved

InfoPath and SharePoint 2010

Posted on 2014-04-15
4
653 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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

If you create your solutions on SharePoint sooner or later you will come upon a request to set  permissions of the item depending on some of the item's meta-data - the author, people assigned as approvers, divisions, categories etc. The most natu…
There is one common problem that all we SharePoint developers share: custom solution deployment. This topic can't be covered fully in this short article, so all I want to do in this one is to review it from a development-to-operations perspectiv…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

749 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