.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

InfoPath: Copying values from a multiple-selection lookup (secondary data connection) to a multiple-

Posted By:      Posted Date: October 24, 2010    Points: 0   Category :SharePoint
Trying to use "Set Field Value" action in InfoPath to set values in a multiple selection lookup field. Does not not seem to be possible. Has anyone achieved this?

View Complete Post

More Related Resource Links

How do you create a custom BDC data field that allows for multiple selected values?

I need help creating a custom data field using the BDC column as a base.  We need to allow for multiple selected values instead of just a single one.  I can't find anything on the net which shows how to do this.

SQLCE 3.5 connection from multiple application, data refresh

I have a native application (wm 6.5) using oledb to connect to a database. *******************************************************************************   result=CoCreateInstance(CLSID_SQLSERVERCE_3_5,0,CLSCTX_INPROC_SERVER,IID_IDBInitialize, (void**)&database);   ... // set properties  database->Initialize(); ******************************************************************************* This part of the app simply queries a single table for all records (query wrapped in a transaction of it own). I believe it is recommended that you keep a single connection for as long as possible, and therefore just create a new session each time I query the table. There is a second application (c#) which my application executes and then waits for. It updates and inserts new records. when the c# app closes and I get control back, my app then runs another query to see if anything has changed. My issue is that, the only way I can get the updated data is to un-initialize and re-initialize the database (IDBInitialize) interface created above.  Is there some properties I should be setting on the session/database in order for this to work. Or do I really have to spawn a new connection for every query?   Thanks in advance. Dylan

InfoPath 2010, Multiple Repeating Sections have same name, Diff data connections using same SQL Serv

I've created an InfoPath 2010 form that has three Repeating sections and each one uses a different data connection but all three connections use the same table in SQL Server... "Accounts".  Now you might ask why I would do this? Well I need different sets of data in each section and it all resides in the same table in the repository. Also, sometimes one section will not have information and I do not want a bunch of blank fields displaying in the repeating section. So I split the data into separate sections. Now here is the challenge for you guru's out there. :) I want to use one column in the 3rd repeating section  to refer back to another column in the first repeating section.(for referential integrity) Unfortunately since they both use the same table in the database they possess the same name under advanced view:  myFields/dataFields "d_:Accounts". In fact all three of my repeating sections have the same name based upon the database table used in the data connection. In the SQL statement I attempted to rename each of the connections via the statement. I have not tried to give the table an alias in the statement yet. Will try that one next. 1. Is there a simple way to rename the repeating Section from "d_:Accounts" to something else so that  they are each unique? (Without using backend code as I've only used InfoPath/SP/S

Infopath 2007 Repeating Table - Multiple Value Column Text - Hiding Rows based on Column text values

Infopath 2007 browser based form Full Trust Example: I have a repeating table (FruitChoice) that has multiple columns. Both drop down list point to sharepoint list data sources. Choose your tree ft. drop down list – 6Ft Choose your Department drop down list - 103 This repeating table is conditional on the drop down values. This works great. Trees     Fruit       Cost   Date Ordered    Date Delivery Department 6Ft        Peaches                                                        103 3Ft        Apples                                                          102 3Ft        Peaches         &

Infopath form updating from secondary data connection initally, then not!


Let me set up what I am doing...

I have a table with multiple text boxes. Each of these text boxes pulls a total for it's corresponding item from a SharePoint List. Each item has 3 boxes that return three different totals.(Filters correctly into This week, This month, and Year to date).

When I open the InfoPath form initially all the columns return the correct totals. Now If I edit the date created on an item; so that it was created last month. Nothing changes on my infopath form. The created this month total remains the same.

I have my data connection set to update everytime a form is opened.

What am i missing?


fx Controls instead of Drop Down Lists for Lookup fields in InfoPath Secondary Data Connections


I have a secondary data connection with a lookup field into another list. To display the fields text value instead of the index, I am using a drop down list which gets its choices from the linked list. This information is read-only so I disabled the control via formatting rule.

A calculated value control might be better suited, but my XPath skills are not very "developed". Has anyone done this before? Taken the index from the bound field and extracted the text value from a second data connection? Thx


Best way to get anonymous InfoPath data into multiple lists/libraries?


I'm trying to figure out the best way to create a solution for the situation I have.  I'm still pretty new to SharePoint, and very new to InfoPath.  I'm working with MOSS 2007 and I've created a browser-enabled InfoPath 2007 form that I need to make available to both anonymous users at the top level of my site, and AD authenticated users from within a secured site collection.  It will be important for me to be able to determine whether the form is being submitted by an anonymous or authenticated user, as it will have some fields that need to be handled differently in each case.  Once the forms are submitted, I need to be able to store them in a forms library in the secured site collection, and also create a list item in the top level site with some of the basic info from the form.  That list will be visible and searchable for the anonymous users.

After searching through this forum, I've found at least 2 possible ways for anonymous users to submit forms to a form library.  Right now I'm leaning towards having it submit to a web service which would handle the task of moving/copying the data to the proper places.  Would that be the best solution in this case, or am I missing something?

The next thing I'm not sure about is what my options are for presenting the form 

How to improve the performance of multiple selection field in Infopath 2010 ?


Hi Infopath experts

I am developing an infopath form that has 4 big multiple selection fields (each field has more than 50 choices). Each time the users select a choice from the muiti-selection field, the form takes a lot of time to response. This only happened with IEs (I am using IE8 now). When I tried it with other browsers (firefox, chrome, safari), the performance increased drastically.

I have seen other people saying that IE has issues with Infopath and IE9 might solve the issues. However, our company won't upgrade to IE9 anytime soon. If anyone has workarounds for this issue, please help me with it

Thank you,



Lookup fileds with allow multiple values option enabled are separated by ;# in export spreadsheet


The lookup fields with allow multiple options enabled displays parent listitem id separated by ";#" when exporting to spreadsheet. I need to remove the #and the parent list item id from the spreadsheet. how to achieve that?

Any suggestions?

Display "allow multiple selection" column data as multiple items


I have a list that contains secretary assignments. There is only 2 columns. The secretary column is person/group lookup column and the attorneys column is also a person/group lookup column but "allow multiple selections". Here is a sample of item:

Secretary: Lisa White

Attorney: Joe Smith; John Fox; Michael Wrox.

I would like to create a view that display as

Attorney            Secretary

Joe Smith          Lisa White

John Fox           Lisa While

Michael Wrox    Lisa While

I know the out of box view will not let me do that . I just wonder if there is a work-around solution. Many thanks.


Filter document library based on multiple lookup values



I have a very unique requirement for MOSS 2007.
Lets say there is a list of projects; A, B, C, etc.
Then there are phases of the project: Design, Develop, QA, etc.
When the documents are uploaded to a document library, a project and phase is selected at the time of check-in.
I want to create a project page to show project documents by showing documents for each phase in a different web part: eg. Design web part, Develop web part, etc. all bringing documents from the document library.
So far, all good. This can be created by using web parts, views and filters, etc.
Now, I want to create a custom list with Username, Project, Phase. like this:
User1, Project A, Design
User1, Project A, Develop
User1, Project A, QA
User1, Project B, QA

Now, if User1 goes to this project page for Project A - the user sees documents in all 3 phases.
if user1 goes to Project B - the user sees only QA documents.
I will be ok with just showing and hiding web parts completely.
or showing the web parts, but filtering out the documents. either is fine.

I have tried a combination of filters, CAML, etc. but getting values from a custom list to apply the filter is where I am stumped. I want the custom list as it will be easier for the end user to manage permissions for each user for each project for each phas

How can I get a list of selected items from a multiple-selection box in Infopath 2007

I have an Infopath 2007 form with a multiple-selection box.  The form has a receive data connection to a Sharepoint custom list which shows software available to staff.  The form allows the user to select any number of items from the list of software.  I want to be able to show a summary list and more importantly print a summary of just the items from the list that were selected.  I want to be able to hand my IT person a list of the software that user needs installed.   I am trying to figure out how to get this summary list so it can be printed out.  Any help would be appreciated.
Renee Boyd

Query data from multiple calander in InfoPath button click


Hi, I am building event booking system on InfoPath 2010 , I need to show available rooms for given start and end date time.

All calendars library are under same site.

I don’t want to use code behind. I have calendar lib for each room defined.









ASP.NET Multiple Selection DropDownList with AJAX HoverMenuExtender

Recently, I was looking for a multiple selection dropdownlist control for my new project. After spending some time researching for it, I decided to put together all my finding in one web user control. This web user control consists of an ASP.NET AJAX HoverMenuExtender, JavaScript, StyleSheet and CheckBoxListExCtrl . The final product will work with or without a MasterPage and you can drag and drop more than one instances of the control on to the page.

jquery autocomplete multiple values


i got some samples and i did autocomplete using jquery , its working well for single input values

but i need to pass multiples values after one by one in the textbox. Is it possible to pass multiple

values in the textbox for autocomplete in jquery in asp.net?


data from multiple row



I have a dataset in my SSRS report where I am getting the data like this. It has 3 rows.

ID Parameter Value

1. Client Name-  XYZ

2. Client Email - xyz@s.com

3. Clinet Phone- 234567

I need to check condition in expression, so If parameter is Client name then It will show in client name textbox of Report. How can write expression for this.

How to store and retrieve multiple values in a single session variable .


I want to store employee name,designation and department in session variable and
retrieve in another page how to do this.

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend