Hot answers tagged

61 votes

How to use Today and Me in Calculated column

Update 6/2017: Do read: June 13th 2017 Microsoft blocked handling HTML markup in SharePoint calculated fields - how to get the same functionality back ## Calculated Column documentation: https://www....
user avatar
50 votes
Accepted

REST expand people column

Try AssignedTo/EMail....case sensitive. Available values from a user field (Source): Title Name EMail MobilePhone SipAddress Department JobTitle FirstName LastName WorkPhone UserName ...
user avatar
  • 696
45 votes

Cannot resolve Activity

Bit late to the show (well over a year!) but hopefully will help anyone who comes across this as I just did on Google! I had the problem when I copied and pasted activities in a SharePoint 2010 ...
user avatar
45 votes
Accepted

REST API OData Filter on Boolean not Working

Try using 1 for true, 0 for false. I was able to replicate your problem in SPO, but using 1/0 worked fine: /_api/web/lists/getbytitle('BtProjects')/items?$filter=Active eq 1
user avatar
  • 5,700
37 votes
Accepted

REST API filter by start and end dates using 'today'

Since your "today" variable is a JavaScript date object, you can get the string representation by calling the toISOString() method. ...$filter=StartDate ge datetime'" + today.toISOString() + "' and .....
user avatar
34 votes
Accepted

Is there a free version available in SharePoint 2016?

Unfortunately, there is no a frank alternative for SharePoint Foundation at SharePoint 2016. But you can still use SharePoint 2016 as a trial for 180 days using the following trial keys based on your ...
user avatar
31 votes

How to get List by Url using SharePoint 2013 CSOM

For those who are still looking for the answer. SharePoint 2013 (since SP1 at least see UPD below) contains special method Web.GetList. It accepts site-relative url for the list, i.e. site/dev/lists/...
user avatar
31 votes

Sharepoint 2013 JS Link return default field rendering

'Text': { 'View': RenderFieldValueDefault, 'DisplayForm': SPField_FormDisplay_Default, 'EditForm': SPFieldText_Edit, ...
user avatar
30 votes
Accepted

How to get List by Url using SharePoint 2013 CSOM

This seems to be pretty close in performance: context.Load(lists, all => all .Where(l => l.RootFolder.Name == "MyListUrl") .Include(l => l.Id)); context.ExecuteQuery(); list = lists....
user avatar
  • 2,798
29 votes

How to select and filter list items lookup column with Sharepoint 2013 REST Feature?

How to filter by lookup field value using SharePoint REST Assume a Contacts list that contains a lookup field named Province Option 1 Once a lookup column is getting added into list, its ID become ...
user avatar
29 votes
Accepted

SharePoint 2013 - Change URL of document library

When you create a document library, it ask you the name for the DL. Once you give it, it will create library with same name and URL. You can change the name of the library any time but cannot change ...
user avatar
  • 56.7k
28 votes
Accepted

What does this code getQueryStringParameter do?

It extracts one named parameter from the QueryString (URL) http://domainname.com/page.aspx?parameter1=xxx&parameter2=yyy var value=getQueryStringParameter('parameter1'); It is used in many ...
user avatar
26 votes
Accepted

REST with $filter for List Items in Sharepoint 2013

It does not seem possible to filter list items using FileSystemObjectType property in SharePoint 2013 REST. Option 1 But you could utilize the following REST query to return folders and associated ...
user avatar
25 votes

How do you hide "All Day Event" and "Recurrence" from Event content type?

No Code Solution (without Powershell and SharePoint Designer) to "hide Recurrence field" or "hide AllDayEvent field": go to list settings go to your event content type click on some field to edit the ...
user avatar
23 votes
Accepted

How to display more than three views in SharePoint 2013

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. ...
user avatar
  • 4,189
23 votes
Accepted

Sharepoint 2013 JS Link return default field rendering

The following templates define how User field is rendered in List Form pages. Single-valued user field: New: SPClientPeoplePickerCSRTemplate Edit: SPClientPeoplePickerCSRTemplate Display: ...
user avatar
21 votes
Accepted

Sharepoint Datepicker jumps to top in Chrome

Might have a slight flicker, but my solution will keep the scroll position of Chrome after you click on calendar icon (better than not having an answer since 2013 ^_^). At the bottom of your aspx page,...
user avatar
21 votes
Accepted

How can I change URL of existing list?

You can change the URL of a SharePoint 2013 List in Designer by following the steps outlined in this SO post: Change SharePoint Library URL Essentially: In SharePoint Designer just navigate to All ...
user avatar
20 votes
Accepted

How to use Today and Me in Calculated column

You cannot directly specify today and me in calculated column to set the values. You will have to create columns named Today and Me and then use it in your calculated column. Once you are done with ...
user avatar
  • 1,008
20 votes

What is causing this error :- Restore-SPSite : <nativehr>0x80070003</nativehr><nativestack></nativestack>

I got this error when trying to do Restore-SPSite on a SharePoint Farm that did not match the schema version of the backed-up Site Collection. After installing the correct CU to my target ...
user avatar
  • 301
19 votes

This product requires Microsoft .Net Framework 4.5

As mentioned by @jubblerbug, this can occur if you already have .NET Framework 4.6 installed before SharePoint 2013 (e.g. if you installed Visual Studio 2015 first). I couldn't use Microsoft's ...
user avatar
  • 5,941
19 votes
Accepted

how to get last ten item with REST API

For listing item in a particular order you should use orderby in the URL var queryGet = "?filter=Title ne 'reply'&$top=10&$orderby=Created desc"
user avatar
  • 28.2k
18 votes
Accepted

SharePoint 2013 Jan 2016 Updates

Apply the Cumulative Update for SharePoint 2013 (Foundation, Server, or Project). This should resolve the issue. This appears to be caused from applying MS16-004 while having a previous Cumulative ...
user avatar
  • 28.9k
18 votes

How to get List by Url using SharePoint 2013 CSOM

Yet another version to load List by server relative Url using CSOM. The solution consists of the following steps: Retrieve list Folder object using Web.GetFolderByServerRelativeUrl method Retrieve ...
user avatar
18 votes
Accepted

Save site as template in SharePoint 2013

Open you Team Site in SharePoint Designer 2013. In SharePoint Designer, under Sites tab select “Site Options” Find SaveSiteAsTemplateEnabled in Site Properties set to "true". Now in your Publishing ...
user avatar
17 votes
Accepted

Maximum characters in Multiple lines of text Column

Document libraries and lists have different options available with respect to the multiple lines of text column type. In document libraries, when you create a new column of type Multiple Lines of ...
user avatar
  • 5,953
17 votes

Reduce "noderunner.exe" impact

You should reduce it, and your farm will get benefit from it. Their is no impact rather you will get performance improvement. NodeRunner.exe is resource hungry process. their 3 step process: Use Set-...
user avatar
  • 56.7k
17 votes

REST API filter by start and end dates using 'today'

I answered the question here (not exactly a duplicate, since that was in regards to the Search REST API, and I happened to give an answer for basic REST). Here is how you filter dates in REST: $...
user avatar
  • 5,700
16 votes

Check users group membership via REST API using AD-Groups in SP-Groups

At least there is a workaround that will work fine (although I don´t like workarounds). You can set the group setting "Who can view the membership of the group" in SP-Group-Settings to "Group Members"....
user avatar
  • 679
16 votes
Accepted

Which webpart is that?

You can always add ?contents=1 to any url in SharePoint to see what specific webparts that are used in the site/page. Example: http: //test.sharepoint.com/Pages/default.aspx?contents=1
user avatar
  • 9,536

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