Skip to main content

Hi All,

I have created a repeating section which contains a lookup field that looks up a supporting list. The repeating section also contains a few calculated fields that use the Lookup() runtime function in order to pull back the appropriate data.

When I have just one row, the information pulled back is fine. This indicates I have the formulas correct.

When I add a second row, the the calculated columns in all rows go blank.

Anyone seen this before? I have replicated a similar form (example above) in our DEV environment and it does the same thing, so am thinking it is something bigger than poor form development. What am I missing? We require this information to be displayed in the form itself, as we are driving users to work from the completed forms as opposed to outputting the information in an email or a list view.

Using SP2013 and Nintex Forms 2013 2.7.0.0

I have looked at the bug fixes for a few of the more recent versions but nothing is apparent. Suspect it may be this though?

We are also currently standing up an O365 environment, so upgrading the forms software isn't a preferred solution.

Hi ‌,

What do you mean standing up an O365 environment?
For your information, this kind of configuration works properly in Nintex Forms O365.


I have tested that Nintex Forms 2013 2.10.2.0 also working properly with this configuration.


make sure your cost and description controls are relay contained in repeating section, not just overlapping it.


Thanks for confirming this Abdullah happy.png


I have worked out the problem - I had configured the lookup as follows:

lookup("list title", "column to filter on", value to filter on, "output column")

when I should have configured it like this:
lookup("list title", "column to filter on", parseLookup(value to filter on), "output column")
All working as expected now.

Thanks, I have fallen in to this trap once or twice in the past, and it is difficult to see. Always the first thing I check now!


I have the same problem but I don't know which formulas to use. I have a repeating section that calculates cost and quantity, but when I click to repeat the field the total cost displays a formula value error (#Value!). Please advise? 

Also, how do paste screenshots in my comments?


With my example of the repeating section, I found that using a parseLookup within the formula worked better than the straight Lookup. I also found that when doing calculations that passing the value in to a variable first, then running the calculation on the variables had better success. Not sure if this is the general consensus, or just me. I also found that the Lookup formula was one of the more difficult formulas to get working - check syntax as it has to match exactly.

With regards to the inserting of images, I always take a screenshot first and edit, crop etc, then save to desktop. Then I insert using the Insert Image button.

Hope this helps!


I believe this is the solution to my problem, but am very junior with Nintex and can't seem to implement it correctly. In mine, I have a pull down selection (state) and once selected want to pull three fields of data from that list form: Zip code, Assigned Manager, and Notes. I went into List Settings and setup lookups for the State list, State:Zip code, State:Assigned Manager, and State:Notes. 

With your example above I am equating List Title to my States list, Column to Filter On to my State name field, Value to Filter On to my State:Zip code, but I do not know what to do with Output Column.

Any additional guidance for this novice would be appreciated.


Hi Keith, apologies for the delay in replying.

From memory, I didn't bother with all the other setting of lookups, as my users only referred to the form content iteself. This might be the red herring. The information I pulled back was displayed in a calculated field too. This field had no requirement to write back to the list itself which made things immesasureably easier to manage.

To answer your question, the output column should be the data you want displayed on the form.

Anything in " " is referencing the list you are looking up (list title, column to filter on, output). Note this is all manually typed too, apart from the value to filter on field which is retrieved by the picker.

Hope this gets you across the line!


Thank You, I'll see if this gets me over the hurdle. happy.png


Reply