Tag Info

Hot answers tagged

10

Go to Advanced Settings and Enable the Allow management of content types. Now you will see the content types associated with the list under the Settings section. Click on Item. Select the column. Check the Required radio button.


8

Works with double ' _api/Web/Lists/GetByTitle('St. John''s Calendar')/


8

I would suggest you create different content type or use the tagging feature to organize the items. Check this for the list of Pros and Cons http://social.technet.microsoft.com/wiki/contents/articles/16166.sharepoint-2013-using-folders.aspx Folder vs Metadata SPS 2013 search makes it easy to find worthwhile files and list items with or without any added ...


7

You can define this when you add a column in CAML via the ShowInNewForm and ShowInEditForm properties. You can find all the valid properties in the article Field Element (List) Alternatively, you can set these values using the object model (likely Powershell, since this is a one off run). The properties of the SPField object are the same (ShowInNewForm / ...


6

@PirateEric Sorry but this is untrue. Anyone who finds this as I did searching for a way to change the List URL of a SharePoint 2013 last can do so in Designer by following the steps outlined in this SO post: http://stackoverflow.com/questions/12904944/change-sharepoint-library-url Essentially: In SharePoint Designer just navigate to All Files navigation ...


6

If you're trying this for SharePoint 2013, change "LinkToItem" to "linkToItem" <ViewFields><br/> <FieldRef Name="Attachments"/><br/> <FieldRef Name="LinkTitle"/><br/> <FieldRef Name="linkThisColumn" linkToItem="TRUE"/><br/> <FieldRef Name="data_x0020_column"/><br/> <FieldRef ...


6

SP 2013 uses clienttemplates.js to create the those views control. You can either create a JSLink or add the following script using the script Editor webpart to the page where your list view resides. <script type="text/javascript"> ExecuteOrDelayUntilScriptLoaded(overrideSurfacePivotCount, 'clienttemplates.js'); function overrideSurfacePivotCount() { ...


5

Try the following script: $web = Get-SPWeb http://YourServer/ListLocation $list = $web.Lists["TheList"] foreach ($item in $list.Items) { if( $list.Fields.ContainsField("ddlTest") -eq $true) { $item["Number"] = Get-Random -Min 0 -Max 100; $item.Update(); } }


5

Modified: Identifies a field that contains the last modified date and time information that is associated with the specified SharePoint Foundation object. Last_x0020_Modified: Identifies a field that contains version control information for the last modified version of the specified SharePoint Foundation list object. The ‘Modified’ column as we see in the ...


5

Well you can hide it to appear on forms, go to List Settings -> Advanced Settings -> Allow management of content types -> check the box Now come back to List Settings -> Under Content Types -> Click Item content type -> Under columns -> click Title -> Hidden (check the box) Now it won't appear on the forms, you can similarly remove it from Views.


5

If you only want to hide the list from "All Site Content", the SPList class has a "Hidden" attribute. If you set this attribute to true, nobody will see the list via "All Site Content", but you can still access the list with the direct link. You could set the "Hidden" attribute with Powershell or a console application, for example (or do it at feature ...


5

The ClientRuntimeContext.Load method has the following signature: public void Load<T>( T clientObject, params Expression<Func<T, Object>>[] retrievals ) where T : ClientObject How to invoke ClientRuntimeContext.Load<T> method in PowerShell Invoke-LoadMethod function demonstrates how to specify retrievals parameter for ...


5

Make sure that the column you include in the where clause is defined as an indexed column in SharePoint. You can check by going to the list you're querying and into List -> Settings -> Indexed Columns. It's not applicable in your CAML query, but if you have more than one 'where', ensuring the first where hits an indexed column can increase efficiency. ...


4

Items will still be tagged as "New" even after they have been viewed. By default in SharePoint 2010, the "New" icon will continue to be displayed for 2 days. You can check the setting via Powershell: $webApp = Get-SPWebApplication "http://YourWebApp/" $webApp.DaysToShowNewIndicator You can change the "New" tag duration to 1 day as follows (or zero days ...


4

You're missing the WebId property: var xlv = new XsltListViewWebPart(); using (var oSite = new SPSite(" http : / / app:3333/ ")) { using (var oWeb = oSite.OpenWeb("/ProxymIT/Direction")) { var oList = oWeb.Lists["AdministrativeNotes"]; //your list name xlv.WebId = oWeb.ID; xlv.ListId = oList.ID; xlv.ViewGuid = ...


4

This will be a challenge to do through Workflows. The reason being we can't get the previous value to compare and confirm which field was updated. In such use cases we should use Event Receivers. It has AfterProperties and BeforeProperties. We can use those to compare and confirm whether the field updated is DaysLeft. If you prefer workflow's then before ...


4

This is a known issue with MS15-022 and the March 2015 CU. http://thesharepointfarm.com/2015/03/march-2015-cu15-022-task-list-filter-issue/ Simply add a Style (any will do, except the default one) to the View, and it will be resolved. Alternative option is to enable Server Render if displaying the Task List in a Webpart.


3

In addition to IAfanosov's solution, I've written a method to clear the recycle bin from all items that were deleted from the given list: /// <summary> /// Deletes all items from the recycle bin in a web that originally came from the given list /// </summary> /// <param name="sourceList">List where the items originated from</param> ...


3

here is powershell script to list all properties and then how to change them. # Load SharePoint library [system.reflection.assembly]::LoadWithPartialName("Microsoft.Sharepoint") # Connect to the site collection http://SP2010 and store the object in the $site variable $site = New-Object Microsoft.SharePoint.SPSite("http://SP2010") # Connect to the root ...


3

Get the web and list: $w = Get-SPWeb http://localhost $l = $w.Lists["My list"]; This is how you select the view "All items": $view = $l.Views | ? { $_.Title -eq 'All items' } Then just add fields: $view.ViewFields.Add($hereGoesFieldName); And update view: $view.Update();


3

You probably need to do this through REST services with SharePoint 2013 and create a new BCS connection to that database. REST exposes BCS with External Lists, and it's possible to write a new webpart page that facilitates the Tests, and displays the results whenever you click on the Test Name. How to create an External List: ...


3

The SharePoint boundaries document (http://technet.microsoft.com/en-us/library/cc262787%28v=office.14%29.aspx) states that a list can contain 30,000,000 items. The query threshold is 5,000 items per operation. By default, a list view will request only 30 items per page, which is well below the threshold. Unless you alter the views, you should not have any ...


3

It's the way SharePoint works, it only lets you add some specific columns(can't really remember which ones at the moment) as look-up columns, I had same issue few years ago, only solution I could find it that add a item adding event receiver and change Title column to file's name. There is no other way around I ever came across. Similar post: Lookup ...


3

SUMMARY This is maybe more complex than you may want, but it can be done. You also have a choice of using a hacky technique (read to the section break after the first code sample) or using the information in the first part to do some real work and re-create the item creation routine on your NewItem form. As a disclaimer, I'm assuming that you're using SP ...


3

Multi-choice field values are stored internally in ArrayList How to get multi-choice field values in PowerShell $web = Get-SPWeb $Url $list = $web.Lists[$ListTitle] $item = $list.GetItemById($ItemId) $values = new-object Microsoft.SharePoint.SPFieldMultiChoiceValue($item[$fieldName]) //print multi-choice field values for($i=0;$i -lt $values.Count;$i++) ...


3

As far as i understand your query, you can use following code: using (var site = new SPSite("http://yourserver/")) { using(var web = site.OpenWeb()) { var list = web.GetList("YourListUrl"); var dataTable = list.Items.GetDataTable(); // your code } }


3

The new page added in layouts folder "inplview.aspx". When paging, sorting or filtering happens there is an AJAX call to the inplview.aspx and it returns a JSON based result set. That is the rows of the defined list view webpart. The "inplview.aspx" generates the "inplviewhash" tag and appends it with "#" in url.


3

I think you mean that result item collection is empty: $itemsCollection = $list.GetItems($spQuery) if($itemsCollection.Count -eq 0) { Write-host " No results were found" }


3

It's not possible to change the outgoing e-mail address today, but it's a requested feature which may be implemented in the future. I guess you where just lucky receiving another outgoing e-mail adress, since the default is no-reply@sharepointonline.com.


3

If you neither want to use InfoPath nor Workflow, then you have to use SharePoint web services to fetch corresponding data in Column B for a selected value in dropdown Column B. You can achieve this functionality using SPServices library. Its a js library used to call SharePoint web services and perform operation very easily and in efficient way. You have ...



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