Skip to main content
Nintex Community Menu Bar

Get the display name of user in repeater xml

  • October 3, 2019
  • 5 replies
  • 24 views

Forum|alt.badge.img+6

Hello,

 

I have repeater in my form and using workflow i am create a table out of xml. I have people picker field inside repeater, when i am creating table its is not giving the display name. How can i get the dispay name of that field.

 

 

4859i71BFB8EDF597438D.png4860i06863CB9269E140A.png4858i6920EA53DF774916.png

5 replies

Simon Muntz
Nintex Partner
Forum|alt.badge.img+23
  • Nintex Partner
  • October 3, 2019

Hi,
When you parse your XML put the account name that is output through a regular expression action with a replace. this will get rid of the claims tokens at the start. (Your input text will ofcourse be a variable and not the account as shown)

i:0#.w|

4861iCA09467AB57122C7.png

With the claims tokens removed you can now feed the output into a Query User Profile action to get the Name.

Now update your field as required.

 


Forum|alt.badge.img+6
  • Author
  • October 3, 2019
Hi Simon,

Can you please elaborate the solution, how can i put this into table[multiple line of text column in list]. I want the table structure like above.

Simon Muntz
Nintex Partner
Forum|alt.badge.img+23
  • Nintex Partner
  • October 3, 2019
Use my method to change from account name to display name and then update the XML node with the display name.
Then feed that into your Query XML action that does an XSLT transform.

Forum|alt.badge.img+6
  • Author
  • October 3, 2019
this has to be done using for loop?

Simon Muntz
Nintex Partner
Forum|alt.badge.img+23
  • Nintex Partner
  • October 4, 2019

Hi,

 

Yes this is done using a loop.

The workflow would look like this:

4870i1DBE5688B75BF1F4.png

 

Now the names in your XML will be Display Names and not Account names.

You can now feed the output of above into your Query XML action that creates the table.

 

I have attached my workflow to help guide you.  It will not work for you as you do not have my users in your userprofile service but you can see how I have put it together.