Skip to main content
Nintex Community Menu Bar
Question

Multiple Choice values from SharePoint list

  • April 28, 2023
  • 8 replies
  • 755 views
  • Translate

Forum|alt.badge.img+4

Is there a way to get Multiple Choice values from a SharePoint list?

Did this topic help you find an answer to your question?

8 replies

Garrett
Forum|alt.badge.img+16
  • Scout
  • 904 replies
  • April 28, 2023

Hi @Andrew87 

Can you clarify what you want to achieve?

Is this from a Form or using a Workflow?
Pls specify the platform (SharePoint, Form and Workflow) which you are using?

 

Translate

Forum|alt.badge.img+4
  • Author
  • Rookie
  • 21 replies
  • April 28, 2023

This of for a NWC Form. I have a SharePoint list of individuals that need to notified by phone for a specific event.  What I would like to do is bring in the names of these individuals that are in the SharePoint list column to be listed in a Multiple Choice Type action on a form. So you can check them off as you contact them.

Translate

Garrett
Forum|alt.badge.img+16
  • Scout
  • 904 replies
  • April 28, 2023

To clarify

SP: SharePoint Online
Form: NAC/NWC Start Event Form
Workflow: NAC/NWC

 

SP LIst: Events
Columns: Event_Name (Text Short/Single Line), Contact (People - Single or Multiple?)

Event Name Contact
Birthdays Larry
Birthdays Ms Lee
Weddings John
Weddings Mary

 

In your form, User would select an Event-type List (choice single) and this should populate the Contact List (choice multiple) - Is this right?
Then specify and use the Data Source in your form as cascading dropdown.

 

https://vimeo.com/798539701

 

Translate

Forum|alt.badge.img+4
  • Author
  • Rookie
  • 21 replies
  • April 28, 2023

The column in sharpeoint would is just a short text field. I would like to use the multiple choice drop down or a label with a Yes/No box in front of it to display each person we need to contact. 

 

 

Translate

Forum|alt.badge.img+4
  • Author
  • Rookie
  • 21 replies
  • April 28, 2023

This would allow individuals to update the SharePoint list instead of going into the nintex designer and updating the action.

Translate

Garrett
Forum|alt.badge.img+16
  • Scout
  • 904 replies
  • April 28, 2023

Wow! This is so much easier to build using O365 Form with List Lookups. 
Kind of struggling with NWC, haha!

 

SPO List - Event (Text Short), Contacts (Text Short)
This will be our lookup list. 

 

0365 Form

Events field setting

List Lookup (Event)

Contacts field setting

Notes - Text Long. Using Form rules to populate

Formula: replace( parseLookup([Form].[Contacts]), "," , "\n") 

 

Output
Just using “[Form].[Contacts]” 

Output (Final)

Use parseLookup function to clean up Lookup result.
Use replace function to replace comma with line break (“\n”)

 

PS - I haven’t figured out how to accomplish this with NWC form, yet

Translate

Forum|alt.badge.img+4
  • Author
  • Rookie
  • 21 replies
  • May 1, 2023

Thank you, I would need this on a NWC Form

Translate

Jake
Forum|alt.badge.img+13
  • Scholar
  • 319 replies
  • June 6, 2023

Hi @Andrew87 @Garrett 

 

Currently the only way to do this OOB with NAC forms would be to place the lookup inside of a repeating section, sadly we cannot rely on the nice and helpful APIs of sharepoint for this lookup.

 

HOWEVER forms plugins are now a thing and building a multiple select for this is actually possible now and I can make one, I will try put one together for you and share this with you as soon as it is ready.

 

Kind regards

Jake.

Translate

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie Settings