mikkele
Design Dabbler

User/Person filed returns number and # instead of username

Jump to solution

I am torubleshooting an exising workflow, specifically an error when setting a variable using a lookup. The field is Person/Group and I get this error (screenshot)

WF-Fail1.jpg

I have tested the same action on a brand new list with the exact same configuration and fields and it resolves correctly (screenshot)

WF-success1.jpg

WF.jpg

 

Any idea? Sorry for the language 🙂

 

0 Kudos
Reply
3 Replies
kunalpatel
Automation Master
Automation Master

Re: User/Person filed returns number and # instead of username

Jump to solution

@mikkele .....Since you're using list lookup, it's going to give you ID;#ColumnYouNeed combination.

 

First, is Verteiler a people group field? If it is then click the "..." next to it and select Display Name.

 

Second, after set variable action, you need to do RegEx operation to remove ID;# use below information:

  • Pattern: ^\d*\;\#
  • Replace Text
  • Replacement Tex keep blank
  • Input Text: Workflow variable from above set variable action
  • You can store it in the same variable or different if you like (I prefer to re-use the variable if possible)

View solution in original post

Reply
mikkele
Design Dabbler

Re: User/Person filed returns number and # instead of username

Jump to solution

@kunalpatel Thanks for the super quick and helpful reply!

I did select to return the display name and I don't seem to need to use the reg exp to remove the #? 

 

WF-success2.jpg

0 Kudos
Reply
kunalpatel
Automation Master
Automation Master

Re: User/Person filed returns number and # instead of username

Jump to solution

@mikkele ...could you mark this as accepted solution if it worked for you? Thanks.

0 Kudos
Reply