Skip to main content
Nintex Community Menu Bar

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.

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.

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings