Posts

Cloud Computing: Some of the common used terms

Image
  T oday, I will be starting to include my articles on the topic of cloud computing, since I am from a Microsoft stack background so mostly Azure but in the future, I will try to cover AWS and Google as well. So to start with I will be sharing the concepts of some very commonly used terms in this field What is Cloud Computing? Cloud Computing i s the delivery of computing services over the internet Cloud computing consists of 2 major things Computation Storage What is meant by High Availability? High availability is the SLA (Service Level Agreement) for which the provider commits the uptime of the service provided to the consumer. There is a difference between the uptime of 99% and 99.9% Usually, we think that there is not much difference between 99% and 99.9%  uptime, but the below image can explain, so choose wisely. What is meant by Scalability? Scalability is the ability to adjust resources to meet demand Vertical Scalability : To add/reduce the capabilities of the resources to mee

Power Automate: Rename file in SharePoint Online

Image
  We often get to change the name of the file, so in this article, I will explain how to rename the file in SharePoint Online using Microsoft Power Automate. Below is the file which I will be renaming. Step 1: Get the file properties We only need to have the SharePoint item id, for which we want to rename the file Step 2: Update the File Name Add the "Send an HTTP request to SharePoint" connector, and update the following properties Method : POST Uri : _api/web/lists/GetByTitle(' <LIBRARY TITLE> ')/items( <ITEM ID> )/ValidateUpdateListItem Body: {     "formValues" :[         {             "FieldName" : "FileLeafRef" ,             "FieldValue" : "<New File Name>"         }     ] } Execute the flow, and the file will be renamed Happy Automating..!! #PowerAutomate #SharePointWidgets #Microsoft

Power Automate Tip: Reduce loop to improve performace

Image
  If you are creating very complex flows using Microsoft PowerAutomate which contains loops ( Apply To Each connector), you must have noticed that performance degrades sharply.  I had a loop of 120 items with some complex business logic, which was taking around 40 mins to execute the complete flow. But after I have removed the loops and reduced the number of variables now flow gets completed in less than 8 mins. So you can imagine the performance if your flow is going to be executed on a very large dataset. To improve the performance of the flow, it's necessary to reduce the loop count and to do that  I count on the 2 best functions from Power Automate. To explain the below functions, I will take a scenario where there are below fields  Title City State #1: Select You can make use of the Select function to create a collection/array of single-valued or complex objects, even without looping each item. Case 1:  Suppose I want to collect all the cities from all the records, then I can

Power Automate: How to Add "New Line" to the text in SharePoint multiline text field

Image
  Q. How to add "New Line", while adding the text to the SharePoint multiline text field?  A . In order to add the new line while adding a text to the multiline SharePoint field, I will demonstrate the simplest approach. Although you can find multiple approaches, but this one seems to be very easy and quick. You need to append the below expression to the text to make it to the new line: decodeUriComponent('%0A') If you are adding any array, then join the array using this expression or if you are building this string, then append this expression to the string. Step 1:  Add a variable and add the below expression (Write the code under the Expression tab) STEP 2: This is how your variable will look like      STEP 3: Output of the Address columns which is of Type Multiline text field Happy Coding..!! #Microsft #SharePointWidgets #PowerAutomate

Power Automate Tip: How to define constants without having too many variabled declared

Image
  I have been architecting things and came to my observation that developers are using too many of the variables in the flow which they want to keep the hard-coded values or technically say constants. Declaring/initializing too many variables makes the flow very big and becomes hard to understand. Moreover, it takes a lot of time and effort to add the number of variable components and to name and add comments. This tip will save you from all of these. So for a quick tip on how we can declare the constants more effectively so that we are not filling the whole screen with the variable declaration So to do it we can make use of 2 connectors Compose Parse JSON For example, if you want to hardcode the Site URL and some of the list Names we can do something like this... Step 1: Compose Step 2: Parse JSON Step 3: Usage Conclusion So these 2 steps will save a lot of your time and effort which you spent in adding the variable connector and defining them. If you want to update any property at an

Key Points to maximize you SharePoint Migration using Sharegate.

Image
  Many organizations are going through a shift of platforms i.e... from on-premise solutions to online solutions, and SharePoint is one of the major platforms. In this article, I will be highlighting some basic key concepts which might help you out in maximizing the amount of data transfer from SharePoint on-premise to SharePoint Online using Sharegate as a tool. The suggestions I mentioned in the article are based on my years of experience, and might not suit some scenarios Computing Power Many of us think that while using Sharegate we do not require a powerful system for migration as it is just the transfer of data. But that is not correct as before sending the data, Sharegate does a lot of processing. So having a powerful computing machine will speed up the processing and you can gain the speed. Though Sharegate recommends optimal performance with 4 cores, my suggestion is to go with a minimum of  8 CPU cores 32Gb RAM 256 GB of SSD This will give the maximum resources and power to c

How to get site collection created date in SharePoint Online

Image
  Q: How to get the site collection created date in SharePoint online Answer:  This can be done using the PnP SharePoint commands $connection  =   Connect-PnPOnline   - Url  " <SITE URL> "   - ReturnConnection  - UseWebLogin $web  =   Get-PnPWeb   - Includes Created  - Connection $connection Write-Host  $web.Created Happy Coding...!!!