Sharepoint Tutorials

 

Connect sharepoint custom list 

Create public and private Certificate   When using SharePoint Online you can define applications in Azure AD and these applications can be granted permissions to SharePoint, but also to all the other services in Office 365 ( note : this will not work for SharePoint On-Premise.)    1- Create an empty text file on your computer.  2- Copy the  PowerShell  script from the  Granting access via Azure AD App-Only  page and paste it into the empty text file created.      3- Rename the text file  Create-SelfSignedCertificate  and save it as a  ps1  file ( Create-SelfSignedCertificate.ps1).   4- Open  Windows PowerShell  as  Administrator  inside the folder where this file is saved.  5- Copy the  PowerShell  command from the above-mentioned page:  .\Create-SelfSignedCertificate.ps1 -CommonName "SharepointCert" -StartDate 2023-10-09 -EndDate 2024-11-30     The  Com...

     Trigger Condition  in Automatic Flow 1st Day of the Month   -- Testing to trigger today  ==> "@equals(formatDateTime(utcNow(),'yyyy-MM-dd'),addDays(startOfMonth(utcNow()),22,'yyyy-MM-dd'))" Last Day of the Month   -- Testing to trigger today ==>  "@equals(addDays(utcNow(),7,'yyyy-MM-dd'),formatDateTime(subtractFromTime(startOfMonth(addToTime(utcNow(),1,'month')),1,'day'),'yyyy-MM-dd'))" 1st Day of the Month ==>  "@equals(formatDateTime(utcNow(),'yyyy-MM-dd'),formatDateTime(startOfMonth(utcNow()),'yyyy-MM-dd'))" Last Day of the Month ==>   @equals(formatDateTime(utcNow(),'yyyy-MM-dd'),formatDateTime(subtractFromTime(startOfMonth(addToTime(utcNow(),1,'month')),1,'day'),'yyyy-MM-dd'))

 

  1. Power Apps -> Implementing Role Based Security in Power Apps `2. Upload Files from Power Apps to SharePoint Document 3. Update Record into Excel sheet using power Automate 4. Error Handling in Power Automate flows | Try Catch Scope ... * To get workflow URL dynamically  Expression:      concat('https://make.powerautomate.com/environments/', workflow()?['tags']['environmentName'], '/flows/', workflow()?['name'], '/runs/', workflow()?['run']['name'])

  1. Number of days Calculation from the Date Json {   "$schema": "https://developer.microsoft.com/json-schemas/sp/column-formatting.schema.json",   "elmType": "div",   "txtContent": "=floor((Number(@now)-Number([$In_x0020_Project_x002f_Pool_x002]))/(1000 * 60 * 60 * 24))" } 2. Total Exp calculation from the Date of Joining  =IF(ISBLANK(DOJ),"",ROUND((INT((DATEDIF(DOJ,TODAY(),"D")-MOD(DATEDIF(DOJ,TODAY(),"D"),365))/365)+(INT(MOD(DATEDIF(DOJ,TODAY(),"D"),365)/30.44)/12))+[Exp Since DOJ (Y)],1))

 

 

  x

 

 S imple logging system implemented in C# using the Singleton design pattern: using System; public class Logger { // Singleton instance private static Logger instance; // Lock object for thread safety private static readonly object lockObject = new object (); // Private constructor to prevent instantiation from outside private Logger () { } // Static method to get the singleton instance public static Logger GetInstance () { if (instance == null ) { lock (lockObject) { if (instance == null ) { instance = new Logger(); } } } return instance; } // Log methods public void LogInfo ( string message ) { Console.WriteLine( "[INFO] " + message); } public void LogWarning ( string message ) { Console.WriteLine( "[WARNING] " ...