Solved

InfoPath and SharePoint 2010

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

I have just recently built a new SharePoint 2007 farm on a complete Windows 2008 R2 server platform and part of my standard build procedure is to implement a warm up routine, usually in the form of a script that is scheduled every morning to launch …
I used to be SharePoint evangelist in our company, so my Outlook always full of questions about how to do this, or where I can find that. One day I found such an email with the following question: "how to attach 3-State workflow (one of the workflow…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
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…

776 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