Learning SharePoint

S harePoint Site templates are now replaced with Site designs in Modern Sites. We can create custom site designs using some json script(s). Site Design allows to create lists, create list views, apply theme, customize navigation, create content types, create site columns and so on. Click here to see JSON scheme reference for creating custom site design.  Endpoint to apply site design as a part of flow is as below. _api/Microsoft.Sharepoint.Utilities.WebTemplateExtensions.SiteScriptUtility.AddSiteDesignTaskToCurrentWeb We must use “Send Http Request to SharePoint” action to make an API call to SharePoint. SiteDesignId must be part if body, this is GUID of the SharePoint site design you need to apply. We can line up sequence of calls if we need to apply multiple site designs to a single site. We can now wait for few mins and all our sited designs will get applied or we can also check the status by making another API call with below endpoint. You just need to pass the Apply Design ta

In continuation to my previous blog on custom connector . Here is the blog on how to deploy connector to a new environment. To move custom connectors from one environment to another. We have to perform 3 different actions. 1.        Adding connectors to Solutions. 2.        Exporting solutions   3.        Importing solutions in new environment. Click here to visit Power Automate Portal. Login with admin user credentials.         •    Click on the “Solutions” tab on the left panel. Please refer image below.     Note: Custom connectors created outside solutions cannot be added to solutions at this time.   Adding a connector to a solution To add Custom Connector to Solutions below steps are to be followed. •        Click on New Solution on top ribbon. Enter necessary details like solution name, version and so on and click on “Create” button.   •        You should be able to see the newly created solution on the top. You can click and open

Recently I came across a requirement to create an interface between SharePoint and 3rd party project management tool. Click here  login with your Ofice365 account. Click on Data > Custom Connector menu option from left navigation pane. Click on "New Custom Connector" from top right corner. Select Create from blank. You can now see a new connector creation screen. General Tab Provide the host URL and API end point URL. Click on "Security" tab select the authentication method that the source tool is using. Security Tab Based on your selection rest of the input controls will be be shows, Lets assume you have selected 0Auth 2.0. You should now see columns like  Client ID : is id from app registered in project management tool to consume API.  Client Secret : is a secret key generated by the source from where you are to consume API. Authorization URL : is token generation endpoint URL.  Token URL : is Refresh token URL. Scope : Specify if the API documentation has

Today I came across a requirement to upload file to SharePoint Document library. This task was to be done using SPFx. Pnp helped me with this. Here is the code i used. Below is the code for uploading file and meta data. private   UploadFile ():  void  {          let   input  = < HTMLInputElement >  document . getElementById ( "fileUpload" );          let   files  =  input . files ;          for  ( let   index  =  0 ;  index  <  files . length ;  index ++) {              const   file  =  files [ index ];              if  ( file . size <=  10485760 )    {      //upload small file in document library           pnp . sp . web . getFolderByServerRelativeUrl ( "/sites/Dummy/ProcessDocuments/" ). files . add ( file . name ,  file ,  true ). then ( f =>  {                   f . file . getItem (). then ( item   =>  {                      item . update ({ ProcessInformationIDId:   itemID }). then ( f   =>  {            

Today I was working with an MS Flow, Flow was responsible to trigger email when List Item was added and then delete it. While working on this, I faced issues with checking if List Item has Attachments. Flow has an inbuilt option to check "Has Attachment" column value. I don't know why but somehow it didn't work for me. So, as an workaround. I used "Get Attachments" action. Later, In next step we will be checking if "Get Attachment" returns something in body. So, If "Get Attachments" body has length of 0 or more. Based on this we can take further actions. Thanks, Keyur