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.