mardi 23 décembre 2014

Repeating Table with Column From Secondary Source



I have been struggling with this all day. I have an Infopath form that is connected to two Sharepoint Lists.


SP List 1 (Project Charters):



  • Charter Title

  • Charter Opportunity

  • Charter Start Date


SP List 2 (Project Weekly):



  • Weekly Title

  • Weekly Opportunity.


I am attempting to combine these two lists into 1 repeating table on a new form. The Weekly Title field holds the same values as the Charter Title field, so I can match using Titles. I have found some resources, with this being the best:


http://ift.tt/1xIVw3U


There is a sample toward the end that does exactly what I want, but it will not work with my setup. Here is what I get:


Infopath Problem


As you can see in the picture, the "From my weeklys" column is always the same, and this is the problem. It should match with the corresponding field highlighted in red two the left. This is the formula in the calculated field:



Weekly_x0020_Opportunity[Weekly_x0020_Title = current()/Charter_x0020_Title]


The logic is to return the Weekly Opportunity description, where the Weekly Title matches the Charter Title; however, it only ever returns the same description. The testing column was used to prove that current()/Charter_x0020_Title was producing the unique titles for that row.


I feel like I am really close. The 3rd charter is missing a description, because my Weekly does not have a 3rd charter, so this is working properly. I just need to figure out how to bring-in the proper description.


Note: I am hoping for an Out-of-the-Box solution without coding.








0 commentaires:

Enregistrer un commentaire