Solved

InfoPath and SharePoint 2010

Posted on 2014-04-15
4
665 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
[X]
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
  • 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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

Note:  There are two main ways to deploy InfoPath forms:  Server-side and directly through the SharePoint site.  Deploying a server-side InfoPath form means the form is approved by the Administrator, thus allowing greater functionality in the form. …
The vision: A MegaMenu for a SharePoint portal home page The mission: Make it easy to maintain. Allow rich content and sub headers as well as standard links. Factor in frequent changes without involving developers or a lengthy Dev/Test/Prod rel…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…

688 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