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.
131 questions
0
votes
0
answers
18
views
How to create Group By column that contains multiple values?
Need help on how to group by column that contains multiple values. Ideally for those with multiple values i would want to see the same files in each group.
Or if theres a way to embed a code?
0
votes
1
answer
339
views
Create multiple SharePoint list items from a single entry form (repetitive items)
I have a project where I need to track a document development process, sometimes different tasks are assigned to a single person, and multiple reviewers
The idea is for the form to capture all the ...
0
votes
1
answer
6k
views
Power Apps form with modern Table is not displaying values of multiselect choice fields
I added a modern table control to a Power App form. The table is connected to a SharePoint Online list, which only has some test data rows so far. The multi select choice fields which allow multiple ...
- 13
0
votes
1
answer
53
views
Filter SharePoint multiselect choice column via react query
I have a column in my SharePoint list, named "Catégorie", that is a multiple choice column, where I have multiple options "Option 1", "Second Option" etc.
How should I ...
- 133
0
votes
1
answer
138
views
How can I make sure a calculated value is unique within a sharepoint list
I have a list with different columns, those columns at the end output a final column that is calculated concatenating those column values.
I want to make sure that, when someone creates a new item in ...
0
votes
1
answer
114
views
Looking for a user-friendly way of bulk adding new keywords to a multiple-selection field, but without overwriting existing keywords
Basically, I'd like to take a list of items that already have tags applied to them like this:
Item
Keywords
Item 1
red, blue, green
Item 2
red
Item 3
blue, orange, purple
Item 4
green
The let the user ...
0
votes
1
answer
2k
views
PowerApps Form - Multi Select People Picker Field - How to split these values into two separate Text Labels
I have a PowerApps form (customized SP form), where I have a multi-select people picker field (Approvers) - The user may select up to 2 Approvers. I also have two text labels beneath it. I want to ...
- 507
0
votes
1
answer
51
views
SharePoine List Validation Issue
Good afternoon,
I have a list where based on what the user selects for a business line they are presented a choice field for activities related to that business line. A flow then populates a generic &...
0
votes
1
answer
3k
views
PowerApps SP Form - Multiple Attachment fields
I have a SharePoint list form (customized with PowerApps) in which I have a requirement for multiple attachment fields on one form. Basically my form has an Intake section, and 2 Approval sections - ...
- 507
0
votes
1
answer
1k
views
Power Automate - Send an email to multi-select people picker value(s)
I have a Power Automate flow that triggers when a Form (PowerApps) is submitted to sharePoint. One of the columns is a multi-select people picker (Other Approvers). So if the requestor wants to add ...
- 507
0
votes
1
answer
1k
views
Visible based on 2 different Data Cards
I have 2 Data Cards.
Updated the "Visible' property for my field to:
If(DataCardValue1.Selected.Value="New" || DataCardValue2.Selected.Value="Yes, true, false)
DataCard3 message ...
0
votes
1
answer
1k
views
How to write multiple conditional formula (39 conditions) for 7 columns in Sharepoint
first, I must thank you all for the tips for new people who want to learn more on SharePoint to optimize their business.
I'm trying to find a solution to write expanded conditional formula according ...
0
votes
1
answer
1k
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 ...
- 307
1
vote
1
answer
2k
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 -...
0
votes
1
answer
172
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:
...
0
votes
1
answer
458
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 ...
- 1
0
votes
1
answer
3k
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
...
- 465
0
votes
1
answer
134
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 ...
- 13
1
vote
2
answers
36
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);
...
- 332
2
votes
1
answer
1k
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;...
0
votes
1
answer
3k
views
How to update the people and group column with multiple values
I have a person or group column in SharePoint 2013, and I want to set multiple values. When I set its value like 1;#pallavi it's working, but for multiple values like 1;#pall;#2;#shee, it's not ...
1
vote
0
answers
60
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 ...
- 11
0
votes
1
answer
220
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 ...
0
votes
1
answer
2k
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 ...
- 1
2
votes
3
answers
3k
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 and ...
- 807
0
votes
1
answer
904
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 ...
0
votes
1
answer
148
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 ...
- 301
0
votes
1
answer
313
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 ...
- 164
1
vote
1
answer
568
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 ...
- 11
0
votes
2
answers
1k
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
- 503
4
votes
1
answer
6k
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 ...
- 41
0
votes
1
answer
76
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 ...
- 41
0
votes
1
answer
304
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
...
- 1
0
votes
1
answer
89
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 ...
- 145
1
vote
1
answer
803
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 ...
- 319
1
vote
0
answers
271
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 ...
- 11
2
votes
1
answer
729
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 "...
- 1,522
3
votes
1
answer
42
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 ...
- 31
1
vote
1
answer
3k
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 ...
- 135
0
votes
1
answer
31
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
1
answer
581
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. ...
- 123
2
votes
1
answer
193
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;#;# ...
- 1,199
1
vote
1
answer
1k
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
1
answer
90
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 ...
- 43
1
vote
0
answers
541
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 ...
- 11
1
vote
0
answers
202
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
1
answer
667
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 ...
- 470
1
vote
0
answers
44
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 ...
- 11
1
vote
0
answers
40
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 ...
- 11
1
vote
0
answers
127
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?
- 651