Posts

Add "Edit Item" Column to SharePoint online list

Image
 In this blog I will show you how to add edit item button to the SharePoint online list as below  Steps  Create a new Calculated Column as "Edit Item"   In the Additional column settings change the formula as follow. In the Column formatting section add the following script   {   "$schema": "http://columnformatting.sharepointpnp.com/columnFormattingSchema.json",   "elmType": "button",   "customRowAction": {     "action": "editProps"   },   "style": {     "border": "none",  "background-color": "transparent"   },   "children": [     {       "elmType": "span",       "attributes": {         "iconName": "Edit"       }     }   ] } ----- Thanks & Happy Coding ------ 

Create Sub folders when you create a new folder in SharePoint online Document Library - Power Automate

Image
In this blog post I will explain how Power Automate can be used to dynamically create sub folder structure in a SharePoint document library when a new folder is create. I will explain how to create an MS Flow which would perform the below series of actions, User creates a New Folder in the root folder of a SharePoint document library MS Flow is triggered to automatically created the following folder structure "Folder Name /  01 - Quotation and Tender Documents " "Folder Name /  02 - Purchase Order " "Folder Name /  03 - Email Correspondence " "Folder Name /  04 - Drawings " "Folder Name /  05 - Test Report " "Folder Name /  06 - Photos " "Folder Name /  07 - Routing " Email will sent to the user after the folder creation. Steps  Create a new “Automated – from blank” Flow. Provide a name for the Flow i.e. “Folder Create”; select the “When an item is created” SharePoint trigger and then click “Create”. Set the “Site Ad

[SOLVED] The SharePoint Timer Service service terminated unexpectedly. Event ID : 7031

Image
The SharePoint 2013 Timer service terminated unexpectedly.  It has done this  34  time(s).  The following corrective action will be taken in 30000 milliseconds: Restart the service Login Name : System Source : Service Control Manager Event ID : 7031 Level : Error                                    Keywords : Classic User : N/A                                       Computer : MyDomain If you are getting above error. Try to do the following steps  1.  Clearing the configuration cache Stop the Sharepoint timer service Go to C:\ProgramData\Microsoft\SharePoint\Config\*GUID Back up Cache.ini Delete all the .xml file ( Do not delete the Cache.ini file ) Open Cache.ini (Edit with Nodepad) Replace the contents with the number 1 and save the file  Start the timer service. 2.  Check app owstimer.exe app crash reports Go to C:\ProgramData\Microsoft\Windows\WER\ReportQueue Open Report.wer file from a folder  Check for error .wsp file or timer job  Retract the solution. Restart the timer service an

JavaScript for Beginners - Functions (P: IX)

Image
Functions A JavaScript function is a block of code designed to perform a particular task.   The main advantages of using a function; -           Re-Use - define the code once and can re-use many times. -           Use the same code many times with different arguments, to produce different results Note: A JavaScript function is executed when “something” invokes or call it. Defining a function To define a function, use the “ function ” keyword, followed by a name , followed by a set of parentheses (). Calling a function To execute the function, you need to call it. To call a function, start with the name of the function, then follow it with the arguments in parenthesis.   Note: Always remember to end the statement with a semicolon after calling the function. Once the function is defined JavaScript allows you to call it as many times as you want to.

JavaScript for Beginners - Basic Concepts Conditionals and Loops (P: VIII)

Image
  The If Statement Very often when you write code, you want to perform different actions based on different conditions. You can do this by using conditional statements in your code. Use if to specify a block of code that will be executed if a specified condition is true The statements will be executed only if the specified condition is true . Example: Result: If the condition evaluates to false, the alert statement is skipped and the program continues with the line after the if statement’s closing curly brace. Note: Note the if is in lowercase letters. Uppercase letters (If or IF) will generates an error The if else Statement Use the else statement to specify a block of code that will execute if the condition is false The example below demonstrates the use if an if... ese statement The above example says: -           If num1 is greater than num2, alert “This is my first condition” -           Else, alert “This is my second condition”. The browser will print the second c

JavaScript for Beginners - Basic Operators (P: VII)

Image
  Math Operators Arithmetic operators perform arithmetic functions on numbers (literals or variables) Operator Description Example + Addition 50 + 5 = 55 -             Subtraction 20 -10 = 10 * Multiplication 40 * 2 = 80 / Division 20 / 4 = 5 % Modules 56 % 3 = 2 ++ Increment var x = 10; x++, Now x = 11 -- Decrement var x = 10; x--, Now x = 9   Addition In the example below, the addition operator is used to determine the sum of two numbers You can add as many numbers or variables together as you want or need to Multiplication The multiplication operator (*) multiplies one number by the other. Division The / operator is used to perform division operations: The Modules Modules (%) operator returns the division reminder (what is lef