I created a workflow to update a list (Rooms) when another list (People) is changed. I want to assign a value in the Room column in People list and have the value in column LastName be added to the Occupant column in Rooms. I've tried several iterations, and keep getting an error that has no meaningful information (at least to me).

Here's my workflow: enter image description here

Here's the People list settings:
enter image description here

Here's the Room list settings:
enter image description here

Here's the workflow error (Status: suspended): enter image description here

Any idea what this error means or what I'm doing wrong? What value can't be null? Isn't that what I'm checking for in the first step? As a first-time Sharepoint user, I'm really discouraged by how difficult this simple task seems to be.


I'm making some assumptions here, but is the Room in the People list unique, i.e. are their multiple list entries in the people list that have the same room? If so the workflow will not be able to use room in the people list as a unique identifier in the lookup, since there is more than one entree in the people list with the same room.

  • That seems logical, I hadn't seen that before. I just tried making both Room and RoomNumber unique, and now it has a slightly different error. At first it paused with this message: "Retrying last request. Next attempt scheduled in less than one minute. Details of last request: HTTP NotFound to https://..." Any idea what that refers to? – Bird May 8 at 17:34
  • can you post the full error? – evilfoamy May 8 at 23:35

In transition to stage, try to remove the condition and just go to the end of workflow. See if the error will still exist.

  • That's a good idea. I just tried that, unfortunately it looks like it's throwing the same error. – Bird May 8 at 17:28
  • Does the item in Rooms list get updated? Try to terminate the workflow and restart it again. – Michael Han_MSFT May 9 at 9:23

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.