Last call to make your voice heard! Our 2022 Developer Survey closes in less than a week. Take survey.

Questions tagged [multiple-values]

A field or element containing more than one "item" of data. This can also be a property of code elements such as CAML queries that return more than one item.

Filter by
Sorted by
Tagged with
0 votes
0 answers
9 views

Conditional Required Field in SharePoint Online Library Validation Syntax Error

Goal I have a "Managed Services" Choice column with predefined choices displaying as Checkboxes (allow multiple selections). I want to make another column required based on the selection of ...
user avatar
0 votes
1 answer
301 views

Update multi-value lookup column with Flow

I have two list: Item List: contains beside the item name a column "item short" with a shortened string as our internal item registration text. Main list: used like an inventory list. The ...
user avatar
  • 129
1 vote
1 answer
182 views

How do you set sharepoint user field to allow multiple users with powershell

How do you set sharepoint user field to allow multiple users with powershell? Add-PnPField -List $RecordListName -DisplayName $fieldName -InternalName $fieldName -Type User -Required -...
user avatar
0 votes
1 answer
43 views

How to separate lookup column selected items with "X"?

I have a SharePoint Lookup column with multiple choices, as follows: Apple Orange Strawberry Watermelon How can I populate a different column by separating the choices with "X", as follows: ...
user avatar
0 votes
1 answer
98 views

Sharepoint multiple checkbox selection inverted

In my Sharepoint Online list I have a column formatted as multiple checkbox selection. It works as it should, when I click on some checkbox it is showed on the list. However, I would like to have a ...
user avatar
  • 1
0 votes
1 answer
1k views

Parse JSON elements of a list returned from a multi-choice column in Power Automate/MS flow

I am calling the SP API to get the version history of an item in my list as follows: _api/web/lists/getbytitle('@{triggerBody()?['SPListName']}')/items(@{triggerBody()?['SPListID']})/versions?$top=20 ...
user avatar
0 votes
1 answer
83 views

Lookup Column with Multiple Values creates Multiple Records

I have a field in my infopath form which allows a user to select multiple offices for a user to have access to. This infopath form feeds a sharepoint list where processors can work requests for ...
user avatar
1 vote
2 answers
21 views

Unable to save all users into SharePoint list

I am creating a list item using the code below: var context = new SP.ClientContext.get_current(); var dfd = $.Deferred(); var targetList = context.get_web().get_lists().getByTitle(listName); ...
user avatar
  • 320
1 vote
1 answer
804 views

Sharepoint Lookup Column with Multiple Display Vertically

I'm using a SharePoint lookup column that has a multi-select choice field. When 2 or more values are selected for an item, it is displayed in the view like this: Value1;Value2;Value3;Value4;Value5;...
user avatar
0 votes
1 answer
1k views

How to update the people and group column with multiple values in SharePoint

I have a person or group column in SharePoint 2013 I want to set the multiple values I have set its value like 1;#pallavi it's working but when done for multiple values like 1;#pall;#2;#shee it's not ...
user avatar
1 vote
0 answers
36 views

Assigning multiple users to a workflow task

In a SharePoint 2013 workflow - I have an initiation Parameter called "Reviewer" this is a Person or Group type and it is set to allow multiple values. I have the task participants set to the ...
user avatar
0 votes
1 answer
126 views

Unable to retrieve data from multi-select “Choice” SharePoint control using listdata.svc

I'm able to connect to a SharePoint 2019 list using the listdata.svc service. Problem is, if the control for a column is of the "Choice" variety, with multiple selections allowed, the data stored in ...
user avatar
0 votes
1 answer
1k views

Cascading drop-down with Multi-select field

I am not very familiar with editing a SharePoint site but have been tasked with creating a tracking log of sorts. Currently, I have created two columns in the list for which I would like to relate to ...
user avatar
  • 1
2 votes
2 answers
2k views

Write multiple people in multi-value person field using PowerShell (CSOM)

I have a CSV file which contains semicolon-separated Values to a certain field: Reviewer domain\userOne;domain\userTWO In PowerShell (CSOM - executed on my local computer) I am grabbing this data ...
user avatar
0 votes
1 answer
676 views

How do I remove a blank checkbox option for a multiple choice column?

How do I remove a blank checkbox option for a multiple choice column type that allows multiple items to be selected? I am using SP Online. I created a list, with a multiple choice column type, with 3 ...
user avatar
0 votes
1 answer
74 views

how to get cascading drop down values from two child columns

I have a cascading drop down where if I select a value from the parent column, I want the child column to be populated with values from two potential matching columns in the relationship list (i.e two ...
user avatar
0 votes
1 answer
283 views

SP2013 Delimited values to other columns

Here's an interesting one: I have a list where one text column accepts multiple delimited values. (By that, I mean multiple values separated by delimiters.) Is there a calculated feature where I ...
user avatar
  • 144
1 vote
1 answer
384 views

Auto populate a lookup field with multiple entries after selecting multiple entries from a lookup

Please excuse me for the vaugness, required due to the type of work. I have a list that indicates upcoming work on various items. When the work is finished on those items, drawings need updated. As ...
user avatar
0 votes
2 answers
843 views

update multichoice column using powershell CSOM

how do can we update multichoice column using powershell csom ? we need to update multichoice column for a list any help would be appreciated
user avatar
  • 473
3 votes
1 answer
4k views

column formatting with json for lookup fields

I have problems formatting the column of a lookup field with json. Precisely, it is an additional field, displayed from the parent list that I want to format. The lookup field is of type multiple, so ...
user avatar
0 votes
1 answer
59 views

Layout - enlarge multi-value fields using designer

I changed an Edit Form in Sharepoint (included a script editor web part) to enlarge multi value fields list boxes (they were to small in width) and it worked (inserted code snippet). However, if i ...
user avatar
0 votes
1 answer
173 views

Form with Multiple Inputs from multiple users

I need to create a form with the following requirements: Needs to be able to accept multiple inputs from multiple users. Save as a draft while other users are still filling form throughout the day ...
user avatar
0 votes
1 answer
45 views

How to send a delayed notification email for multiple list items on the email

How do I send an email through sharepoint which contains a list of multiple values? Basically I want a list of only the items that are pending in the list to be displayed on the email. Here is what ...
user avatar
  • 145
1 vote
1 answer
662 views

Filter Lookup Multi-Select on previous selection

I have a Lookup Column called Region, and a second lookup column of type multi-select called Customer. I want to filter Customers column based on Regions selection. I found SPServices allows to ...
user avatar
  • 309
1 vote
0 answers
173 views

Column formatting for multi-choice field in SP Modern

Context: I'm working as a regular user consuming my company's modern Sharepoint deployment, so my capabilities are pretty limited other than what's available from the GUI. I'm trying to format a ...
user avatar
  • 11
2 votes
1 answer
558 views

"Select All" functionality in Choice column

In SPO, I have a multi-select choice (check box column)column named "Geography" which lists different cities. I also added a choice to the "Geography" column named "Select All", when the value "...
user avatar
  • 1,450
3 votes
1 answer
25 views

Mutliple Workflos nsted for an Item?

I am currently stuck. I have a form library with multiple days equaling different values. All the columns that I'm using are extracting information from the submitted form. I'm trying to have an ...
user avatar
1 vote
1 answer
2k views

People picker allow multiple selection

I have a custom InfoPath form with Subordinate people picker field where I have to put multiple users to take an action. people picker field accepts only one single value. From the properties i check ...
user avatar
  • 135
0 votes
1 answer
21 views

SP2013 Document Library: multiple value lookup and group by based on the values selected

SP2013 environment here. I have a document library that will need to have Manufacture Column (A,B,C .. etc) and a Model Column (Based on Manufacture Column), (like A1, A2, A3, B1, B2, B3, etc) The ...
user avatar
0 votes
1 answer
473 views

Using html buttons to check/uncheck multiple selection checkbox choice field on edit form in SPO

USE CASE I want each one of the (3) users -- Marty, Reggie, and Rust -- to be able to click a button in order to dynamically place a check mark on a multiple selection CHOICE field on the Edit Form. ...
user avatar
2 votes
1 answer
111 views

How to set MultiLookupField in Workflow 2013 [duplicate]

I'm working on SharePoint 2016 OnPremise, Workflow 2013 and I'm trying to set a MultiLookupField with one ore more values. I tryied to set 1;#2;#3;#4 and 1;#;#2;#;#3;#;#4, or for one single item 1;#;# ...
user avatar
  • 1,176
1 vote
1 answer
760 views

Adding to Multi-Value Lookup Column via PowerShell (SP 2013)

Is there any way via PowerShell to add data to a multi-value Lookup column instead of overwriting it? For example, the item already has stuff checked off in the Lookup column. Values 1 and 2 are ...
user avatar
1 vote
1 answer
48 views

Add multiple IDs to multiuser user textbox

I've a sharepoint list with a user field called "Account". In a sharepoint page I've added a textbox bound to this field and I managed to set the value by inserting the USERID in the textbox. Here ...
user avatar
  • 43
1 vote
0 answers
451 views

Unable to save multi taxonomy field value via RESTapi

I have a very peculiar problem. I am updating a list with a multi-value taxonomy field via REST on a SharePoint hosted app. Other list fields are being updated apart from this one multi-value taxonomy ...
user avatar
1 vote
0 answers
136 views

Survey with multiple selections per matrix row and two qualitative axes (words instead of 'rating scale')

As per picture example, I have some categories that are sufficiently closely related as not to warrant individual multiple choice questions for each row (that would lead to a lot of repetition, and ...
user avatar
6 votes
1 answer
531 views

Office 365 Security & Compliance Content Search not finding Keyword if among multi-selected Lookup column

Setup: I created the following: a list (named Category) at the top-level site, a Lookup site column (SC) (named Category) on Category, which allows multiple selections, and a Document-based content ...
user avatar
1 vote
0 answers
34 views

How do I create a view that groups by a person when the task has multiple people assigned?

I have a task list linked to MS project which links fine. However my SP13 list has two columns for different resource/people. Both people are working on the same particular project, but may be ...
user avatar
  • 11
1 vote
0 answers
28 views

Multiple Content Types Duplicating Values in Calculated Column when updating CT

List Setup I have a list setup with 3 content types. Content Type A, Content Type B, Content Type C The list has 3 choice columns setup for each content type. This enables the choices available to ...
user avatar
1 vote
0 answers
118 views

How to group multiple variables on lookup column?

I want to separate multiple rows. How can i do this with another web part listview or programmatically?
user avatar
  • 641
3 votes
1 answer
2k views

Can i group documents by using lookup column with multiple value?

One document belongs to many row. It is allowed . But I want to group them and show the document on each group. Is it possible ?
user avatar
  • 641
3 votes
1 answer
2k views

Calculated Column checking against a multi-selection lookup

FieldA is a lookup (to another SP list) with the option to select more than one choice from 9 options: let's call them 1 thru 9. FieldB needs to be a calculated field that evaluates FieldA. Certain ...
user avatar
1 vote
0 answers
26 views

Add Data Source Links to InfoPath from SP 2013 Data Source with Multiple Rows of Values & URLs

I have six organizations with custom SharePoint 2013 Product libraries that contain four folders labeled as Q1, Q2, Q3, Q4. Then I have a SharePoint custom list with one Title and one URL column. The ...
user avatar
  • 11
2 votes
1 answer
1k views

Convert a column from text to choice(checkbox)

I need to upload (edit: currently trying via import spreadsheet) a table from excel where one of the columns needs to be a multiple choice selection field. By adding a ";" separator into the excel ...
user avatar
  • 1,022
1 vote
0 answers
36 views

Filtering Many-to-Many-to-Many

What I Need: I'm trying to use OOTB features, with as little custom rendering / SPFx / customization as possible. I've got 3 list: Members, Classes and Sponsors. Each Member may be in many classes, ...
user avatar
  • 123
1 vote
0 answers
169 views

SharePoint Powershell - Update MultiValue MMD

I am trying to update multiple values to a managed metadata field in sharepoint library. Below is my code which works for single item $MMSField = [Microsoft.SharePoint.Taxonomy.TaxonomyField]$item....
user avatar
0 votes
2 answers
521 views

SharePoint set MultiLookup field using CSR and TypeScript

I am trying to set the value of a multi lookup field. I am rendering my field using CSR and using registerGetValueCallback to get the value of my lookup field. But the value of my field does not ...
user avatar
1 vote
1 answer
669 views

Email Multiple Recipients in Related List

I have a discussion list, and a categories list. In the Categories list, there's a column for Moderator, which is a Person or Group. In the Discussions list, the column for Categories Allows ...
user avatar
  • 41
0 votes
1 answer
476 views

SharePoint 2010 Custom List Validation - Two Columns, Nested IF()?

I have a custom SharePoint 2010 List that I am attempting to perform list verification on. I have searched Google, Microsoft, and Stack however I can't seem to wrap my head around how to perform the ...
user avatar
0 votes
1 answer
310 views

When using GetDataTable() to retrieve the list data, the multiple value enabled people picker values are not correct

I was using GetDataTable() function to get the list data from a list "Orders". Orders table has a multiple enabled people picker. When the data table is selected, the people picker value(PersonOne; ...
user avatar
0 votes
2 answers
591 views

Inserting multiple AssignedTo in a task list

I'm trying to insert a new task in a standard SharePoint task list, this is my item: var item = { Title: taskTitle + " - " + subSiteName , ProjectId: projectID, AssignedToId: {'results': ...
user avatar