28

As far as I know, you can not use &. You have to use and or or inside the filter. So try using something like that: /_api/web/lists/getbytitle('Students')/items?$select=Title,ZIP&$filter=((ZIP eq 12345) or (ZIP eq 22222)) I always use brackets because of the readability, but you can also use it without brackets. items?$select=Title,ZIP&$...


11

There is a special element which is intended for use with multiple lookup fields: http://msdn.microsoft.com/en-us/library/ff630172.aspx Includes Element (Query) If the specified field is a Lookup field that allows multiple values, specifies that the Value element is included in the list item for the field that is specified by the FieldRef ...


10

I'm hoping your question was for a multi-select choice field, where the entries are simply text, not referring items in another list. I was able to guess the answer from this microsoft article If you look under the ListItemCollection resource for "POST request example: Create list item" they show the following: method: "POST", body: "{ '__metadata': { '...


6

here's a code fragment that's similar but 'list.Items.Add() & item.Update()' are missing from your code SPList list = SPContext.Current.Web.Lists["testlist"]; SPListItem item = list.Items.Add(); SPFieldLookupValueCollection fieldValues = new SPFieldLookupValueCollection(); fieldValues.Add (new SPFieldLookupValue(1, "SomeValue1")); // add other ...


5

If you're trying to get cell data from Excel (or any other table source) into a SharePoint list's Checkbox column in Datasheet view, the values in each source field must be delimited with the semicolon and hash characters (;#). Each cell's data must also have a leading and trailing semicolon/hash pair. This last bit is counter any other delimiting style I've ...


5

You can set a MultiValue Managed Metadata field by creating a TaxonomyFieldValueCollection and add this collection to the field by using the SetFieldValue method. First get the managed metadata field A possible way ( there are more ways ) to do this is to get the field by id $field = $item.Fields | ? {$_.Id -eq $fieldId} $tf = [Microsoft.SharePoint....


5

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": null }


4

Don't forget to put "Id" at the end of your column name. For example: if your column name is 'AssignedTo' you have to put 'AssignedToId' Also make sure the ID's you are providing in the "results" array are int's and not strings.


4

There is no specific class for storing choice field value like in case of, for example, user field value in CSOM API. Since multiple choice field value is stored in string array, the following example demonstrates how to retrieve it: var list = ctx.Web.Lists.GetByTitle(listTitle); var listItem = list.GetItemById(itemId); ctx.Load(listItem); ctx....


4

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=\"Team_x0020_Members\"/> </Membership> <Eq> <FieldRef Name=\"Team_x0020_Members\"></FieldRef> <Value Type=\"Integer\"> &...


3

I ran into this before and came up with a solution that is not as clean as one would have hoped, but it worked for me, granted that it's a dirty trick/workaround and it's far from being perfect. I tested it in SharePoint 2010, but from what I can see from your description, nothing has changed in SharePoint 2013 (read: dealing with multiselection box in ...


3

I did not understand what is "multiple value lookup column from another field". I understood, also having consulted your previous question, that you want Multiple-Selection List Box on lookup field. It works for me. If you want help in particular problem, you should provide more details and in more clear terms how to reproduce it. Having created and ...


3

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 alternative solutions. If you can change the lookup field to choice field with static options, so go ahead to use the choice field instead of lookup field, the ...


3

Try with this {|ManagedProperty:{QueryVariable}} Query would be something like this {|RefinableString00:{"White"‎}} LINK Query variables with multiple values Query variables can contain multiple values, and by using the syntax {|ManagedProperty:{QueryVariable}} or {|{QueryVariable}} The expansion will be made using the OR operator, and there ...


3

$(document).ready(function () { $("span[title='SelectAll'] input").click(function (event) { //on click $("input[id^='Geography_']").prop("checked", this.checked); }); }); This is more to selecting element In jquery, what I've done here is finding element span with title "SelectAll" and attach a click event in input element inside that ...


2

I don't know a solution just a workaround: create a yes/no question for each selectable option so you can count 'yes' answers on those at the results page.


2

Lookup fields (which user extends) supports AllowMultipleValues. Then you can do: var multi = field is SPFieldMultiChoice || (field is SPFieldLookup && (field as SPFieldLookup).AllowMultipleValues); Same for Taxonomy


2

Update: I believe I answered 2 questions: the question in the title: "Can an InfoPath 2010 dropdown be populated by a SP List column with multiple choice values?" A: impossible in its original formulation "I have a list with a column that accepts multiple values (a "choice" type with checkboxes) and wish to display the same available choice options on ...


2

URL?FilterName=Column1&FilterMultiValue=Value1;Value2 This should work. Only issue is that I'm not sure on how to do it for lookup column (SP online, it might be cause).


2

I would go for NO, not actually possible unless you build your own custom field to merge from 2 lists and display the Union/Intersection of values with appropriate storage of data. Even so, you would have to deal with storing the lookup value (ID#Value) combination which could also generate improper lookup due to duplicates. There is another way to merge ...


2

Its should be $select=Collaborators/Title&$expand=Collaborators Example your URL should like http://yoursite/_api/web/lists/GetByTitle('Employee Details')/items("1")?$select=ManagerName/Title,FirstName,LastName,Position,Phone,Fax,PreviousCompany,Reference,BirthDate,Relocate,EmailAddress&$expand=ManagerName


2

Try this sample var call = $.ajax({ async: false, url: _spPageContextInfo.webAbsoluteUrl + "/_api/Web/Lists/GetByTitle('AppointmentInfo')/items" + "?$select=Id,Collaborators/Id, Collaborators/Title,Title" + "&$expand=Collaborators/Id", type: "GET", dataType: "json", headers: { Accept: "application/json;odata=...


2

Yes you can enable multi-select on a lookup field. Under 'In this column:' where you pick the column in the list you want, there is a check box for Allow multiple values.


2

Without fully knowing your list data structure, I'm thinking your query string should be formatted along the lines of : <Where> <Or> <Contains> <FieldRef Name='SeriousHarmQ1' /> <Value Type='MultiChoice'>Loss of consciousness</Value> </Contains> <Contains&...


2

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 = Get-SPWeb http://sharepoint-host $list = $web.Lists["Demo list"] $query = New-Object Microsoft.SharePoint.SPQuery $query.RowLimit = 10 $query.Query = '<...


2

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 SPFieldLookupValue objects. Once you have the existing values, just call the field's .Add() method to add the new entry. Here's some samples using ...


1

Do your InfoPath form controls for the lookup columns still exist as "multiple-selection" boxes instead of "list" boxes? This is what the part of the error that says "You may need to add or modify your form view to add or remove the updated fields" refers to.


1

It seems the only way to do this is to use the Calculated column as the column default value and have folder level defaults overwrite that column level default as necessary. It seems there is not a workaround if you need multiple defaults on a multi-choice column.


1

REST will (by default) only supply you with a link-tag to the "Adminbrukere"-list. You will have to expand the link of the lookup content with the following in order to be able to access the nested data. AddQueryOption("$expand", "Adminbrukere")" The resulting query will be something like the following: IEnumerable<BrukereItem> result = null; ...


1

I see what you are trying to do but there is an easier way than using Linq: if(item["Adminbrukere"] != null) { string [] choices = item["Adminbrukere"].ToString().Split(new string[] { ";#" }, StringSplitOptions.RemoveEmptyEntries); for (int i= 0; i < choices.Count(); i++) { string choice = choices[i].ToString(); } }


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