I am currently trying to update a list via looping workflow, however I am having trouble. My workflow only updates the first occurrence on the item and then runs in an infinite loop. I need this to be a list workflow rather than a site workflow as well that triggers when an item is changed. Do not want a site workflow because we have 3000 items in the list and do not want to have it run each day on each item. As you can see below I am trying to have the data from List A (People Picker Test) write to List B (People Picker Test) based on the ProjectID Value.
WF is very basic, was hoping it wouldn't have to be complicated.
Your help is greatly appreciated!
Solved! Go to Solution.
If you look at the pictures from the initial post you'll see how I'm trying to update the People Picker field in List B based on the People Picker field in List A (might have to click on it as it appears cutoff).
The two lists share the same "ProjectID" value which would be the trigger to show which items in List B are updated.
Hi Greg Baker,
What you have to do is fetch the name from 1st list and store the value in a person type variable. Then pass this variable to the 2nd list. Also since you are using multiple updates via loop I would recommend using commit pending changes after update item action inside the loop.
I hope it helps. Keep us posted.
All the best.
Hi Greg Baker
Sorry, I did'nt see the people picker column.
Use "Update multiple items" action, not a loop.
List is "List B"
Filter is "ProjectID Equals [Item properties]ProjectID
Field "People Picker Test" = "List lookup", "Current item", "People Picer Test"
Thank you everyone for the help! I went ahead and tried it with "Update multiple items" and it works perfectly. Not sure how I overlooked this.
Ratnesh, I'll keep your suggestion in mind just in case something goes wonky with this current workflow.
I did have another question regarding this. There are occasions where a resource will be removed and the value will become blank. However, when the People Picker field is blank it appears the workflow errors out. Would you know a way to bypass this?
to set people picker to null, I use an empty text variable instead of the value of people picker in list A. Get the value of an empty people picker is not the same (don't know why)
Get people picker value into text variable
test if variable is empty
if true, set variable to fn-trim("") (empty string)
multiple update with variable and not list A column
jsut tested and approved