Is there a way to get Multiple Choice values from a SharePoint list?
Hi
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?
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.
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.
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.
This would allow individuals to update the SharePoint list instead of going into the nintex designer and updating the action.
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(oForm].oContacts]), "," , "\n")
Output
Just using “Form].gContacts]”
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
Thank you, I would need this on a NWC Form
Hi
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.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.