Hello

I believe the only solution is to use the "Retrieve and item" action and pass it the ID (as an int) from the lookup field.

Hope this helps.

Ed

Hi @clrowe1124 ,

I think this might be part of the limitation of the SharePoint API that is triggering the start of the workflow.

I did a quick list with a lookup column.

First config was lookup column as title only.

Second config was lookup column settings as ID plus show Title as additional column displayed.

In both cases when I look at the API output (eg [SiteURL]/_api/web/lists/GetByTitle('TestLookup')/items)

it only displays the ID value for the column name in the API output.

I created a workflow to start as sharepoint online and new item created. From this I can only see the ID value in the lookup column. So from that you would need to do a query list to lookup the value in the workflow actions.

If doing a nintex form as the start action, the other options for looking this up would a data source lookup control or an external data source.

I did have a test with other API options such as:  /_api/web/lists/GetByTitle('TestLookup')/items(1)/FieldValuesAsText

In this case it retrived the display values of the lookup column rather than the underlying ID value.

It could be worth raising as an idea to return both the internal ID and display value for a lookup column in the workflow. https://ideas.nintex.com/ 

Using that action did the trick. I was looking for a single action vs "Query a List" that requires a loop to use the item the query retrieves.  Thanks for suggestion.

@Gavin-Adams: I have added such idea: Provide values from Multi-Lookup column in Start-Event | Nintex Ideas

Of course, I got it to work, but it would be much better, to have these values just like this :)

What if the lookup column has multiple values?

NWC gives me the value like this:

“1;2;3”

I can’t find an action that will allow me to convert this to an array through which I can loop and do a query.