I have a simple list represent a hierarchy. The list columns: ID, Title, Parent, other columns. Where Parent is a lookup column back to the list itself and get information from the Title column.

In a Nintex work flow, I need to look up the parent ID of the current item so to check values of other columns in parent item.

The query to get the parent ID, at best, from me is:

        <List ID="{8F29198F-04FA-4558-A5A6-64FA8A85E7DE}" />
        <FieldRef Name="Parent" />
            <FieldRef Name="ID" />
            <Value Type="Counter">{WorkflowVariable:CurrentID}</Value>

When storing the result of the query in a workflow variable ParentIDLookup, I, of course only get the parent Title, but not the parent ID

How do I get the parent ID from the current ID?

  • Note that, per the FAQ we do not accept questions about commercial third-party products. As far as I can tell this is a general SharePoint question which is fine. In future it would be great if you could phrase questions in general terms, rather than in relation to a vendor product (Nintex). Thanks. – SPDoctor Nov 24 '11 at 9:04

Try to execute a CAML query directly on the list (SPList.GetItems(SPQuery)) and not on the site, then you should get a value like <parentID>;#<parentTitle> (SPFielLookupValue) for the Parent lookup column.

  • Thanks, @Matthias for the answer. However, Nintex does not allow me to do so. As SPDoctor pointed out, it's not appropriate for me to ask this question here. I'll pursue the answer on Nintex site, and hope there is a satisfactory one. Cheers. – Tinminator Nov 29 '11 at 2:51

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.