Skip to main content
Nintex Community Menu Bar

People Lookup (multiple values) exporting to excel

  • September 12, 2019
  • 1 reply
  • 14 views

When I export my nintex form list to excel, the values in the people lookup fields come back as this: lastname, firstname MI;#10841.... I have been reading over things on google for the last 3 hours and cant seem to find a way to fix this. If it helps, the people lookup brings is set to show the name with presence.

I have another people lookup field that only allows for single values so I know it's got something to do with the multiple values but please help!

1 reply

Simon Muntz
Nintex Partner
Forum|alt.badge.img+23
  • Nintex Partner
  • September 13, 2019
Hi,
I do not think there is much you can do about how SharePoint exports to Excel.
One thing you can do is cleanup the excel sheet by using FIND and REPLACE functions.