Trying to append multiple values to an assets referenced field
Hi there,
Currently I have a CSV import of data from another system that outputs user fields with multiple users like this
name1@test.com;name2@test.com;name3@test.com for as many email addresses are in the field. The field data just imports into a text field at the moment as I can't change the source so I can't pipe it in.
In the automation I create a variable based on that field and then split up the list based on the variable
I then do a lookup objects in the branch to come up with Name of the person to then edit into the relevant field to reference back to the People schema from this applications schema.
BUT it only ever gets the last one as it is happening in a loop and I can't build a variable in the loop that can be accessed outside of the loop.
If I edit in the loop it always overwrites, there isn't a way to say Append or Add (annoyingly).
Does anyone have any ideas on how I could achieve this.
Thanks
