SharePoint Integration

Re: storing repeating table values in SharePoint form library:

tjohnson101374 — Tue, 04 Mar 2014 19:31:48 GMT

I did find out the as long as the Content type is set to be searchable, then once the search index runs, it will start showing up in searches

Re: storing repeating table values in SharePoint form library:

csigler — Tue, 04 Mar 2014 18:50:12 GMT

Good question. Just noticed that myself.

Re: storing repeating table values in SharePoint form library:

tjohnson101374 — Wed, 19 Feb 2014 21:54:36 GMT

Hilary, Is there a way to make that field searchable? Meaning if you are merging them into a sharepoint column, that column is no longer sort or filterable but when I try to search for something in that field it doesn't show up.

Re: storing repeating table values in SharePoint form library:

ravichandra — Fri, 08 Feb 2013 05:34:10 GMT

Hi Hilary

an you refer this link http://www.infopathdev.com/forums/t/25043.aspx provide me some solution and i am thinking to implement your method given in this linkhttp://www.infopathdev.com/forums/t/22414.aspx.

if i merge the values i will get values in bulk in my column,so when i use this column in my email,it will bring all the values, i want to format it properly ,can i create a html table in mail,since i have 5 fields in repeating section and in parallel 5 columns in form library list .Hope you understood my requirement.

For your refernce you can veiw this link https://www.nothingbutsharepoint.com/sites/eusp/Pages/Creating-HTML-Emails-with-SPD-Workflows.aspx

Re: storing repeating table values in SharePoint form library:

csigler — Fri, 25 Jan 2013 17:48:11 GMT

Hello Hilary! Once again you have saved me significant time when running into a problem. Worked like a charm and was EXACTLY what I needed.

Corrie

Re: storing repeating table values in SharePoint form library:

bushan — Tue, 07 Aug 2012 05:32:52 GMT

Hi we are using Merge property for getting the repeating table values in InfoPath form, but we have not retrieve the full data from form control in share point form library. its getting only 10 lines data after reach the 10 lines it will not displayed.(Control name : Multiple test box for Comments )

Re: storing repeating table values in SharePoint form library:

UN2010 — Fri, 20 Apr 2012 15:28:41 GMT

Thanks Hilary, that helped.

Re: storing repeating table values in SharePoint form library:

Hilary Stoupa — Thu, 19 Apr 2012 14:26:28 GMT

I'm sorry - I really don't understand the question.

Your form has a data source - visible in the data source task pane. If there are repeating groups in your data source, they can be bound to repeating table controls on your form.

When promoting any data to your SharePoint library, the data gets stored in a column in the library - just like a list column. SharePoint uses SQL for its data - so the value will be in those tables someplace.

Any time your form is submitted to the library, the column gets updated with the current form values.

Does that help?

Re: storing repeating table values in SharePoint form library:

UN2010 — Thu, 19 Apr 2012 02:38:47 GMT

Hi Hilary, i want to know where are the repeating table values stored and in which format. Can these values be retrieved in the same form? Can you please point me to the resource which gives a good understanding of the repeating tables with info path and sharepoint? Thanks

Re: storing repeating table values in SharePoint form library:

Hilary Stoupa — Wed, 18 Apr 2012 18:51:06 GMT

You bet - glad you have it all set up.

Re: storing repeating table values in SharePoint form library:

UN2010 — Wed, 18 Apr 2012 18:35:49 GMT

Thanks Hilary, it worked, i promoted all the repeating table column fields and i can see the data in the share point list. Thanks again.

Re: storing repeating table values in SharePoint form library:

Hilary Stoupa — Wed, 18 Apr 2012 18:14:58 GMT

When you publish your form to a SharePoint library, you can choose the fields you wish to "promote" or display in the form library. You can also add those under the Form Options (Tools > Form Options in IP 2007, File > Info > Form Options in IP 2010). Does that make sense?

Re: storing repeating table values in SharePoint form library:

UN2010 — Wed, 18 Apr 2012 18:10:09 GMT

Hi Hilary, thanks for the reply. I'm sorry, I didn't get the promotion point, i didn't use this property earlier. Can you please elaborate? And yes, this form is still in development and they will have a meaningful name when i get it working and push to testing environment. Thanks for the advice.

Re: storing repeating table values in SharePoint form library:

Hilary Stoupa — Wed, 18 Apr 2012 16:47:17 GMT

Hi - to promote your repeating fields, you don't have to use a double eval formula.

Simply promote the repeating field, and select "merge" - see screenshot. As a side note - if your form is not yet in production, you may want to consider giving your fields and groups meaningful names instead of "group13" and "field60".

storing repeating table values in SharePoint form library:

UN2010 — Wed, 18 Apr 2012 16:39:02 GMT

I want to store repeating table values is sharepoint form library. I have a repeating table with 3 drop down list and a text field. I concatenated all the values from 3 drop down list in to the text field using the formula: concat(field56, ";", field57, ";", field58). I created a separate text field in the form and trying to set it to store all the values from the text boxes of the repeating table as the user adds new rows to the repeating table. I used the formula: substring(eval(eval(group13, 'concat(field60,";" )'), ".."), 0, string-length(eval(eval(group13, 'concat(field60, ";" )'), ".."))). The problem is, it only adds the first value of the text box, it doesn’t loop around and select the second value. Field60 is the text box field. Can anybody help me fix this?