Skip to main content
Nintex Community Menu Bar
Solved

NWC workflow returns IDs instead of Values for SharePoint List Lookup Field

  • November 30, 2022
  • 1 reply
  • 60 views
  • Translate
T
Forum|alt.badge.img+4

I have a SharePoint online list called CRs with a field called Application which is a lookup field to another list called Applications. The field allows for multiple selections.

27289i5402FFB4FB86B8E1.png

I need to display those values in various emails throughout the NWC workflow whose start event is a New Item in the CR list. As you might imagine, the values actually displayed in the email are the IDs of the applications in the list rather than the Names - i.e. 1; 3 instead of Clarinet; SharePoint.

 

27291i6F4DB2584CE09308.png

I know I need to somehow get the ids then loop through each one to retrieve the Application Name but I'm having a hard time pulling it together with the right actions. Hoping someone else has faced this challenge before and as a solution. Thanks in advance for your help.

Best answer by WouterT

Good question as it happens often.

Here is my example that hopefully explains it:

I have a test list with a Countries field that selects multiple countries from a list named Countries.

I define the lookup field Countries in my new SharePoint test list like this:

The extra tick box for Countryname comes handy later on.

I entered some data:

Next, I created a test workflow that looks like this:

So, I query all the items and loop through each of them.

The body for the send an email action has this:

Finally, I run a test and receive this email:

Sharepoint does the work here for us actually. Hope this helps.

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

    1 reply

    WouterT
    Forum|alt.badge.img+9
    • WouterT
    • Apprentice
    • 78 replies
    • Answer
    • December 1, 2022

    Good question as it happens often.

    Here is my example that hopefully explains it:

    I have a test list with a Countries field that selects multiple countries from a list named Countries.

    I define the lookup field Countries in my new SharePoint test list like this:

    The extra tick box for Countryname comes handy later on.

    I entered some data:

    Next, I created a test workflow that looks like this:

    So, I query all the items and loop through each of them.

    The body for the send an email action has this:

    Finally, I run a test and receive this email:

    Sharepoint does the work here for us actually. Hope this helps.

    Translate
    Process Developer with Nintex and SharePoint. Contact: w.terlunen@gmail.com
    T
    1 person likes this
    • T
      tmfitz

    Reply


    Sidebar Buttons
    Nintex Community Home Contact Nintex Support Email Nintex Community Check Nintex Status
    Terms & ConditionsCookie Settings

    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