Promote Repeating table columns in infopath

By -



Promoting all the contents of a repeating table is not possible, but I found a way by using a hidden field which will have all the repeating table values concatenated and we can promote this hidden field to SharePoint.

Follow the below steps to promote the columns of repeating table , For teaching point of view I have used two columns to promote , For your point of view you can implement using the below method.

Step 1:

        Create a repeating table with two columns
  1.          Name
  2.          Number
        Also create two Multi line text box’s to store the all the repeating table values by concatenating with semicolon (;)  
  1.      Sum of Name 
  2.      Sum of Number



Step 2:

Use the below code in fx of the sum of name

eval(eval(RepeatingGp, 'concat(substring(my:Name, 1, (current() = /my:myFields/my:FieldsGp/my:RepeatingGp) * string-length(my:Name)), substring(concat(my:Name, "; "), 1, (not(current() = /my:myFields/my:FieldsGp/my:RepeatingGp)) * string-length(concat(my:Name, "; "))), ";")'), "..")

Note:

Change the xml path of fields to your requirement, they are marked in red


Step 3:

Use the below code in fx of the sum of Number

eval(eval(RepeatingGp, 'concat(substring(my:Number, 1, (current() = /my:myFields/my:FieldsGp/my:RepeatingGp) * string-length(my:Number)), substring(concat(my:Number, "; "), 1, (not(current() = /my:myFields/my:FieldsGp/my:RepeatingGp)) * string-length(concat(my:Number, "; "))), ";")'), "..")



Note:

Change the xml path of fields to your requirement, they are marked in red


Step 4:

Promote the sum of name and sum of number fields, this way the repeating table columns can be promoted


Link to download of this InfoPath I have created.

http://www.sendspace.com/file/qzo4zk

Comments

Post a Comment

Popular posts from this blog

How to copy SharePoint list workflow

By -
Image
We often face a situation where we need to copy a big workflow from list or library to another list or library. This situation can be avoided if we have created the workflow as reusable workflow. So in this article I will explain in simple steps on how to copy a list workflow to another workflow using SharePoint designer. Using this method we can copy workflow across site collections are web applications. For this we have the following List Name Workflow Name List 1 List Workflow 1 List 2 List Workflow 2 (Copied from the worlflow1) Step 1) We have the list 1 with list workflow 1 to be copied to list workflow 2. Step 2) Now create a list workflow 2 , in list 2 with one condition plus once activity and save it. In our example I have used a condition and sending email to current user. This is used to create the Xoml rules for the list workflow 2 Step 3) Now in the side of navigation click All Files St
Read more

INFOPATH FORM HIDE/DISABLE FIELDS BASED ON SHAREPOINT GROUP MEMBERSHIP

By -
Image
Hi guys in this tutorial you will get to know how to identify whether a user is part of a Share point group in InfoPath form. NOTE: This will work only for WINDOWS AUTHENTICATED SP sites In this example we will use the logged in persons user name is in IT SP group. If he is in the IT SP group we will enable Submit Button and If he is not in the IT SP group we will enable Submit to IT button. STEP 1: Go to the SP site. Go to People and groups and create a group IT. And Add users to the group. Added test user 1 in the SP group. STEP 2: Open the InfoPath 2010. Created 3 fields Name, Emp ID, Department and 2 Buttons Submit to IT and Submit STEP 3: Go to the Data tab and select Data Connections Add a Data Connection   STEP 4: A data connection wizard box opens. Select create a new connection and Select Receive data And C
Read more

Create multiple columns inside SharePoint List using Powershell

By -
Image
Hi All, 1) In this post we will be seeing how to add multiple columns inside SharePoint List/Library and adding to the view 2) Refer the below posts in the powershell series.  Bulk Creation of Site Columns:  http://www.sharepointbasic.com/2016/11/powershell-script-to-create-bulk-site_27.html Bulk Creation of Site Content Types:     http://www.sharepointbasic.com/2016/12/powershell-script-to-create-bulk-site.html Bulk Lists and Libraries in SharePoint http://www.sharepointbasic.com/2016/12/powershell-script-to-create-bulk-lists.html Bulk File upload to sharepoint library http://www.sharepointbasic.com/2016/12/upload-multiplebulk-files-to-sharepoint.html 3) Create a CSV File like below 4) Use the below Powershell script #This script creates site columns from the given csv file #Author: Prem Kumar #Date: Feb 11 2015 param ( [string] $rooturl = $( Read-Host -prompt "Enter Web Application Root URL...?" ), [string] $listname = $( Read-Host
Read more