Shashika Hettiarachchi : Techno Diary

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

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

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

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.

  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