AnsweredAssumed Answered

Remove ID (characters) after Username

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

Hello

 

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.

Outcomes