It might be difficult to search for an item in a SharePoint recycle bin. I was using the end point _api/site/RecycleBin as a Site Collection Administrator, but in some cases it returns an error « The attempted operation is prohibited because it exceeds the list view threshold. ». The solution is to use another end point _api/site/getrecyclebinitems […]
Étiquette : sharepoint
Connect to SharePoint Online using an app clientId and clientSecret
Get `clientId` and `clientSecret` (source) You’ll need credentials: `clientId` – required string, client id obtained when registering the addin `clientSecret` – required string, client secret obtained when registering the addin `realm` – your SharePoint Online tenant id. The easiest way to find tenant is to open SharePoint Online site collection, click Site Settings → Site […]
Pass an URL parameter to a SharePoint Online form’s field
The only way to pass a URL parameter to a SharePoint Online (modern design) form’s field is to use PowerApps (at least, if you cannot add any JS on your website!). Important warning: when you use PowerApps to manage your form, all edits to the list settings won’t reflect to the PowerApps form. For example, […]
Microsoft Sharepoint Migration Tool that works behind a proxy
It looks like the newer version of the Microsoft Sharepoint Migration Tool doesn’t accept to work behind a corporate network. A colleague has an older version (april 2020) that works correctly. Here is the link to download this version: SharepointMigrationToolSetup_April2020
Access to Sharepoint Online with Windows Explorer
If you want to access your Sharepoint online (https://[tenant].sharepoint.com), you first need to make sure the site is in the Trusted Website in Internet Explorer. Open Internet Explorer, navigate to the website, then open the Internet Options: Add your website to the Trusted Website zone: Next open Windows Explorer and right-click on « Your PC « , […]
Sharepoint error message « Invalid URL argument » with WebPartPages
For me the issue was this part of the XML request: <AddWebPart xmlns=’http://microsoft.com/sharepoint/webpartpages/’> (with a / at the end of the url) instead of <AddWebPart xmlns=’http://microsoft.com/sharepoint/webpartpages’>.
Sharepoint REST API to index a column or delete a column and more…
Due to the 5,000 items threshold limitation it can become very frustrating to administrate Sharepoint. For example, if your list has more than 5,000 items, you cannot add an index, delete a lookup/people column, delete the list or the website, and more ! Hopefully some of the operations can be done with REST API, and […]
SharePoint 2013 Search REST API options
Finding the documentation for the Search REST API of Sharepoint is difficult…. There is a very old blog post that I’m going to replicate here to give more visibility: Location of the Search Rest service The Search REST service is located at the following URI: http://host/site/_api/search The Search REST API The Search REST […]
SP.Utilities.Utility.SendEmail returns « The e-mail message cannot be sent. Make sure the e-mail has a valid recipient. »
With Sharepoint you can use SP.Utilities.Utility.SendEmail to send email in JavaScript, however you could receive the below error: « The e-mail message cannot be sent. Make sure the e-mail has a valid recipient. » After searching the web, I found the solution: instead of using an email address for the recipients you have to use the userDomain […]
Sharepoint DateRangesOverlap value
(this is a copy of a post that is not available anymore) DateRangesOverlap Value Type I don’t know if any back-end developers have run into this same issue when working with the SPQuery to pull expanded recurrence date, but from here, not all DateRangesOverlap Value types work the way they should. And they’re cryptically-documented, where […]