Skip to main content
Nintex Community Menu Bar
Question

Nintex Form: Using lookup value to pass as filter to list view control

  • February 8, 2023
  • 4 replies
  • 879 views

Forum|alt.badge.img+8

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.

Translate
Did this topic help you find an answer to your question?

4 replies

MegaJerk
Forum|alt.badge.img+14
  • Scholar
  • 832 replies
  • February 8, 2023

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

Translate

Forum|alt.badge.img+8
  • Author
  • Scholar
  • 57 replies
  • February 8, 2023

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.

Translate

Forum|alt.badge.img

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

Translate

Forum|alt.badge.img+2
  • Rookie
  • 6 replies
  • January 9, 2025

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. 

 

Translate

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie Settings