5 votes

How to add null value to lookup column using REST

Just do not specify lookup column in request body or set lookup value to null { "__metadata": {"type": "SP.Data.[List Name]ListItem"}, "Title": "[Title]", "[Internal Name of lookup the column]Id": ...
Atish Kumar Dipongkor's user avatar
4 votes
Accepted

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

Try with this {|ManagedProperty:{QueryVariable}} Query would be something like this {|RefinableString00:{"White"‎}} LINK Query variables with multiple values Query variables can contain ...
Marko Tica's user avatar
  • 2,557
4 votes
Accepted

Trying to filter values to a People or group field that has multiple values. Tried Both CAML and REST

You could construct the following CAML query to return only the Teams that the current user is a member of: <Or> <Membership Type=\"CurrentUserGroups\"> <FieldRef Name=\"...
Vadim Gremyachev's user avatar
3 votes
Accepted

filter on multichoice column

Without fully knowing your list data structure, I'm thinking your query string should be formatted along the lines of : <Where> <Or> <Contains> <...
Fairfield's user avatar
  • 612
3 votes
Accepted

Extract all lines from multiline item

Your list has versioning turned on. Also the multi line field has "Append only changes" setting enabled. So thats why you are getting only the latest value in the field. Try with below code: $Web = ...
Gautam Sheth's user avatar
  • 30.9k
3 votes
Accepted

Calculated Column checking against a multi-selection lookup

Unfortunately, The Lookup fields can't be used in Column and List \ Library validation or Calculated Column. Check THE SUPPORTED AND UNSUPPORTED COLUMNS IN SHAREPOINT CALCULATED COLUMN FORMULA The ...
Mohamed El-Qassas MVP's user avatar
3 votes

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

You'll need to read the existing items and store them in a variable. For multi-values fields you'll want to SPFieldLookupValueCollection instead of SPFieldLookupValue. It's essentially an array of ...
Derek Gusoff's user avatar
  • 7,986
3 votes
Accepted

"Select All" functionality in Choice column

$(document).ready(function () { $("span[title='SelectAll'] input").click(function (event) { //on click $("input[id^='Geography_']").prop("checked", this.checked); }); }); This ...
Ariwibawa's user avatar
  • 303
1 vote

People picker allow multiple selection

It might be that the list that this infopath form is connected to doesn't have "allow multiple selections" activated. Open settings for your list select the people picker field you created in ...
GettingPwnedBySharePoint's user avatar
1 vote
Accepted

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

Sample script for your reference(not complete, I believe you can achieve base on sample script). Insert script editor webpart to edit form and then insert the script to script editor web part. <...
Lee's user avatar
  • 4,271
1 vote

SharePoint set MultiLookup field using CSR and TypeScript

Great to hear you solved it.. FYI, since you have TypeScript in your question/tags this: let value = []; if (contracts.length > 0) { contracts.forEach((c) => { let val = new SP....
Danny '365CSI' Engelman's user avatar
1 vote

sharepoint search multi value managed property

ContentTypeId:0x0... AND (owstaxIdLocation:"GP0|#GUID" OR owstaxIdLocation:"GP0|#OtherTermGUID") Or don't use owstaxIdLocation. Search crawled properties for ows_Location or whatever your column is ...
Bunzab's user avatar
  • 1,680
1 vote
Accepted

Update multi-value lookup column with Flow

So as I understand your question, you want to update you choice column (and its a multivalue one) in Power Automate, but you only got the value and not the id of the lookup items? Why not just let ...
RuneBH's user avatar
  • 696
1 vote

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

Here is a sample of JSON formatting for multi-choice column to produce the expected result. { "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema....
Matiur Rahman's user avatar
1 vote
Accepted

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

Updating for [Send a HTTP..] request. Here [results] is an array, and [MyChoice] is also an array. body('Parse_JSON')?['d']?['results'][1]['MyChoice'][0]['Value'] Here's how I can find individual ...
Matiur Rahman's user avatar
1 vote

Sharepoint Lookup Column with Multiple Display Vertically

Try below JSON formatting on your multi-lookup column in list view to show data vertically: { "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json", "...
Dikesh Gandhi's user avatar
1 vote
Accepted

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

try the below URL, I have added code to expand the Multiselect field. https://YOURSITE/_vti_bin/ListData.svc/prodtest?$expand=Multiselect
Karthik Jaganathan's user avatar
1 vote

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

Your all code seems fine but you have not added "ExecuteQuery" after updating the field value and that's why it's not working! Try to change your last if statement with below: If ($...
Dikesh Gandhi's user avatar
1 vote

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

Try something like given below (not an exact code like you want. But you can get the idea from it how you can store the values in array and set it): #User Account to set $UserAccounts="Crescent\...
Ganesh Sanap - MVP's user avatar
1 vote

column formatting with json for lookup fields

Unfortunately, after looking into this further, you won't be able to properly work with mulit-value projected fields at this time. While the primary lookup value comes back as an array of objects with ...
theChrisKent's user avatar
  • 6,001
1 vote
Accepted

Filter Lookup Multi-Select on previous selection

You can check the code below for your reference: // (Newform.aspx, EditForm.aspx, or any other customized form.) $.fn.SPServices.SPCascadeMultiSelect = function(options) { var opt = $.extend({}, ...
Hellofiona_MSFT's user avatar
1 vote
Accepted

Removing name from Person/Group(Multiple value) with a designer workflow

I believe the key here is using Dictionaries (which are only available in SPD2013 workflows). The value of a multi-person field is treated by the workflow engine as a JSON object containing an array ...
Chris Odegard's user avatar
1 vote
Accepted

How to filter out empty item fields out from a looked up data source

Your own thoughts at the end would likely be the best answer. Lookup fields are SP's method of creating relational databases. Having a "master" lookup list is kind of counter-intuitive to how that ...
Jordan's user avatar
  • 334
1 vote

Filter a Multiple Selection List Box in Sharepoint

A workaround without developing is to activate the key filters (metadata navigation. You will need to activate the site collection feature : publishing, the site feature : publishing and navigate to ...
Jeff's user avatar
  • 81
1 vote

Create Multiple items with workflow (sp designer)

Yes we can create a second list as required. So the workflow goes this way: Start a task process/ Approval process -- And if the out come is Approved, then do the following: a. Start a loop with ...
Praneeth K's user avatar
1 vote
Accepted

SP2010 Add/Update multi-select lookup column REST

Its sad this was never answered here. But for the lurkers here it is. Adding selections to a multivalue lookup field using REST Here's the necessary format for your data payload: var data = JSON....
Joe Johnston's user avatar
1 vote

SSRS How can I create a Parameter to Filter on a SharePoint Multichoice Column

Step 1: Create a Parameter named Office Make sure you choose Text as the type and allow multiple values Create the available values: Name Value OfficeA OfficeA OfficeB OfficeB OfficeC ...
Amanda Matthews's user avatar
1 vote
Accepted

Better logic to create CAML queries

By using code from How to build a CAML query with several nested OR's using a loop and its answser https://sharepoint.stackexchange.com/a/167266/35604, you can easily simplify your code. Now you ...
Evariste's user avatar
  • 9,751

Only top scored, non community-wiki answers of a minimum length are eligible