Skip to main content
Nintex Community Menu Bar
Solved

NWC form data lookup - Create a o365 item

  • June 2, 2021
  • 2 replies
  • 49 views
H
Forum|alt.badge.img+11

Hi

I have a sharepoint 365 list with a lookup column. I want to create a list item from data captured in a NWC form. Both the NWC form field and the 365 column, lookup to the same list. When i go to create an item with the data captured in the NWC form, the field for the lookup column in the o365 list is expecting an integer. I've tried finding the ID of the lookup with no success.  

 

Not exactly sure how to get the data captured in the NWC lookup field into the o365 list lookup field. 

 

Any suggestions?

Best answer by butlerj

@harfmt I believe in your NWC form's Data Lookup control you would want to set your 'label' to the items Title, and then the 'value' to the items ID from the list that you're looking up to. That way when you commit the data back to SharePoint you're sending the ID down to the lookup field.

    2 replies

    ghaiashish

    Hi 

     

    I am not sure what you are trying to achieve, you can use a data lookup control to get the lookup ids from lookup column and you an update lookup columns using IDs with update items action(SharePoint Online) 

     

     

     

    butlerj
    Nintex Employee
    Forum|alt.badge.img+20
    • butlerjNintex Employee
    • Nintex Employee
    • Answer
    • June 11, 2021

    @harfmt I believe in your NWC form's Data Lookup control you would want to set your 'label' to the items Title, and then the 'value' to the items ID from the list that you're looking up to. That way when you commit the data back to SharePoint you're sending the ID down to the lookup field.

    Nintex_Andrea
    Sidebar Buttons
    Nintex Community Home Contact Nintex Support Email Nintex Community Check Nintex Status
    Terms & ConditionsCookie SettingsAccessibility statement