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.
1
vote
1answer
49 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 ...
1
vote
0answers
11 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 ...
2
votes
1answer
39 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 "...
3
votes
1answer
23 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 ...
0
votes
1answer
122 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 ...
0
votes
1answer
17 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 ...
0
votes
1answer
126 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. ...
2
votes
1answer
31 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;#;# ...
0
votes
0answers
67 views
SharePoint Create a List with Multiple Selection Items that Include Sub Lists
Here is the situation,
I got tasked to create something in O365 (exclusively) that would allow people to request help from a coach. The system has to match the person with a coach according to many ...
0
votes
1answer
239 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 ...
1
vote
1answer
42 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 ...
1
vote
0answers
209 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 ...
1
vote
0answers
21 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 ...
6
votes
1answer
175 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 ...
1
vote
0answers
30 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 ...
1
vote
0answers
22 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 ...
1
vote
0answers
85 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?
3
votes
1answer
455 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 ?
3
votes
1answer
494 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 ...
1
vote
0answers
18 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 ...
2
votes
1answer
392 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 ...
1
vote
0answers
27 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, ...
1
vote
0answers
102 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....
0
votes
2answers
322 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 ...
1
vote
1answer
463 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 ...
0
votes
1answer
264 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 ...
0
votes
1answer
150 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; ...
0
votes
2answers
220 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': ...
0
votes
1answer
806 views
Extract all lines from multiline item
In our Sharepoint 2010 site, I've created a list with a multi line column. I try to extract all lines from this field but receive only the last entry. This field is used to put comments of users:
$...
0
votes
2answers
544 views
sharepoint search multi value managed property
I'm working on Sharepoint 2013 and I have a site column named Location tied to a taxonomy, you will have the corresponding managed property to query against: owstaxIdLocation.
I want to create two ...
3
votes
2answers
844 views
Trying to filter values to a People or group field that has multiple values. Tried Both CAML and REST
I have a list called Teams that has 2 columns, 'Title' and 'Team Members'.
Team Members is a Person or Group Field that allows multiple values.
There are 3 Teams defined in the list with multiple ...
1
vote
1answer
360 views
Removing name from Person/Group(Multiple value) with a designer workflow
I have a list where I store groups that are required to fill up a form, and every group has his user list stored in a Person/Group field with multiple values enabled. What I want to do is a workflow ...
1
vote
1answer
107 views
How to filter out empty item fields out from a looked up data source
Situation
Look up SharePoint list has several columns.
Each column is to be used as a look up data source for a drop down or multiple-selection list box (the exact control type is irrelevant) in an ...
3
votes
2answers
937 views
How to add null value to lookup column using REST
I have Custom list in which i have one Multi lookup column in that user select data from front end then i have to add that data in lookup column.
But if user not select any data then i have to add ...
0
votes
2answers
76 views
Multi field validation in custom list - code not working
I have a custom list with JavaScript to toggle the choice field. I now need to validate the fields according to the selection. My code below throws and error - incorrect syntax.
=IF([Red_Blue]="Red",
...
2
votes
1answer
483 views
SP2010 Add/Update multi-select lookup column REST
I have a list named CAG_QUESTION with a multi select lookup column to a list named CAG_REFERENCES. I have been unable to get an update to work that includes the lookup column. I thought I needed to ...
0
votes
1answer
583 views
Get Highest Value from Multiple Value Column
Currently using SP Online Office 365
For simplicity let's say my list has 5 columns, The Lookup Date is linked to the lookup title so it pulls through the corresponding date based which title/s were ...
3
votes
1answer
58 views
How to insert new item with multi users ids using batch element?
I am getting issue while creating a new item with multiselection peoplepicker field named multiusers with ids, i am trying below code for stringbatch
string strbatch="<Method ID='1' Cmd='New'>&...
1
vote
1answer
71 views
SharePoint InfoPath multiple selection box
I am using two multiple selection box in site using using InfoPath. I have kept one in a section. Based on particular item selection in the other, section is visible or hidden. I am able to hide ...
1
vote
0answers
81 views
SP Workflow- How to start approval workflow based on multiple conditions?
Here is an example of what I am trying to do. I have the following list-
List 1
Course-----Approver_Group---Approver_Level
Course_1----Group_A------------Level1
Course_1----Group_B------------Level2
...
0
votes
1answer
1k views
SSRS How can I create a Parameter to Filter on a SharePoint Multichoice Column
I am using a SharePoint list as my data source for an SSRS report. I have a multi-choice column named "Office". When a task applies to an office we check the box. Most of the time a task applies to ...
2
votes
0answers
516 views
create a view that groups multi choice column values
I apologize in advance if I am breaking rules by asking a question similar to one already asked (SP2013 - Create a view that groups based on individual selections in a multi choice field). I can't ...
2
votes
0answers
113 views
Can we restrict to overwrite field value in document library sharepoint 2013
In Sharepoint 2013 document library from Library Setting > Advance setting and edit the template and added columns from Insert > quick part for reusability.
Now when i am creating new document. In ...
0
votes
1answer
45 views
Tracking multiple list entries for individual users
I have a training registration list in SP2013 for one training session that is offered every month. Users can sign up to attend multiple times (for example, if they were on leave and/or need a ...
1
vote
0answers
499 views
HTML Form WebPart as filter with multiple connections and empty fields
I've got a HTML form WebPart that has multiple connections (Done in SPD) to the adjacent WebPart displaying a document library. It's 3 select boxes, and provided you select an option for all of them, ...
1
vote
2answers
186 views
Better logic to create CAML queries
Assume i have 3 checkboxes in my webpart Properties. Checkboxes are for selecting categories.
In my SharePoint list i have multichoice column called category and values in it are CAT1,CAT2 and CAT3
...
2
votes
1answer
930 views
filter on multichoice column
In my list i have multichoice column... How to filter on it programatically..
I know to filter based on text column like below
SPList oList = oWebsiteRoot.Lists["mylist"]; // list_name
SPQuery ...
2
votes
2answers
2k views
Putting a multiple choice checkbox in a workflow in Sharepoint Designer 2013
I have a column in my SP which asks if 3 things are done and a checkbox for each. Once all 3 are checked as being done, I'd like an email sent to certain people in my Workflow. I don't understand how ...
3
votes
0answers
338 views
Is it possible to perform Inner Join with Lookup Multiple Value Field?
I use CAML Query to perform inner join between two lists. It works when the lookup field is single value. However, when this field is multiple value, it always throws error:
the value does not fall ...
12
votes
1answer
43k views
Rest API - $filter multiple values
Assuming there is a list of Students each with a zip-code, how can I get records for multiple (but not all) zip-codes.
When using $filter how do specify multiple values?
Here's what I have so far:
...
