Skip to main content
Nintex Community Menu Bar

I have a Nintex form on a list (SharePoint 2019).

I have a lookup control that points to list “Standards” and save only the value back to a SLT field “Standard”

I have a List View on the form that points to a list “Requirements” that has a column called Standard.  I wish to pass the Standard value from the lookup control (either item property or control value as it does not change) as a filter to the Standard column for the list view to filter upon.

Unfortunately all attempts have failed.  When I look at the text for the column “Standard, it looks fine.  The control however still has the ID value.

Things I have tried:

  • creating a calculated value parseLookup(Standard, true) pointing to the Standard named control (since a calculated value of the named control showed all the ID value jank) and using that as a filter, set to change on view, edit
  • When I use the item property
    • on New form, the entire list view displays as it should
    • Once I choose a Standard and save, coming back in via Edit or Display shows “No items in this view”

Has anyone had success with passing a lookup value to a list view?  I even played around with using a CAML query but no joy.

Can you please provide some screenshots of what’s going and the general layout /settings of all these controls. It’s difficult to parse with just text alone. Thank You


Main lists:

  • Annual Reviews - this is where the form lives
  • Standards - where you select the filter
  • Requirements - where the list view is created from

Form on Annual Reviews (crude form, just starting a conversion from Responsive to Classic):

Settings for lookup control:

Settings for list view control:

How new form presents before selecting Standard:

After selection:

I added a calculated value to the form to show what nmStandardNumber was and it came with the ID value attached.  I did a calculation where I did a parseLookup to return just the value and passed that to the List View with no luck.


Were you able to resolve this?  I am having the same issue.


Hi i didnt find solution with in Nintex but i use following code and worked me to filter the List view 

as “list view” Control dosent support filters form Lookup value i have created one  “single line of text” to take value form in “List View Filter” , and  input Client ID Javascript Variable name as following both in “lookupDropdownClientID” in lookup field, and input “singleLineTextClientID”  in single line of texts variable name. 

 

NWF.FormFiller.Events.RegisterAfterReady(function () {
    var lookupDropdown = NWF$('#' + lookupDropdownClientID);
    var singleLineText = NWF$('#' + singleLineTextClientID);
    if (lookupDropdown.length === 0 || singleLineText.length === 0) {
        return;
    }

    function updateSingleLineText() {
        var selectedValue = lookupDropdown.val();
        var parsedValue = selectedValue ? selectedValue.split(';#')[1] || selectedValue : '';
        if (singleLineText.val() !== parsedValue) {
            singleLineText.val(parsedValue);
            singleLineText.trigger('change');
        }
    }

    lookupDropdown.change(updateSingleLineText);
    updateSingleLineText();

    singleLineText.on('input', function() {
        var value = singleLineText.val();
        if (value) {
            singleLineText.trigger('change');
        }
    });
});
 

I request Nintex devlopment team to incorporate such filter with in the Applicaiton.