Hi guys, I am having trouble setting field value. I am trying to set the I have 2 columns. 1 .Responsible Persons and 2. Responsible Persons Manager.
I am using a set field value function to update the Responsible Persons Manager according to the Responsible Persons manager if the field under the Responsible Persons is filled out. I am using User profiles to do this.
This is my config
It works, but if I fill out 2 Responsible Persons. It will only update the Responsible Persons Manager field to show 1 of the manager for the 2nd employee. I need the field to display 2 of the Managers. If you guys can help please do thank you!
PS: Both columns type are Person or Group is that the reason why?
that's not possible this way.
you'll have to split Employees_names with use of a regular expression action into single names and store into a collection variable.
then iterate over the collection with for each loop and lookup a Manager for each single person. store list of managers into a separate collection.
finally, after the loop perform list field update with managers collection value.