Skip to main content
Nintex Community Menu Bar

Convert Sharepoint List Column Data with Nintex Workflow?

  • September 11, 2018
  • 5 replies
  • 10 views

Forum|alt.badge.img+4

Hello Again!

So I have a SharePoint list with a Nintex Workflow.  In one of those columns is data from a multiple checkbox option for branches.  Is there a way to parse that data and create a new column in said list that shows the branches so when it is exported to Excel it can be sorted by the branch even when it might have more than one branch?

Thanks,

Carrie.

5 replies

Forum|alt.badge.img+8
  • September 11, 2018

I'm just curious why you are exporting to Excel?


Forum|alt.badge.img+4
  • Author
  • September 11, 2018

Roger,

They want to analyze the data for something lol.

Carrie.


Forum|alt.badge.img+8
  • September 12, 2018

Is there a reason they cannot analyze it directly in SP? These are questions I always like to ask because sometimes the user doesn't realize the full capability of SharePoint. They often think of it as a glorified file share.


Forum|alt.badge.img+4
  • Author
  • September 12, 2018

Some folks just like to take the data offline and analyze and do other things outside of the list. They know it isn't a glorified file share wink.png


Forum|alt.badge.img+8
  • September 13, 2018

Sorry, didn't mean to imply that yours did! Just speaking in general.

I suppose you could create a calculated column for each branch, and if your choice columns contains the branch populate the individual branch field with the branch name.