--- title: Nintex Workflow for Office 365 – How to get the corresponding values of a lookup column value description: You get an instruction on how to get the corresponding values of a lookup column value in Nintex Workflow for Office 365. image: https://blog.hansevision.com/hubfs/windows-4jObbWz5vfI-unsplash%20(1)_small.jpg --- [![HanseVision\_x\_Bechtle\_Group\_RGB\_Black](https://blog.hansevision.com/hs-fs/hubfs/HanseVision_x_Bechtle_Group_RGB_Black.png?width=225&height=45&name=HanseVision_x_Bechtle_Group_RGB_Black.png)](https://www.hansevision.com/) [Blog](https://blog.hansevision.com) Lösungen [Readiness](https://www.hansevision.com/readiness.html)[Wissensmanagement](https://www.hansevision.com/wissensmanagement.html)[Prozessautomatisierung](https://www.hansevision.com/prozessautomatisierung.html) Leistungen [Individuelle Lösungen](https://www.hansevision.com/individuelle-loesungen.html)[Adoption and Change Management](https://www.hansevision.com/adoption-changemanagement.html)[Support](https://www.hansevision.com/premiumsupport.html) [Über uns](https://www.hansevision.com/hansevision.html) [Termine](https://www.hansevision.com/termine.html)[Kundenprojekte](https://www.hansevision.com/referenzen.html)[Unsere Partner](https://www.hansevision.com/partner.html)[HanseVision Update](https://get.hansevision.com/de/newsletter) Karriere [HanseVision als Arbeitgeber](https://hansevision.career.softgarden.de/)[Jobs](https://hansevision.softgarden.io/de/vacancies) [Kontakt](https://www.hansevision.com/kontakt.html) [![HanseVision\_x\_Bechtle\_Group\_RGB\_Black](https://blog.hansevision.com/hs-fs/hubfs/HanseVision_x_Bechtle_Group_RGB_Black.png?width=163&height=32&name=HanseVision_x_Bechtle_Group_RGB_Black.png)](https://www.hansevision.com/) [Blog](https://blog.hansevision.com) Lösungen [Readiness](https://www.hansevision.com/readiness.html)[Wissensmanagement](https://www.hansevision.com/wissensmanagement.html)[Prozessautomatisierung](https://www.hansevision.com/prozessautomatisierung.html) Leistungen [Individuelle Lösungen](https://www.hansevision.com/individuelle-loesungen.html)[Adoption and Change Management](https://www.hansevision.com/adoption-changemanagement.html)[Support](https://www.hansevision.com/premiumsupport.html) [Über uns](https://www.hansevision.com/hansevision.html) [Termine](https://www.hansevision.com/termine.html)[Kundenprojekte](https://www.hansevision.com/referenzen.html)[Unsere Partner](https://www.hansevision.com/partner.html)[HanseVision Update](https://get.hansevision.com/de/newsletter) Karriere [HanseVision als Arbeitgeber](https://hansevision.career.softgarden.de/)[Jobs](https://hansevision.softgarden.io/de/vacancies) Zurück 1 Minuten Lesezeit 29.01.2017 [Workflow](https://blog.hansevision.com/tag/workflow) [Nintex](https://blog.hansevision.com/tag/nintex) [Tutorial](https://blog.hansevision.com/tag/tutorial) ![Bild von Jan Von Reith (ehemaliger Mitarbeiter)](https://blog.hansevision.com/hs-fs/hubfs/profile.png?width=140&height=140&name=profile.png) [Jan Von Reith (ehemaliger Mitarbeiter)](https://blog.hansevision.com/author/jan-von-reith) # Nintex Workflow for Office 365 – How to get the corresponding values of a lookup column value --- In my scenario, I have two lists. The first list is called “Car marks and Product locations”, where I store car marks and the locations where they are produced. [![image](https://blog.hansevision.com/hs-fs/hubfs/Imported_Blog_Media/image_thumb-11.png?width=304&height=190&name=image_thumb-11.png "image")](https://static.hsstatic.net/BlogImporterAssetsUI/ex/missing-image.png) The second list is called “Car marks”, there I can create entries and choose between different car marks via a lookup column on my first list. The corresponding locations for the chosen car marks should automatically be stored in an additional column called “Product locations”. [![image](https://blog.hansevision.com/hs-fs/hubfs/Imported_Blog_Media/image_thumb-12.png?width=304&height=124&name=image_thumb-12.png "image")](https://static.hsstatic.net/BlogImporterAssetsUI/ex/missing-image.png) The workflow that identifies the corresponding values looks like this: First I use a “Set variable” action to get the ID’s of the values that have been chosen in the lookup column “Car marks” and store them in a variable called “varCarMarksLookupIDs”. [![image](https://blog.hansevision.com/hs-fs/hubfs/Imported_Blog_Media/image_thumb-13.png?width=604&height=234&name=image_thumb-13.png "image")](https://static.hsstatic.net/BlogImporterAssetsUI/ex/missing-image.png) At this point it’s important to mention that I choose “Lookup IDs, Comma Delimited” as the format for the values I store in the variable. [![image](https://blog.hansevision.com/hs-fs/hubfs/Imported_Blog_Media/image_thumb-14.png?width=304&height=165&name=image_thumb-14.png "image")](https://static.hsstatic.net/BlogImporterAssetsUI/ex/missing-image.png) Then I use a “Regular expression” action to split the single IDs and put them into a collection variable called “vCarMarksLookupIDsCollection”. [![image](https://blog.hansevision.com/hs-fs/hubfs/Imported_Blog_Media/image_thumb-15.png?width=504&height=260&name=image_thumb-15.png "image")](https://static.hsstatic.net/BlogImporterAssetsUI/ex/missing-image.png) Now I’m using a “For each” action to iterate through all ID’s that have been stored in the collection. The current ID always gets stored in a variable called “vCarMarkSingleLookupID”. [![image](https://blog.hansevision.com/hs-fs/hubfs/Imported_Blog_Media/image_thumb-16.png?width=504&height=269&name=image_thumb-16.png "image")](https://static.hsstatic.net/BlogImporterAssetsUI/ex/missing-image.png) In the first step of the “For each” action I get the product locations for the current car mark ID and store them in a variable called “vCarMarkProductLocations” with the help of a “Set variable” action. [![image](https://blog.hansevision.com/hs-fs/hubfs/Imported_Blog_Media/image_thumb-17.png?width=604&height=402&name=image_thumb-17.png "image")](https://static.hsstatic.net/BlogImporterAssetsUI/ex/missing-image.png) In the second step of the “For each” action I build a continuous string of all product locations with the help of the “Build string” action. The variable “vCarMarksProductLocationsAll” contains all product locations. For every loop, I add the corresponding product locations for the current ID to that string. [![clip\_image016](https://blog.hansevision.com/hs-fs/hubfs/Imported_Blog_Media/clip_image016_thumb.jpg?width=604&height=192&name=clip_image016_thumb.jpg "clip_image016")](https://static.hsstatic.net/BlogImporterAssetsUI/ex/missing-image.png) At the end of the “For each” action I have all corresponding product locations for every car mark in my string variable and can now update the item with it. [![image](https://blog.hansevision.com/hs-fs/hubfs/Imported_Blog_Media/image_thumb-18.png?width=604&height=192&name=image_thumb-18.png "image")](https://static.hsstatic.net/BlogImporterAssetsUI/ex/missing-image.png) This is how the whole workflow looks at the end: [![clip\_image019](https://blog.hansevision.com/hs-fs/hubfs/Imported_Blog_Media/clip_image019_thumb.png?width=276&height=804&name=clip_image019_thumb.png "clip_image019")](https://static.hsstatic.net/BlogImporterAssetsUI/ex/missing-image.png) And this is the result after the run of the workflow: [![image](https://blog.hansevision.com/hs-fs/hubfs/Imported_Blog_Media/image_thumb-19.png?width=404&height=137&name=image_thumb-19.png "image")](https://static.hsstatic.net/BlogImporterAssetsUI/ex/missing-image.png)     ![Bild von Jan Von Reith (ehemaliger Mitarbeiter)](https://blog.hansevision.com/hs-fs/hubfs/profile.png?width=140&height=140&name=profile.png) [Jan Von Reith (ehemaliger Mitarbeiter)](https://blog.hansevision.com/author/jan-von-reith) Diese Person ist nicht mehr für HanseVision tätig. [Alle Artikel des Autors](https://blog.hansevision.com/author/jan-von-reith) ### Ähnliche Blog-Artikel ![](https://blog.hansevision.com/hs-fs/hubfs/Theme%20Development/hansevision-newsletter.png?width=410&name=hansevision-newsletter.png) ### Mit unserem HanseVision Update sind Sie immer gut informiert über alle Themen rund um moderne Zusammenarbeit, Lösungen und Tools, Referenzen und Aktionen. [![Jetzt zum Newsletter anmelden](https://hubspot-no-cache-eu1-prod.s3.amazonaws.com/cta/default/24882854/c769ef8c-5eed-48ae-ada2-7fc72d656a50.png)](https://hubspot-cta-redirect-eu1-prod.s3.amazonaws.com/cta/redirect/24882854/c769ef8c-5eed-48ae-ada2-7fc72d656a50) Updates & Aktionen Versand alle 4-6 Wochen Trends & aktuelle Entwicklungen ![](https://blog.hansevision.com/hs-fs/hubfs/Theme%20Development/hansevision-newsletter.png?width=250&height=250&name=hansevision-newsletter.png) [![Jetzt zum Newsletter anmelden](https://hubspot-no-cache-eu1-prod.s3.amazonaws.com/cta/default/24882854/c769ef8c-5eed-48ae-ada2-7fc72d656a50.png)](https://hubspot-cta-redirect-eu1-prod.s3.amazonaws.com/cta/redirect/24882854/c769ef8c-5eed-48ae-ada2-7fc72d656a50) [Datenschutzerklärung](https://www.hansevision.com/datenschutzerklaerung.html) [Impressum](https://www.hansevision.com/impressum-688471.html) [AGB](https://www.hansevision.com/uploads/4/1/9/3/41931735/hansevision_agb_der_hansevision_gmbh_stand_31.03.2020.pdf) [Telefon: +49 (40) 2880 7590 - 0](tel:+4940288075900) Adresse: Atlantic Haus, Bernhard-Nocht-Strasse 113, 20359 Hamburg [Cookie-Richtlinien](https://www.hansevision.com/cookie-richtlinie.html) Cookie-Einstellungen ```json { "@context" : "https://schema.org", "@type" : "BlogPosting", "author" : { "@type" : "Person", "name" : "Jan Von Reith (ehemaliger Mitarbeiter)", "url" : "https://blog.hansevision.com/author/jan-von-reith" }, "dateModified" : "2023-04-26T08:20:52.094Z", "datePublished" : "2017-01-29T23:00:00.000Z", "headline" : "Nintex Workflow for Office 365 – How to get the corresponding values of a lookup column value", "image" : [ "https://blog.hansevision.com/hubfs/windows-4jObbWz5vfI-unsplash%20(1)_small.jpg" ], "mainEntityOfPage" : { "@id" : "https://blog.hansevision.com/nintex-workflow-for-office-365-how-to-get-the-corresponding-values-of-a-lookup-column-value", "@type" : "WebPage" }, "publisher" : { "@type" : "Organization", "logo" : { "@type" : "ImageObject", "url" : "https://blog.hansevision.com/hubfs/HanseVision_x_Bechtle_Group_RGB_Black-1.png" }, "name" : "HanseVision GmbH" } } ```