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.
2
votes
0answers
18 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
0answers
29 views
external data source filter with multiple values
I've an external list with data from a SQL database.
I got some IDs (by querying a custom list) and want to get all items of the external list where those IDs match. The external list is very large so ...
0
votes
1answer
60 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
88 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. ...
0
votes
0answers
17 views
Multi-valued external data - picking specific value
I have an external lookup column that looks up unique project numbers. Each project number has one or more authors associated to it. My problem is that, when dealing with multiple authors, the lookup ...
2
votes
1answer
27 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
56 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
212 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
40 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
194 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
157 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
77 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
359 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
413 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
16 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
342 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
25 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
95 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
284 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
428 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
246 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
140 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
189 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
737 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
494 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
812 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
336 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
100 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
833 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
74 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
447 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
559 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
69 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
79 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
481 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
104 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
487 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
182 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
869 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
323 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 ...
11
votes
1answer
40k 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:
...
1
vote
1answer
1k views
Clear multi-value lookup via Jquery SP 2013
I am trying to clear a multi value lookup field using javascript when an item is re-edited.
I have tried all the following combinations without success
$("input[id^='Test'").removeAttr();
$("input[...
