Skip to main content
Nintex Community Menu Bar

People Lookup (multiple values) exporting to excel

  • Sep 12, 2019 11:09 AM UTC
  • 1 reply
  • 24 views
  • Translate All

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
  • Sep 13, 2019 3:26 AM UTC
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.
Translate