How to create a choice field with more than 255 entries?

  • 16 January 2020
  • 3 replies
  • 2 views
N
Badge +1

Hello Everybody,

I am creating a nintex form for entries for a SharePoint list. The list contains several choice fields that work perfectly. Now I need to add another column with about 500 entries and I believe SharePoint choice fields are limited to 255 for single choice or 350 for multiple choice.

The source data is currently stored in an excel sheet. I do not have nintex workfows available by now.

Any ideas how to solve this? Can I somehow "read" from a second data source and then write the result in the SP list?

Thank you for your input.

Kind Regards,

Niran

3 replies

SimonMuntz
Userlevel 6
Badge +22
Hi,

I suggest adding the data to a SharePoint List and then using a List lookup control to look up the data.
Cool Nintex courses: https://learn.nintex.com/
N
Badge +1

Hi Simon,

thank you for pointing in the right direction. 

However, I still have some problems. I need to use a rule to get a value and I still need to get rid of "1,#" at the beginning of the returned value. 

6225iC109311455C6F740.jpg6226i26D3D5C2F43056E1.jpg6227i7CF670A2F599DA98.jpg6228i29E810AB7D6F92BD.jpg

The list lookup value is from SP list #2, the first UI a label using test variable, the lower UI test short connected to target column in SP list #1.

Do I actually need a rule? Essentially I only want to grab the value of a specific column from SP list #2 and write in the same column in SP list #1 because the number of choices is larger than 255. 

 

Thank you for help,

Niran

N
Badge +1

Hi,

Ok, some progress. In the above mentioned settings I mixed up the list, this is correct now. I am just struggling with the formatting now. 

When I use "parseLookup" I can write the correct value in a variable but I can't write it in the SharePoint list. 

Essentially all I want to achieve now is to write a value of a variable in the new entry of a SharePoint list.6247i0E91206277B914EB.jpg6248iB4FDBC99BF6BC0DF.jpg6246i16CB769E3AF46A6A.jpg

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings