HTTP requests using the "When a HTTP request is received"

In Microsoft Power Automate, you can trigger flows based on HTTP requests using the "When a HTTP request is received" trigger. This allows you to create automated workflows that are triggered when an HTTP request is sent to a specified URL.

• Sign in to Power Automate: Go to the Power Automate website (https://flow.microsoft.com/) and sign in with your Microsoft account.
• Create a new flow: Click on the "My flows" tab and then click on "New" to create a new flow.
• Select the trigger: In the search bar, type "HTTP" and select the "When a HTTP request is received" trigger from the list of triggers.
• Configure the trigger: You will be prompted to specify a name for your trigger and define the schema for the HTTP request. You can define the schema manually or use the sample payload to generate the schema automatically.
• Generate the URL: Once the trigger is configured, Power Automate will generate a unique URL for your flow. This URL is where you will send your HTTP requests to trigger the flow.
• Build your flow: After setting up the trigger, you can add actions and conditions to your flow to define what should happen when the trigger is activated.
• Test your flow: Before you start using your flow in production, it's a good idea to test it to make sure it's working as expected. You can do this by sending a test HTTP request to the URL generated by Power Automate.
• Use the flow: Once you're satisfied with your flow, you can start using it in your applications or workflows by sending HTTP requests to the trigger URL.

Code in JQuery:

function RunPowerAutomate() { let flowUrl = "Paste the Generate the URL"; let req = new XMLHttpRequest(); req.open("POST", flowUrl, true); req.setRequestHeader('Content-Type', 'application/json'); req.send(data); }

CSOM vs JSOM vs SSOM vs REST

CSOM (Client-Side Object Model), JSOM (JavaScript Object Model), SSOM (Server-Side Object Model), and REST (Representational State Transfer) are different approaches or models used in SharePoint development for interacting with SharePoint data and functionality. Each has its own characteristics, advantages, and use cases. Here's an overview of each:

1. CSOM (Client-Side Object Model):

• Language Support: Primarily used with .NET languages such as C#.
• Execution Environment: Runs on the client side, usually within a .NET application.
• Usage: Ideal for scenarios where the code needs to be executed on the client side (e.g., in a Windows Forms application, WPF application, or a console application).

2. JSOM (JavaScript Object Model):

• Language Support: Primarily used with JavaScript.
• Execution Environment: Runs on the client side, typically in a browser.
• Usage: Well-suited for scenarios where client-side code (e.g., in a web page) needs to interact with SharePoint data and services.

3. SSOM (Server-Side Object Model):

• Language Support: Primarily used with .NET languages such as C#.
• Execution Environment: Runs on the server side, within the context of a SharePoint server.
• Usage: Typically used in scenarios where server-side code is necessary (e.g., in custom SharePoint server-side solutions, timer jobs, and event receivers).

4. REST (Representational State Transfer):

• Language Support: This can be used with a variety of languages, as it relies on HTTP and standard web technologies.
• Execution Environment: Runs on the client side or server side, depending on the implementation.
• Usage: Suitable for scenarios where a lightweight and language-agnostic approach is required. Can be used in web applications, mobile apps, or any scenario where HTTP requests can be made.

Key Points:

• CSOM and JSOM: Both are client-side models but are tailored to different development environments and languages.
• SSOM: Runs on the server side and is more suitable for server-side SharePoint solutions.
• REST: Offers a flexible and lightweight approach, making it suitable for a variety of scenarios and programming languages.

When choosing between these models, developers often consider factors such as the type of application, the development environment, and the specific requirements of the SharePoint solution being developed. Additionally, with the evolution of SharePoint and the emphasis on modern development practices, REST and client-side models like CSOM and JSOM are often preferred for their flexibility and compatibility with various platforms.

SharePoint Useful URLs for administrators and super users

This post serves as a valuable reference hub for all the handy shortcut URLs in SharePoint, streamlining tasks for administrators and super users.

While others have shared these URLs in various blog posts, I aim to safeguard them within my own blog, ensuring their accessibility for future generations!

Frequently used

Title	URL
Remove nav bar, header & command bar	?env=WebView (after .aspx)
Remove nav bar & header	?env=Embedded
Open list/ library in Microsoft Lists	?env=WebViewList
Site contents	/_layouts/15/viewlsts.aspx /_layouts/15/viewlsts.aspx?view=14 (old style view)
Manage content & structure	/_layouts/sitemanager.aspx
Audit log reports	/_layouts/Reporting.aspx?Category=Auditing
Shared with us	/Shared%20Documents/Forms/AllItems.aspx?view=3

Users and permissions

Title	URL
People	/_layouts/people.aspx
Groups	/_layouts/groups.aspx
Site Collection Admins	/_layouts/mngsiteadmin.aspx
Advanced Permissions	/_layouts/user.aspx

Galleries

Title	URL
Site Columns	/_layouts/mngfield.aspx
Site content types	/_layouts/mngctype.aspx
Web parts	/_catalogs/wp/Forms/AllItems.aspx
List templates	/_catalogs/lt/Forms/AllItems.aspx
Master Pages	/_layouts/ChangeSiteMasterPage.aspx
Themes	/_catalogs/theme/Forms/AllItems.aspx
Solutions	/_catalogs/solutions/Forms/AllItems.aspx

Site administration

Title	URL
Regional settings	/_layouts/regionalsetng.aspx
Content and structure	/_Layouts/sitemanager.aspx?Source={WebUrl}_layouts/settings.aspx
Content and structure logs	/_Layouts/SiteManager.aspx?lro=all
Site libraries and lists	/_layouts/mcontent.aspx
User alerts	/_layouts/sitesubs.aspx
RSS	/_layouts/siterss.aspx
Search and offline availability	/_layouts/srchvis.aspx
Sites and workspaces	/_layouts/mngsubwebs.aspx
Workflows	/_layouts/wrkmng.aspx
Workflow settings	/_layouts/wrksetng.aspx
Related Links scope settings	/_layouts/RelLinksScopeSettings.aspx
Content Organizer Settings	/_layouts/DocumentRouterSettings.aspx?Source=settings.aspx
Content Organizer Rules	/RoutingRules/Group%20by%20Content%20Type.aspx
Site output cache	/_Layouts/areacachesettings.aspx
Term store management	/_Layouts/termstoremanager.aspx
Taxonomy Hidden List	/Lists/TaxonomyHiddenList
Searchable columns	/_Layouts/NoCrawlSettings.aspx

Look and feel

Title	URL
Welcome page	/_Layouts/AreaWelcomePage.aspx
Title, description and icon	/_layouts/prjsetng.aspx
Master page	/_Layouts/ChangeSiteMasterPage.aspx
Page layouts and site templates	/_Layouts/ChangeSiteMasterPage.aspx
Tree view	/_layouts/navoptions.aspx
Site theme	/_layouts/themeweb.aspx
Navigation	/_layouts/AreaNavigationSettings.aspx

Site actions

Title	URL
Manage site features	/_layouts/ManageFeatures.aspx
Reset to site definition	/_layouts/reghost.aspx
Delete this site	/_layouts/deleteweb.aspx
Site web analytics reports	/_layouts/WebAnalytics/Report.aspx?t=SummaryReport&l=s
Site collection web analytics reports	/_layouts/WebAnalytics/Report.aspx?t=SummaryReport&l=sc

Site collection administration

Title	URL
Search settings	/_layouts/enhancedSearch.aspx
Search scopes	/_layouts/viewscopes.aspx
Search keywords	/_layouts/listkeywords.aspx
Site level recycle bin	/_layouts/RecycleBin.aspx
Site collection recycle bin	/_layouts/AdminRecycleBin.aspx
Site collection features	/_layouts/ManageFeatures.aspx?Scope=Site
Site directory settings	/_layouts/SiteDirectorySettings.aspx
Site hierarchy	/_layouts/vsubwebs.aspx
Site collection navigation	/_layouts/SiteNavigationSettings.aspx
Site collection audit settings	/_layouts/AuditSettings.aspx
Audit log reports	/_layouts/Reporting.aspx?Category=Auditing
Portal site connection	/_layouts/portal.aspx
Site collection policies	/_layouts/Policylist.aspx
Storage Metrics	/_layouts/storman.aspx
Record declaration settings	/_layouts/InPlaceRecordsSettings.aspx?Source=settings.aspx
Content type publishing	/_Layouts/contenttypesyndicationhubs.aspx
Site collection cache profiles	/_Layouts/RedirectPage.aspx?Target={SiteCollectionUrl}cache profiles
Site collection object cache	/_Layouts/objectcachesettings.aspx
Content type service application error log	/Lists/ContentTypeAppLog
Site collection output cache	/_Layouts/sitecachesettings.aspx
Variations	/_Layouts/VariationSettings.aspx
Variation labels	/_Layouts/VariationLabels.aspx
Translatable columns	/_Layouts/TranslatableSettings.aspx
Variation logs	/_Layouts/VariationLogs.aspx
Suggested Content Browser Locations	/PublishedLinks/
Document ID settings	/_Layouts/DocIdSettings.aspx
SharePoint Designer Settings	/_layouts/SharePointDesignerSettings.aspx
Visual Upgrade	/_layouts/suppux.aspx
Help settings	/_layouts/HelpSettings.aspx

Central administration

Title	URL
Manage web applications	/_admin/WebApplicationList.aspx
Create site collections	/_admin/createsite.aspx
Manage service applications	/_admin/ServiceApplications.aspx
Manage content databases	/_admin/CNTDBADM.aspx
Check job status	/_admin/Timer.aspx
Manage farm administrators group	/_layouts/people.aspx?MembershipGroupId=3
Configure service accounts	/_admin/FarmCredentialManagement.aspx
Configure send to connections	/_admin/OfficialFileAdmin.aspx
Configure content deployment paths and jobs	/_admin/Deployment.aspx
Manage form templates	_admin/ManageFormTemplates.aspx
Manage servers in farm	/_admin/FarmServers.aspx
Manage services on server	/_admin/Server.aspx
Manage farm features	/_admin/ManageFarmFeatures.aspx
Configure alternate access mappings	/_admin/AlternateUrlCollections.aspx
Perform a backup	/_admin/Backup.aspx
Restore from backup	/_admin/BackupHistory.aspx?restore=1&filter=1
Perform site collection backup	/_admin/SiteCollectionBackup.aspx
Convert farm license type	/_admin/Conversion.aspx
Check product and patch installation status	/_admin/PatchStatus.aspx
Check upgrade status	/_admin/UpgradeStatus.aspx

Common actions

Title	URL
Create new	_layouts/spscreate.aspx _layouts/create.aspx
View lists	_layouts/viewlsts.aspx
Create site groups	_layouts/permsetup.aspx
Quick launch	_layouts/quiklnch.aspx
Workflow history list	/lists/Workflow History
SharePoint server version + patch level	/_vti_pvt/Service.cnf (run at site collection level)
Web part maintenance mode	?Contents=1 (classic) ?maintenancemode=true (modern)
Save as site template	_layouts/savetmpl.aspx
Manage user alerts	_layouts/AlertsAdmin.aspx

REST API examples

Operation	SharePoint REST API endpoint
Site
Get a SharePoint Site Collection	[domain]/_api/site
Get a specific site or web	[domain]/_api/web
Get a sites title	[domain]/_api/title
List
Get all lists from a site	[domain]/_api/web/lists
Get all items from a list	[domain]/_api/web/lists/getbytitle(listname)/items
Get a lists title	[domain]/_api/web/lists/getbytitle(listname)?select=Title
Get all columns within a list	[domain]/_api/web/lists/getbytitle(listname)/Fields
Get list from GUID	[domain]/_api/Web/Lists(list GUID here)
Get list item by ID	[domain]/_api/Web/Lists/GetByTitle/(listtitle)/GetItemById(2)
Get selected fields for list items	[domain]/_api/Web/Lists/GetByTitle/(listtitle)/Items?select=ID,Title
User
Get current user information	[domain]/_api/web/currentUser
Get all site users	[domain]/_api/Web/siteusers
Group
Get all groups from the site	[domain]/_api/Web/siteusers/sitegroups
Get group by group ID	[domain]/_api/Web/sitegroups/GetById(GroupId)
Get all users from group	[domain]/_api/Web/sitegroups(Id)/users

Read File Content from SharePoint List Items

Working function, where you can read file content available as an attachment in your SharePoint list item.
#sharepoint #jquery #sharepointsolutions

     <div> <h1>Read File</h1> <div> <input type="file" id="file_input"> </div> <div> <div id="readfiletextarea" rows="5" style="width:400px;"></div> <a href="#" onclick="loadURLToInputFiled('https://domain.sharepoint.com/sites/Lists/myList/Attachments/1/myFile.csv')">Click to Load File</a> <br /> <a href="#" onclick="readfiledata()">Click to Read File</a> <br /> /*Read attachment data and display*/ function readfiledata(){ let input = document.getElementById('file_input') let textarea = document.getElementById('readfiletextarea') let files = input.files; if (files.length == 0) return; const file = files[0]; let reader = new FileReader(); reader.onload = (e) => { const file = e.target.result; const lines = file.split(/\r\n|\n/); textarea.value = lines.join('\n'); }; reader.onerror = (e) => alert(e.target.error.name); reader.readAsText(file); } /*Load URL to input type file */ function loadURLToInputFiled(url){ getURL(url, (fileBlob)=>{ // Load img blob to input // WIP: UTF8 character error let fileName = 'tmpfile.txt' let file = new File([fileBlob], fileName,{type:"text/txt", lastModified:new Date().getTime()}, 'utf-8'); let container = new DataTransfer(); container.items.add(file); document.querySelector('#file_input').files = container.files; }) } // xmlHTTP return blob respond function getURL(url, callback){ var xhr = new XMLHttpRequest(); xhr.onload = function() { callback(xhr.response); }; xhr.open('GET', url); xhr.responseType = 'blob'; xhr.send(); }

_sppagecontextinfo Get current user details

While using CSOM, we have mostly required some details of the current users, like, Name, Email, Title (Designation), Manager, etc., Following code, will help to know all this with simple API calls.

function GetCurrentUser() { //var requestUri = _spPageContextInfo.webAbsoluteUrl + "/_api/web/getuserbyid(" + userid + ")"; var requestUri = _spPageContextInfo.webAbsoluteUrl + "/_api/SP.UserProfiles.PeopleManager/GetMyProperties/"; var requestHeaders = { "accept" : "application/json;odata=verbose" }; $.ajax({ url : requestUri, contentType : "application/json;odata=verbose", headers : requestHeaders, success : onSuccess, error : onError }); } function onSuccess(data, request){ console.log(data); } function onError(error) { alert(error); }

Delete Files and Subfolders from SharePoint Library using PowerShell

Make life easy with PowerShell, following script will help you to delete all files and subfolders in One Go.

#Set-ExecutionPolicy -ExecutionPolicy RemoteSigned -Scope CurrentUser #Install-Module SharePointPnPPowerShellOnline #Config Variables $SiteURL = "https://mydomain.sharepoint.com/site" $ListName ="my_DocLib" $FolderServerRelativeURL = "/site/my_DocLib" Try { #Connect to PnP Online Connect-PnPOnline -Url $SiteURL -UseWebLogin #Get All Items from Folder in Batch $ListItems = Get-PnPListItem -List $ListName -FolderServerRelativeUrl $FolderServerRelativeURL -PageSize 2000 | Sort-Object ID -Descending #Powershell to delete all files from folder ForEach ($Item in $ListItems) { Remove-PnPListItem -List $ListName -Identity $Item.Id -Recycle -Force Write-host "Removed File:"$Item.FieldValues.FileRef } } Catch { write-host "Error: $($_.Exception.Message)" -foregroundcolor Red }

Sharepoint Online: Read user profile details.

Read current login user profile details in Sharepoint Online.

function getUserProfile(){ var urlString = _spPageContextInfo.webAbsoluteUrl + "/_api/sp.userprofiles.peoplemanager/GetMyProperties"; var call = $.ajax({ url: urlString, type: "GET", dataType: "json", headers: { Accept: "application/json;odata=verbose" } }); call.done(function (data,textStatus, jqXHR){ var Name = data.d.DisplayName; var email = data.d.Email; var oneUrl = data.d.PersonalUrl; var imgUrl = data.d.PictureUrl; var jobTitle = data.d.Title; var profUrl = data.d.UserUrl; }); call.fail(function (jqXHR,textStatus,errorThrown){ alert("Error retrieving Tasks: " + jqXHR.responseText); }); }//getUserProfile

Application lifecycle management (ALM) of SPFx Client Side Web Part

 

SharePoint REST API with fetch().then() and Ajax()

Using ajax

$.ajax({ url: "https://mysite.sharepoint.com/_api/web/lists/getbytitle('list')/items(" + id + ")", method: "GET", headers: { "Accept": "application/json; odata=verbose" }, success: function (data) { console.log(data.d.results); } });

Using fetch() and then()

payload = { method: 'GET', headers: { "Accept": "application/json; odata=verbose" }, credentials: 'same-origin' // or credentials: 'include' } fetch("https://mysite.sharepoint.com/_api/Web/Lists/GetByTitle('list')/items?$select=ID,Title", payload) .then(response => response.json()) .then((data)=>{ console.log(data.d.results) })

Retrieve more than 5000 items from SharePoint List

I actually have struggled with masses even as my list is getting large and want to retrieve the rows more than 5K. Here I located the answer is to apply the Recursive call to retrieve more than 5K items.

let url = _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/getbytitle('MyList')/items?$top=1000"; let response = response || []; // this variable is used for storing list items function GetListItems(){ return $.ajax({ url: url, method: "GET", headers: { "Accept": "application/json; odata=verbose" }, success: function(data){ response = response.concat(data.d.results); if (data.d.__next) { url = data.d.__next; GetListItems(); } }, error: function(error){ // error handler code goes here } }); }

Here we're doing the recursive call to the GetListItems() function. This will fetch information withinside the bunch of a thousand objects and concatenate it to the response variable.

Here data.d.__next includes the URL to get the next set of items. In case we don’t have more items left to fetch, it'll not call GetListItems() function.

Hope many of us will find this helpful.

Getting an Access Token for SharePoint Online

Prior to SharePoint 2019, SharePoint Administrators, SharePoint Developers, and Power Users could use SharePoint Designer for no-code workflow development. With the release of SharePoint 2019 and SharePoint Online, modern process automation is developed through Microsoft Flow. SharePoint Online leverages modern tools, like PowerApps and Flow for forms and workflow deployment.

As with the SharePoint 2013 workflow, developers can execute REST calls to accomplish workflow actions. To test REST calls that will be executed in a Flow, a tool like Postman can be leveraged.  To successfully send REST calls, an access token will need to be obtained from Microsoft Azure Access Services. The below steps detail the process of obtaining an access token.

To begin, copy the text in the below box into a notepad.  This text is generalized headers for the body of the HTTP Post request to retrieve the token. The text in bold will be replaced as the steps to obtain the token are followed.

grant_type=client_credentials
&resource=00000003-0000-0ff1-ce00-000000000000/TENANT-NAME.sharepoint.com@TENANT-ID
&client_id= GENERATED CLIENT-ID@TENANT-ID
&client_secret= GENERATED CLIENT-SECRET

Step 1 Register an App

Navigate to https://[TENANT -NAME].sharepoint.com/_layouts/15/appregnew.aspx

1. Open notepad
2. Click Generate next to Client ID
3. Copy the generated Client ID
4. In notepad, replace the bold GENERATED CLIENT ID text with the copied generated client id
5. Click Generate next to Client Secret
6. Copy the generated Client Secret
7. In notepad, replace the bold GENERATED CLIENT SECRET text with the copied generated client secret
8. Update App Domain with google.com
9. Update Redirect URL with https://localhost/
10. Click Create

Step 2 Grant APP-Only permission to the APP

1. Navigate to https://[TENANT-NAME].sharepoint.com/_layouts/15/appinv.aspx

Note: Client Id generated during APP registration appended with an @, followed by the Tenant ID

2. Paste the value of “Client Id:” from the notepad in the App Id field
3. Click Lookup
4. Update the Permission Request XML: field the below values:

<AppPermissionRequests AllowAppOnlyPolicy="true"><AppPermissionRequest
Scope="http://sharepoint/content/sitecollection/web"
Right="Read"/></AppPermissionRequests>

 5. Click Create

Step 3 Get access token

1. Navigate to Site Setting > App Permissions
   1. Locate the APP identifier that contains the Client Id generated during APP registration. The GUID on the right side of the @ is the Tenant ID. (You will need the Tenant ID in 3 places during the request build process)
      1. https://accounts.accesscontrol.windows.net/[Tenant ID]/OAuth/2
      2. Resource Header
      3. client_id Header

Update the Post Request Body in Notepad

In notepad, update the text as detailed below:

Key	Value	Notes
grant_type	client_credentials
resource	[SharePoint Online application principal ID]/[Tenant-Name].sharepoint.com@[Tenant-ID]	[SharePoint Online application principal ID] is always 00000003-0000-0ff1-ce00-000000000000   [Tenant-Name] with the tenant value as it appears in the sharepoint.com URL for the tenant [Tenant-ID] was obtained on Site Setting > App Permissions The GUID on the right side of the @ is the Tenant ID   The / and @ are literal values. Use them where specified
client_id	[Client-ID]@[Tenant-ID]	Obtain this value by doing the following Site Setting > App Permissions Locate the APP identifier that contains the Client Id generated during APP registration. Copy everything to the right of | (pipe) character.
client_secret	The client secret that was generated during APP registration

Build the Post Request URL

To obtain the access token, send a POST request to Microsoft Azure Access Control Service (ACS) account associated with Tenant. The URL is in the following format:

https://accounts.accesscontrol.windows.net/[Tenant-ID]/tokens/OAuth/2

[Tenant-ID] was obtained on Site Setting > App Permissions The GUID on the right side of the @ is the Tenant ID

1. Open Postman
2. Create a new Post Request
3. Enter the updated ACS URL in the address field

Build the Post Request Header

Key	Value
Content-Type	application/x-www-form-urlencoded

Paste the Body Text

Copy the updated Body text from the notepad into the Body of the postman request.

View the Post Response

On success, the response body will contain an access-token key.

References

https://anexinet.com/blog/getting-an-access-token-for-sharepoint-online/

https://docs.microsoft.com/en-us/sharepoint/dev/sp-add-ins/add-in-permissions-in-sharepoint

https://docs.microsoft.com/en-us/sharepoint/hybrid/configure-server-to-server-authentication

Download SharePoint Online List items Attachments using PnP PowerShell

 Let’s download all attachments from a list. Following script creates a folder for every list object and downloads all attachments to the local disk.

$SiteURL = "https://splearning99.sharepoint.com/sites/testDL" $ListName = "testlist" $DownloadPath = "C:\Temp\" #Connect to SharePoint Online site Connect-PnPOnline -Url $SiteURL -Interactive #Get all List Items $Listitems = Get-PnPListItem -List $ListName -PageSize 500 #Loop through List Items ForEach($Item in $Listitems) { #Get Attachments from Item $Attachments = Get-PnPProperty -ClientObject $Item -Property "AttachmentFiles" #Download All Attachments from List item Write-host "ID '$($Item.ID)', Attachments : $($Attachments.Count)" #Create directory for each list item $DownloadLocation = $DownloadPath+$Item.ID If (!(Test-Path -path $DownloadLocation)) { New-Item $DownloadLocation -type Directory | Out-Null } $Attachments | ForEach-Object { Get-PnPFile -Url $_.ServerRelativeUrl -FileName $_.FileName -Path $DownloadLocation -AsFile -Force } }

Unable to open SharePoint Designer Site

Unable to open SharePoint Designer Site

Remove all the content from following folders to avoid issue

• %APPDATA%\Roaming\Microsoft\Web Server Extensions\Cache
• %APPDATA%\Microsoft\Web Server Extensions\Cache
• %APPDATA%\Microsoft\SharePoint Designer\ProxyAssemblyCache
• %USERPROFILE%\AppData\Local\Microsoft\WebsiteCache
• %APPDATA%\Microsoft\SharePoint Designer

SharePoint Designer 2010 - Set Variable [Today]-x Days

To set a DateTime field to [Today] + 5 days using a SharePoint Designer 2010 Workflow, this is what I did:


1) Create a Local Variable (ETA Date) of type Number
2) Use a Do Calculation task in the workflow and set:

value: Workflow Context:Date and Time Last Run (As Double)
operation: plus
value: 432000 (number of seconds in 5 days or 60*60*24*5)
Output to: Variable: ETA Date

3) Finally, set the value of the respective field of the current item to the ETA Date variable

In your case, use the subtract operation and the second value is 2419200 (60*60*24*28).

Note: Compare the Date in Workflow, Current Item:ReminderDate equals (ignoring time) Today

Reference Link

Send E-mail from javascript using REST API - SharePoint

In SharePoint 2013 we can send emails using REST API where we can utilize SP.Utilities.Utility.SendEmail for doing the job. 

Note: The recipient is limited to a valid SharePoint user for security reasons.

function sendEmail(from, to, body, subject) { //Get the relative url of the site var siteurl = _spPageContextInfo.webServerRelativeUrl; var urlTemplate = siteurl + "/_api/SP.Utilities.Utility.SendEmail"; $.ajax({ contentType: 'application/json', url: urlTemplate, type: "POST", data: JSON.stringify({ 'properties': { '__metadata': { 'type': 'SP.Utilities.EmailProperties' }, 'From': from, 'To': { 'results': to }, 'Body': body, 'Subject': subject } }), headers: { "Accept": "application/json;odata=verbose", "content-type": "application/json;odata=verbose", "X-RequestDigest": jQuery("#__REQUESTDIGEST").val() }, success: function(data) { alert('Email Sent Successfully'); }, error: function(err) { alert('Error in sending Email: ' + JSON.stringify(err)); } }); } $(document).ready(function () { SP.SOD.executeFunc('sp.js', 'SP.ClientContext', SendEmails); }); function SendEmails() { var from = 'info@domain.com', to = 'toUser@domain.com', body = 'Email using REST API', subject = 'Email FYI'; sendEmail(from, to, body, subject); }

Note: You can add 'CC' and 'BCC' property also to send email, property 'results' having array.

Upload Attachment to SharePoint Site List Item

Application Form Window

CODE ---------------------- using System; using System.Windows.Forms; using System.IO; using System.Security; using spClient = Microsoft.SharePoint.Client; namespace Upload_Attachment_SP_Online { public partial class Form1 : Form { public Form1() { InitializeComponent(); } private void btnBrowse_Click(object sender, EventArgs e) { var file = openFileDialog1.ShowDialog(); if (file.ToString() == "OK") txtFilePath.Text = openFileDialog1.FileName.ToString(); var x = txtFilePath.Text.Split('\\'); txtFileName.Text = x[x.Length - 1]; } private void btnUpload_Click(object sender, EventArgs e) { try { using (spClient.ClientContext ctx = new spClient.ClientContext("https://contoso.sharepoint.com/tc/")) { SecureString upwd = new System.Net.NetworkCredential("", "password1").SecurePassword; ctx.Credentials = new spClient.SharePointOnlineCredentials("jon.smith@contoso.com", upwd); spClient.Web myWeb = ctx.Web; spClient.List oList = myWeb.Lists.GetByTitle("TestList"); spClient.CamlQuery camlQuery = new spClient.CamlQuery(); camlQuery.ViewXml = "<view><query><where><eq ><fieldref Name='Title'/>" + "<value Type='Text'>Item1</Value></Eq></Where></Query></View>"; spClient.ListItemCollection collListItem = oList.GetItems(camlQuery); ctx.Load(collListItem); ctx.ExecuteQuery(); spClient.AttachmentCreationInformation aci = new spClient.AttachmentCreationInformation(); byte[] bytes = File.ReadAllBytes(txtFilePath.Text); MemoryStream mStream = new MemoryStream(bytes); aci.ContentStream = mStream; aci.FileName = txtFileName.Text; foreach (spClient.ListItem oListItem in collListItem) { spClient.Attachment attachment = oListItem.AttachmentFiles.Add(aci); oListItem.Update(); } ctx.ExecuteQuery(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } } } }

Connect-SPOService : Current site is not a tenant administration site.

Working around with: Connect-SPOService : Current site is not a tenant administration site.

For the “Current site is not a tenant administration site” error message, which may look like following:
Connect-SPOService : Current site is not a tenant administration site.
At line:1 char:1
+ Connect-SPOService -Url https://mysite.sharepoint.com -Credential $credentials
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : NotSpecified: (:) [Connect-SPOService], ServerException
+ FullyQualifiedErrorId : Microsoft.SharePoint.Client.ServerException,Microsoft.Online.SharePoint.PowerShell.Con
nectSPOService

You get this error because you’re not entering the URL for your “Sharepoint Online Administration Center” site… Which is typically your normal sharepoint online URL, but then with a -admin after it, such as:
https://mysite-admin.sharepoint.com (assuming that your sharepoint online site is https://mysite.sharepoint.com). Therefore, then whole Powershell script would be:

Connect-SPOService -Url https://mysite-admin.sharepoint.com -credential username@mysharepointsite.com

NOTE: The -admin site is setup automatically. You don’t have to do anything. Just type in your sitename and then add the -admin.sharepoint.com to the end and you’ll be prompted to log in.

Promoted Links -> Script to show tile in rows and column

Promoted Links in SharePoint always show in a single row, following script help to break it into columns and rows also added style that will modify height and width.

// Copy Paste follow script into "Script Editor" above your Promoted Link web-part.


<style type="text/css"> <style type="text/css"> /* The height of the Promoted Link Webpart */ .ms-promlink-body { height: 100px; } /* Tile and border size. Delta between ms-tileview-tile-root and size of the promoted link tiles is the space between tiles */ .ms-tileview-tile-root { width: 105px! important; height: 105px !important; } /* size of the promoted link tiles */ .ms-tileview-tile-content, .ms-tileview-tile-detailsBox { width: 100px !important; height: 100px !important; } /* size of the image within the promoted link tile */ .ms-tileview-tile-content > a > img { width: 100% !important; height: 100% !important; } /* Changes the Promoted Link Title when you hover over it*/ .ms-tileview-tile-detailsListMedium { font-weight: bold; height: 100px; padding: 4px 7px 7px; font-size: 12px; line-height: 14px; } /* Changes the Promoted Link Description when you hover over it*/ .ms-tileview-tile-descriptionMedium { font-weight: normal; padding-top: 10px; font-size: 11px; /* If you want to change the font size, change above */ } /* Remove this if you only what to show the images and not the text */ /* Adjust the text in the Collapsed Promoted Link */ .ms-tileview-tile-titleTextMediumCollapsed { font-weight: normal; background-color: rgba(0, 0, 0, 0.6); width: 100px; height: 40px; position: absolute; top: -20px; left: 0px; text-align: center; vertical-align: middle; font-size: 11px; /* If you want to change the font size, change above */ line-height: 20px; word-wrap: break-word; } </style> <script type="text/javascript" src="https://code.jquery.com/jquery-1.10.2.min.js"></script> <script type="text/javascript"> $(document).ready(function () { // Update this value to the number of links you want to show per row var numberOfLinksPerRow = 4; // local variables var pre = " <tr><td><div class='ms-promlink-body' id='promlink_row_"; var post = "'> </div> </td></tr> "; var numberOfLinksInCurrentRow = numberOfLinksPerRow; var currentRow = 1 // find the number of promoted links we're displaying var numberOfPromotedLinks = $('.ms-promlink-body > .ms-tileview-tile-root').length; // if we have more links then we want in a row, let's continue if (numberOfPromotedLinks > numberOfLinksPerRow) { // we don't need the header anymore, no cycling through links $('.ms-promlink-root > .ms-promlink-header').empty(); // let's iterate through all the links after the maximum displayed link for (i = numberOfLinksPerRow + 1; i <= numberOfPromotedLinks; i++) { // if we're reached the maximum number of links to show per row, add a new row // this happens the first time, with the values set initially if (numberOfLinksInCurrentRow == numberOfLinksPerRow) { // i just want the 2nd row to currentRow++; // create a new row of links $('.ms-promlink-root > table > tbody:last').append(pre + currentRow + post); // reset the number of links for the current row numberOfLinksInCurrentRow = 0 } // move the Nth (numberOfLinksPerRow + 1) div to the current table row $('#promlink_row_' + currentRow).append($('.ms-promlink-body > .ms-tileview-tile-root:eq(' + (numberOfLinksPerRow) + ')')); // increment the number of links in the current row numberOfLinksInCurrentRow++; } } $(".ms-tileview-tile-detailsListMedium").attr('style', 'text-align: center'); }); </script>

CSOM Example

You have to reference following two dll file in your project.

• Microsoft.SharePoint.Client.dll
• Microsoft.SharePoint.Client.Runtime.dll

You can find this file at "C:\Program Files\SharePoint Online Management Shell\Microsoft.Online.SharePoint.PowerShell"

example.

using System;
using System.Windows.Forms;
using Microsoft.SharePoint.Client;
using System.Security;

namespace CAML_CSOMDemo
{
    public partial class Form1 : System.Windows.Forms.Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void bntExecute_Click(object sender, EventArgs e)
        {
            using (ClientContext ctx = new ClientContext("https://contoso.sharepoint.com/"))
            {
                string uname = "myemail@contoso.com";
                SecureString upwd = new System.Net.NetworkCredential("", "P@ssw0rd").SecurePassword;
                ctx.Credentials = new SharePointOnlineCredentials(uname,upwd);


                Web myWeb = ctx.Web;
                List productsList = myWeb.Lists.GetByTitle("CSOM_TestList");

                ctx.Load(myWeb);
                ctx.ExecuteQuery();
       
                MessageBox.Show(myWeb.Title);

            }

        }

}// end of class

}// end of namespace

SharePoint '/_layouts/' locations

Some times you want to jump right to a specific system list, page or go to the edit mode in a SharePoint site. I wanted to list all the famous urls I used for the past years and ask you to tell me about any other ones you know to add it here in the list. Other have already contributed a bunch 

(Remember for SharePoint 2013, 2016 you might want to add "15", "16" respectively after "/_layouts/" but if you don't SharePoint will take care of that for you) .. Also some of these are turned off on Office 365 SharePoint online.

Site collection level recycle bin:

/_layouts/15/AdminRecycleBin.aspx

Site level recycle bin (Added by Steve Stewart):

/_layouts/RecycleBin.aspx

Recreate default site sp groups (Added by Neal Bongers):

_layouts/15/permsetup.aspx

Load document tab initial (Added by Dominik Gempeler)

?InitialTabId=Ribbon.Document

Delete user from Site collection (on-premises) (Added by SamDavid):

/_layouts/15/people.aspx?MembershipGroupId=0

Display list in grid view. 'True' is case sensitive (Added by Antoine L.):

?ShowInGrid=True

Quick Launch settings page (Added by Ishani M.):

/_layouts/quiklnch.aspx

Navigation Settings page (Added by Abdur Raheem):

/_layouts/15/AreaNavigationSettings.aspx

Sandboxed Solution Gallery:

/_catalogs/solutions/Forms/AllItems.aspx

Workflow history hidden list:

/lists/Workflow History

Filter toolbar for Lists and libraries (Added by Asimaili):

?Filter=1

Site usage page (Added by @Dnyag):

/_layouts/usage.aspx

Site content and structure  page (Added by @Dnyag):

/_layouts/sitemanager.aspx

Site settings page (Added by Aowworld):

/_layouts/settings.aspx

View all site content page (Site content) (Added by Aowworld):

/_layouts/viewlsts.aspx

Manage site collection features - CASE SENSITIVE -  (Added by Vardhaman):

/_layouts/ManageFeatures.aspx?Scope=Site

Manage site features (Added by Vardhaman):

/_layouts/ManageFeatures.aspx

 Get the version of the SharePoint server (Patch level) (Added by: John Liu):

 /_vti_pvt/Service.cnf

Web Part Maintenance Page (Added by: Ricky):

?Contents=1

Show Page in Dialog View (Added by:Ricky):

?isdlg=1

Application page for registering SharePoint apps

/_layouts/15/appregnew.aspx

Save Site as a template

/_layouts/savetmpl.aspx

Sign in as a different user

/_layouts/closeConnection.aspx?loginasanotheruser=true

Enable SharePoint designer

/_layouts/SharePointDesignerSettings.aspx

Welcome Page (Default page settings)

/_layouts/AreaWelcomePage.aspx

Change Site Master Page

/_layouts/ChangeSiteMasterPage.aspx

Page Layouts and Site Templates

/_Layouts/AreaTemplateSettings.aspx

Master Pages library

/_catalogs/masterpage/Forms/AllItems.aspx

Quick Deploy List

Quick%20Deploy%20Items/AllItems.aspx
 

Open Page in Edit Mode

?ToolPaneView=2

Taxonomy Hidden List (MMS)

Lists/TaxonomyHiddenList/AllItems.aspx

User Information List:

 _catalogs/users

_catalogs/users/simple.aspx

Force displaying the user profile in the site
collection:

/_layouts/userdisp.aspx?id={UserID}&Force=True

Site hierarchy page (lists of sub sites) - (Added by community contributions)

/_layouts/vsubwebs.aspx

/_layouts/1033/vsubwebs.aspx

Reference Site