Learning SharePoint

PowerShell Automation for Smart SharePoint List Migration Migrating data between SharePoint environments is one of those tasks that looks simple on paper—but in practice, it’s easy to get tangled in duplicates, mismatched fields, or incomplete moves. With many organizations moving from on-premises SharePoint Server to SharePoint Online , automation becomes key to a smooth transition. This guide walks through a PowerShell script that not only moves list items from an on-premises SharePoint list to the cloud but also checks for duplicates before copying. Let’s break it down. Why Automate the Migration? Traditional migrations often copy everything from the source list to the destination list—whether or not those items already exist in the target. The result? Duplicates, clutter, and a messy data clean-up later. This script was designed to solve that. It brings intelligence into the migration process by checking for duplicates first, then deciding whether to move or...

Recently I was doing some testing with a background PowerShell and encountered a weird error. “Identity client runtime library (IDCRL) did not get a response from the login server”. The error that you might encounter while working with PowerShell. This error is very misleading when it comes to identifying what could go wrong. After doing quite a good amount of research below are the probable causes for the error. Invalid Credentials MFA (Multi-Factor Authentication) Manage security defaults. Solutions Invalid Credentials Check if your credentials are wrong. Especially if you are using variables. MFA (Multi-Factor Authentication) Check if MFA is enabled on the account which you are using. These only affect you badly if you are developing PowerShell for a background Job. Go to Microsoft 365 admin center Users -> Active users -> Select the user -> Manage multifactor authentication -> Select the user -> Disable multi-factor authentication. M...

T his week we would be looking into our first web UI flow demo on how to create UI flows using Power Automate Desktop. Just in case if you are not aware about UI Flows/ Power automate desktop flows. Please refer my previous blogs. Introduction to UI Flows UI Flow Triggers Creating first UI Flow To create a web UI flow you will have to download Power Automate addin for the browser you are using. Note: Supported browsers Chrome, Firefox, Microsoft Edge, Internet Explorer. Today we will create UI flow for web, Our case study today will be simple. We will launch browser and record actions that we perform. Open Power automate desktop app. Click on New Flow First action to be dragged will be Launch Chrome.       Click on Save. Not click on web recorder from top left corner and click on web recorder.   You should now see a popup, select Chrome from there. Open the URL you added in Launch chrome action. Click on start recording button from recorder screen. Perform actions y...

I n continuation to my previous blog post today we will see what are different options to trigger a UI flow. Deciding the nature of triggers may depend on the nature of the flow(UI Flow) that you created. Attended Mode: To run an attended UI flow, you need to have an active Windows user session that matches the name of the user configured for your connection. The session must not be locked. Unattended Mode: To run unattended UI flows, the target machine needs to be available with all users signed out. Prerequisites You need the  on-premises data gateway  for your device to have the UI flow triggered by Power Automate. A work or school account. You can run UI flow from Power Automate flows. Triggering these flows can be done using  from an event, button, schedule, or business process flow. Sign in to  Power Automate . Select  My flows  in the left navigation pane. Select  New , and then select  your desired type of flow . Give your flow a name in...

W e can create Team Sites using Power automate. Use “Send HTTP Request to SharePoint” action for creating team site. To create Modern Team Site (No Group) We need to make a call to “/_api/SPSiteManager/create” end point. SiteDesignID parameter is optional. Your call should look like below when action is created.     Modern Team Site (Linked to a Group) We need to make a call to “_api/GroupSiteManager/CreateGroupEx” end point. Ensure to pass implicit formula parameter something like below. ["implicit_formula_292aa8a00786498a87a5ca52d9f4214a_7c13ef32-45f0-4282-a3c7-2d05ff0a9189"] Your call should look like below when action is created.   Thanks, Keyur Pandya

  H ope you are doing fine and safe in this pandemic situation. I recently came up with an opportunity to work with SharePoint Site Designs. SharePoint Site templates are now replaced with Site designs in Modern Sites.   SharePoint allows us to create JSON schema to apply our custom options that we want to add. Below are the things we can apply using site script. Create a new SharePoint list Define a new site column Define a new content type Add a navigation link Remove a navigation link Apply a theme Set branding properties Set a site logo Join a hub site Install an add-in or solution Register an extension Activate a Feature Trigger a flow Configure regional settings Add users (principals) to SharePoint Groups Manage guest access Let us assume we have a JSON schema created. I am taking below sample from MS documentation for reference.   We will now be adding above JSON schema to SharePoint as Site Script. Below is the command we execute. $site_script = ‘{   ...

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 Desig...

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...

Today I came across a requirement to get outlook events to SharePoint custom webpart. Thanks to Graph API to ease the work. Here are the steps that we need to follow in order to get events. 1. Register a new app in Azure Active Directory . Here is the blog that i referred. 2. Now its time to get access token using generated client id and secret in previous step. Execute below code to get access token. $.ajax({     type: "POST",     crossDomain: true,     url:       "https://cors-anywhere.herokuapp.com/https://login.microsoftonline.com/<Tenant ID>/oauth2/v2.0/token",     headers: {       "content-type": "application/x-www-form-urlencoded"     },     data: {       grant_type: "client_credentials",       client_id: "", //ClientId@TenantId ...

Lets try to make a SharePoint site responsive. Making a SharePoint site responsive is a two way process. Making Master page Responsive. Making SharePoint page layouts responsive. Making contents that is gonna load on the page responsive. Note : I would recommend to use Bootstrap in order to make site responsive. Lets now start with making a responsive master page. First of all you need to have a responsive HTML site. Take the portion that you want to add into master page and uploaded the derived portion with all necessary reference files into SharePoint master page gallery. Now  publish the master page and click on the gear icon on top right corner > Click on design manager > Under D esigner Manager click on Edit Master Pages option and then click on  Convert an HTML file to a SharePoint master page option Select your html file. You will now be redirected to Preview page. You can have a look at the page and resolve issues if you find any.  ...