SharePoint 2013 updating a lookup column from another list not working


  1. IP Range: Includes a title column (single line of text) for ip ranges (ex. 10.1.1.x)

  2. IP List: Includes columns for ip range (lookup to IP Range List), ip address (single line of text) and status (lookup IP Status List)

  3. IP Status: Includes Title column (single line of text) with two entries, allocated and unallocated

  4. System List: Includes IP Range (lookup), IP Address (Lookup)

Creating a new item in System List and selecting a range from IP Range loads the "Unallocated" ip address in IP Address Column but doesn't change IP Status List column from "Unallocated" to "Allocated."

How can I make "Unallocated" change to "Allocated" and vice versa?

1 Answer 1


Per your description, you need to change the status for the selected IP address in IP list. Why do you want to change status in IP Status list?

You can create a Designer workflow for System List. Using the workflow, find the status field based on the IP address and update the status to “Allocated” in IP List when an item is created in System List.

If you also want to change “Allocated” to “Unallocated” when an IP address is not selected, you need to create an Event Receiver to handle list item events in System List. For example: ItemUpdating, ItemDeleting

A list of SPItemEventReceiver methods

Using the Event Receiver, when an item is updating/deleting, get previous value of Status before updating/deleting and update Status in IP address List.

  • I want to change the status (allocated or unallocated) in IP List not IP Status List. I misspoke. I will setup a workflow in SPD and let you know how it goes.
    – C1TonyB
    Commented Jun 7, 2018 at 11:51
  • How are things going? Commented Jun 11, 2018 at 1:39
  • I'm still working through this. Trying to find the right conditions and actions.
    – C1TonyB
    Commented Jun 13, 2018 at 14:43
  • In the workflow, you can use "Update List Item" action. Commented Jun 14, 2018 at 2:14

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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