Repeating Table listing - InfoPath Dev Sign in | Join | Help in Newbie Questions InfoPath (Entire Site) InfoPath Dev InfoPath Dev is dedicated to bringing you the information and tools you need to be successful in your Microsoft Office InfoPath development projects. Home Blogs Forums Photos Downloads InfoPath Dev » InfoPath » Newbie Questions » Repeating Table listing Repeating Table listing Last post 04-20-2016 05:16 PM by myjpkl. 6 replies. Page 1 of 1 (7 items) Sort Posts: Oldest to newest Newest to oldest Previous Next 03-27-2016 06:11 PM myjpkl Joined on 03-27-2016 Posts 5 Repeating Table listing Reply Contact Hi I created a form with repeating column table. But how do get my View to show my repeating column data ? When go to Modify view, I'm unable to see Repeating Table as part of Column Name. Please help 03-31-2016 07:37 AM In reply to Hilary Stoupa Joined on 06-20-2008 Posts 13,297 Re: Repeating Table listing Mark as Not AnswerMark as Answer... Reply Contact Hi - I don't understand the question. Can you maybe attach your form or a screenshot under the Options tab in a reply? Hilary Stoupa 03-31-2016 08:23 PM In reply to myjpkl Joined on 03-27-2016 Posts 5 Re: Repeating Table listing repeating.png Mark as Not AnswerMark as Answer... Reply Contact Here attached, I have created a Repeating Table in my form using InfoPath. Under Modfiy View, I cannot see my Column for the Repeating Table. Here attached 04-01-2016 07:35 AM In reply to Hilary Stoupa Joined on 06-20-2008 Posts 13,297 Re: Repeating Table listing Mark as Not AnswerMark as Answer... Reply Contact Okay, so I think you are saying the field you want isn't available in your form library. You need to promote the field when you publish. If you want to see all the selections, you can select the Merge function. You can find some more info here: http://www.bizsupportonline.net/blog/2014/promote-infopath-form-fields-to-sharepoint-library.htm Hilary Stoupa 04-20-2016 12:03 AM In reply to myjpkl Joined on 03-27-2016 Posts 5 Re: Repeating Table listing Mark as Not AnswerMark as Answer... Reply Contact Say if i have : No Name Position 1 Michael ED 2 PC Woo CEO 3 Lee Anz Business Development Manager 4 Angz Wiz Project Manager 5 Alex G Assistant Business Development Manager 6 Sallg Planner 7 Frank QA Manager I can't list all 7 Name and Position in list. "You cannot promote rows of a repeating table to SharePoint, because SharePoint does not support the repeating table data structure. Since you can only promote one value to SharePoint, InfoPath provides functions you can use to promote repeating table data. You can choose to: Promote the amount of rows (so a number) to SharePoint. Promote the first repeating field in the repeating table to SharePoint. Promote the last repeating field in the repeating table to SharePoint. Promote all of the values of a column in a repeating table as one merged field. The values from each repeating field in one column will then appear as multiple lines of text in SharePoint." All name and position will be scrambled up into 1 field and looks ugly 04-20-2016 04:31 PM In reply to Hilary Stoupa Joined on 06-20-2008 Posts 13,297 Re: Repeating Table listing Mark as Not AnswerMark as Answer... Reply Contact Yes, this is a limitation of promoted fields and repeating data. You could also use code, qRules or CAML to write your repeating data out to another list. I have heard of people using workflow for this as well, but have never tried that myself. Hilary Stoupa 04-20-2016 05:16 PM In reply to myjpkl Joined on 03-27-2016 Posts 5 Re: Repeating Table listing joe.jpg Mark as Not AnswerMark as Answer... Reply Contact Thanks Hilary for the support Attached the pic to illustrate. Reason we want this is, we want it to be such like a report. So at the end of day... our user can print out the form listing which contains all information. Page 1 of 1 (7 items) Copyright © 2003-2019 Qdabra Software. All rights reserved.View our Terms of Use.
Yes, this is a limitation of promoted fields and repeating data. You could also use code, qRules or CAML to write your repeating data out to another list. I have heard of people using workflow for this as well, but have never tried that myself.