Hi Thomas,
I assume that you are using Nintex Forms and a drop down control to display your events?
When the user selects a value of the drop down, the value of the selected option can be found as a formatted string as "[id];#[Title]". If you add a calculated control to your form and set it's formula to the value of your events "Named Control", you can see this value output. e.g.
This should be the value saved in your list column. You should be therefore able to use the Regular Expression action to trim out the ID of the value and assign it to the workflow variable.
Off the top of my head, I think I would have to:
- Do a 'Split' regex action on the lookup column using the pattern "(;#)"
- Pull the first item from the collection variable that you'll assign your split output to
- This should give you your ID.
Cheers,
Stu
Hi Stu
Unfortunately I'm not using it in a form, but in a workflow step (set variable).
There the field does not contain ID;#Text as it does in raw SharePoint, it only returns the text part.
So where has the ID gone? Why is it stripped off?
Kind regards,
Thomas
WHy dont I see the option as ID, Have two option as string and as lookup value as text
I was running into this problem as well on our on-premise installation. If Nintex for Office 365 is anything like it, then by setting the variable as an Integer first, the action will automatically use the ID. On the other hand, if the variable is text, it defaults to Value and does not let me change it.
@tech-bar19 and @abhilashpatnaik when using the lookup, your variable will be a text or number. This doesn't really matter.
When you use the lookup, you can choose the Current Item > ID this will come in as a string. If the workflow is running on the current item created such as the event, to create the participant for that event, then this should be running against the current item. I'm not sure why you would need to set this instead of just creating a new item and copying the ID or title when you do that to bind it.
