Replacing SharePoint Designer with VS Code

“Replacing SharePoint Designer with VS Code”

- install VS Code

- Add extension SPGO to your VS Code

- Execute following 2 thing

------ Connect to workspace

Press F1 : write > SPGO Configuration Workspace

put the URL and some relevant default inputs

-- new SPGO.json file will be created something like:

{

  "sourceDirectory": "src",

  "sharePointSiteUrl": "https://domain.sharepoint.com/itBudget",

  "workspaceRoot": "f:\\SPApps\\itBudget",

  "publishWorkspaceOptions": {

    "destinationFolder": "/",

    "globPattern": "f:\\SPApps\\itBudget\\src\\**\\*.*",

    "localRoot": "f:\\SPApps\\itBudget\\src"

  },

  "publishingScope": "SaveOnly",

  "authenticationType": "Digest",

  "remoteFolders": ["/SiteAssets/Custom/js", "/Pages", "/SitePages"]

}

In case if SiteAssets folder is not getting downloaded, try to add the pattern "/SiteAssets/**/*"

Press F1 again: write > SPGO Populate local workspace

enter : registered EMail and Password.

Source found at following URLs

1) Replacing SharePoint Designer with VS Code Part 1: Setting up the Environment

2) Replacing SharePoint Designer with VS Code Part 2: Configuring SPGo in VS Code

3) https://marketplace.visualstudio.com/items?itemName=SiteGo.spgo

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.

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.

WE CAN’T DO THAT FOR YOU BECAUSE THE FILE IS NO LONGER CHECKED OUT OR HAS BEEN DELETED IN SHAREPOINT DESIGNER

SCENARIO

In SharePoint Designer, When I tried to “Check In” a file inside, I got the below error:

WE CAN’T DO THAT FOR YOU BECAUSE THE FILE IS NO LONGER CHECKED OUT OR HAS BEEN DELETED

I already have tried to

• Close Share Point Designer and restart it again,
• Close SPD then clear cache from the following folder:
  • %USERPROFILE%\AppData\Local\Microsoft\WebsiteCache
  • %USERPROFILE%\AppData\Roaming\Microsoft\Web Server Extensions\Cache

Unfortunately, the “We can’t do that for you because the file is no longer checked out or has been deleted” still persists.

---

CAUSE

This problem might occur in case, the file title contains disallowed characters like “/” as shown below:

---

SOLUTION

• Right-click on the affected file >  Select “Edit file in advanced mode“.

• Right-click again on the affected file > Select “properties“.

• The properties page should be shown.

• Remove URL > Change the title to an appropriate name by avoiding using the disallowed characters.

The file should be now checked in properly.

Reference of this POST