Posts

Showing posts from April, 2024

Power Platforms Training videos

Image
  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'])

Sharepoint Online Calculated Formulas

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

Add or Update Rows in Excel from SharePoint with Microsoft Flow

Image
 

UPLOAD files from Power Apps to SharePoint Document Library ➕ Set Properties

Image
 

SQL Database Migration from Onpremisis to Azure

Image
  x

Audit Log Sharepoint Online

Image
 

Singleton design pattern

 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] " ...