AnsweredAssumed Answered

Remove ID (characters) after Username

Question asked by bimi82 on Sep 20, 2018
Latest reply on Sep 21, 2018 by bimi82



I have a workflow which updates a Group or People field with 2 usernames.
The purpose is to show them in such a format:  Tom Jones; Alice Smith 


However, when extracting the list from to Excel then I see the following: Tome Jones;#57;#Alice Smith;#116


How can I make those characters disappear?
When looking at the list then the names are appearing correct without the ID's.



In the workflow I have a Build String as following:


The variable LogPurchManager is set to Text / Single Line.
I am not sure if that needs to be People or Group instead ??




I also got an Update Item function to update the Managers field:




Just wondering how would I remove those # ID's.