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....
- 21.1k
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
...
- 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 ...
- 451
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
- 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 .....
- 5,028
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 ...
- 45.1k
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/...
- 11.5k
31
votes
Sharepoint 2013 JS Link return default field rendering
'Text': {
'View': RenderFieldValueDefault,
'DisplayForm': SPField_FormDisplay_Default,
'EditForm': SPFieldText_Edit,
...
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....
- 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 ...
- 42.2k
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 ...
- 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¶meter2=yyy
var value=getQueryStringParameter('parameter1');
It is used in many ...
- 21.1k
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 ...
- 42.2k
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 ...
- 351
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.
...
- 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: ...
- 42.2k
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,...
- 226
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 ...
- 326
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 ...
- 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 ...
- 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 ...
- 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"
- 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 ...
- 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 ...
- 42.2k
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 ...
- 1,607
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 ...
- 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-...
- 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:
$...
- 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"....
- 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
- 9,536
Only top scored, non community-wiki answers of a minimum length are eligible