User/Person filed returns number and # instead of username

  • 1 November 2019
  • 3 replies
  • 1 view

Badge +2

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)

5249i0E0A596FC8921347.jpg

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

5250iCC085FFAB7EFAE66.jpg

5251i3C6408C020A407D1.jpg

 

Any idea? Sorry for the language :)

 


3 replies

Badge +12

@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)
Badge +2

@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 #? 

 

5254i55E79B041A62441B.jpg

Badge +12

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

Reply