Showing posts from August, 2022

Cloud Computing: Some of the common used terms

  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

  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

  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

  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