Solved

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

  • 30 November 2022
  • 1 reply
  • 40 views
T
Badge +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.

icon

Best answer by WouterT 1 December 2022, 09:48

View original

1 reply

WouterT
Userlevel 3
Badge +9

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.

Process Developer with Nintex and SharePoint. Contact: w.terlunen@gmail.com

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings