Resources  
  • Leveraging Compiled Queries for Enhanced Performance in LINQMar 09, 2024. Compiled queries in LINQ allow developers to pre-compile LINQ queries into executable delegates, reducing the overhead of query compilation and optimization. By caching the compiled query execution plan, compiled queries improve the performance of frequently executed or complex queries in C# applications.
  • Decoding Expression Trees in C#Mar 08, 2024. This article contains the details of how to Decoding Expression Trees in C#.
  • Angular URL/Site Validation using Regular Expression and Bootstrap with Reactive FormsFeb 26, 2024. Steps to add validation for URL using the regex pattern in the angular application. I will explain steps to create a form with text input using the reactive forms in angular. This input field will only accept the URL.
  • What Are Inline Conditional Expressions in React.jsFeb 26, 2024. In React, leverage inline conditional expressions like the ternary operator or logical && operator to dynamically render elements based on conditions. Enhance UI flexibility and readability with these versatile techniques.
  • Why we should learn C#?Feb 26, 2024. This article explores the reasons behind choosing C# over other languages, delving into its evolution, key features like object orientation, lambda expressions, LINQ, generics, and its adaptability for modern development needs.
  • Template Literals In JavaScriptFeb 24, 2024. JavaScript template literals are an effective tool for working with and creating strings. They were first included in ECMAScript 6 (ES6).
  • .NET Delegates for Mere Mortals: IntroductionFeb 19, 2024. Explore .NET delegates practically in this article. Learn to use delegates for flexible, reusable code. Follow examples, download source code, and understand delegate syntax, including anonymous methods and lambda expressions.
  • Local Temp Tables, Global Temp Tables, Table Variables, and CTEs ComparisonFeb 12, 2024. In SQL database management, optimizing data storage is vital for efficient query execution. Local and global temporary tables, table variables, and CTEs are versatile options for temporary data storage, each with distinct use cases.
  • Deleting Duplicate Records Using CTEJan 09, 2024. In this article we will understand how to delete duplicate rows and records from table using Common Table Expression (CTE) in SQL Server.
  • Default Lambda Parameters in C# 12Jan 05, 2024. C# 12 introduces a game-changer: default lambda parameters. This article delves into this powerful feature, showcasing its functionalities, advantages, and practical applications through detailed examples across diverse scenarios. Learn how to reduce code duplication and enhance readability.
  • What is Collection Expressions in C# 12?Jan 03, 2024. Forget the days of writing mountains of code just to create simple lists or arrays. C# 12 unleashes collection expressions, your new superpower for crafting collections with ease and elegance. This friendly guide demystifies the magic behind these expressions, even if you're a coding newbie.
  • Action and Func Delegates in C#Jan 02, 2024. Unlock the potential of Action and Func delegates in C# programming. Dive into the world of expressive and readable code, utilizing these powerful tools for method-passing, event handling, and more. Happy coding!
  • Essential Features of C# 12 You Need to KnowDec 28, 2023. Unlock C#'s hidden potential with features that make coding a breeze. Streamlined constructors, effortless collections, and enhanced lambdas await!
  • Table(s): Temp Table, Table Variable and CTE (Common Table Expression)Dec 26, 2023. This article will discuss SQL Table like items, including temp table, table variable, CTE, Table-valued Parameters.
  • Collection Expressions in C# 12Dec 12, 2023. C# 12.0 introduces collection expressions, streamlining collection initialization syntax. This evolution enhances code conciseness, readability, and performance, simplifying developers' interaction with arrays, lists, and more.
  • Understanding LIKE vs ILIKE in PostgreSQLDec 05, 2023. In this article, we will focus on the differences between the LIKE and ILIKE operators, and how to use them effectively.
  • Simplify Your Code with Switch Expressions: Patterns and ExamplesNov 06, 2023. In C#8 switch statement enhanced with powerful feature that can simplyfy your code and make it more readable and maintainable. In this article We will explore into C# 8 switch expression and how to use in our code and make it more readable and how to use in different way to write conditional logic and how to leverage pattern matching functionality using switch.
  • Execute XPath expression Action in Desktop flow using Microsoft Power AutomateNov 04, 2023. Reading this article, you can learn how to use Execute XPath expression in Desktop flow using Microsoft Power Automate
  • Getting Started with Regex in C#Oct 18, 2023. Regex, or regular expressions, are essential for text processing in C#. They facilitate pattern matching, data extraction, and validation, empowering developers with versatile and powerful text manipulation tools.
  • How To Show The Power Automate Complete Expressions?Oct 16, 2023. Step by step details to show the Microsoft Power Automate complete expressions
  • Implementing DATEDIFF Function In Data Factory / Synapse Via Pipeline ExpressionsSep 27, 2023. Implementing DATEDIFF function in Data Factory / Synapse via Pipeline ExpressionsImplementing the DATEDIFF function in Azure Data Factory or Azure Synapse Analytics using pipeline expressions allows you to calculate the difference between two dates and times. This can be helpful for various data integration and transformation tasks, such as calculating the age of records, measuring time intervals, or scheduling data pipelines based on date differences.
  • What is Threading in C#?Sep 15, 2023. Threading in C# empowers concurrent task execution within a single process. Enhance application performance, responsiveness, and scalability for complex operations. Learn the basics and explore advanced topics.
  • Simplifying Code with Pattern Matching in C#Sep 11, 2023. Discover how pattern matching in C# can simplify your code, improve readability, and enhance your development workflow. This comprehensive guide explores various pattern types, including type, constant, property, tuple, and positional patterns, and reveals how they can be applied in real-world scenarios.
  • Exploring Math - Trig, Parent - Child and Relationship Functions in DAXAug 29, 2023. This segment goes beyond the basics and explores functions like CALCULATE, FILTER, and ALL. It covers techniques for creating dynamic measures, time intelligence functions, and handling more intricate data modeling scenarios. Learners will gain insights into optimizing DAX formulas, solving real-world business problems, and building sophisticated data models for enhanced reporting and analysis in Power BI.
  • Exploring Statistical, Table - manipulation and Text Functions in DAXAug 29, 2023. This segment goes beyond the basics and explores functions like CALCULATE, FILTER, and ALL. It covers techniques for creating dynamic measures, time intelligence functions, and handling more intricate data modeling scenarios. Learners will gain insights into optimizing DAX formulas, solving real-world business problems, and building sophisticated data models for enhanced reporting and analysis in Power BI.
  • The Role of Java Standard Tag Library- EL (JSTL-EL) in JSPAug 23, 2023. The JSTL EL or JSTL Expression Language is used by JSP Programmer in order to avoid the usage of Java Code for accessing data.
  • Power BI DAX Top 20 Functions For BeginnersAug 22, 2023. Power BI DAX Top 20 Functions For Beginners. Power BI's Data Analysis Expressions (DAX) language is a powerful tool for creating custom calculations, aggregations, and transformations in Power BI. Here are the top 20 DAX functions for beginners.
  • CTE (Common Table Expression) and Recursive CTE in SQL ServerJul 10, 2023. Learn about the Common Table Expression (CTE) in SQL Server with the WITH clause. Simplify code, improve query readability, and use recursive queries with the SQL WITH clause.
  • New Features In C# 12Apr 22, 2023. We're excited to show you three new features for C# 12:
  • C# 12's Switch Expressions: A More Powerful Alternative to Traditional Switch StatementsApr 17, 2023. C# 12's Switch Expressions: A More Powerful Alternative to Traditional Switch Statements
  • The Fastest Way To Use Regular Expressions In Microsoft .NET 7Apr 06, 2023. In this article, you will learn about the Fastest Way to Use Regular Expressions in Microsoft .NET 7.
  • Count Number Of Character Occurrences In A String Using JavaScriptApr 04, 2023. In this article, I am going to demonstrate various way to count number of character occurrences in a string javascript
  • Common Table Expression In SQL ServerMar 31, 2023. This article provides a practical guide to SQL CTE (Common Table Expressions), complete with examples that demonstrate how to use this powerful SQL feature to improve query performance and simplify complex queries. It covers the basics of CTE, including syntax and usage, and also delves into advanced topics such as recursive CTEs and using CTEs to implement complex calculations. Whether you're a beginner or an experienced SQL developer, this article is a valuable resource for mastering the use of CTEs in your SQL queries.
  • Trigger Condition Expression - SharePoint Columns Compare And Trigger Only If Not EqualFeb 22, 2023. Power Automate Flow - Trigger condition expression - SharePoint Columns Compare and trigger only if not equal.This article will explain how we can create an automated MS flow with a trigger condition to run only when two column values of a SharePoint List / Library is not equal
  • Common Table Expression (CTE) In SQL ServerDec 15, 2022. Simplify complex joins and subqueries using SQL Server Common Table Expressions or CTEs. It also provides a way to query hierarchical data. This article provides a complete overview of CTEs, types of CTEs, benefits, drawbacks, and how to use them with SQL Server.
  • Derived Tables Vs Common Table ExpressionsAug 28, 2022. In this article, you will learn about Derived Tables Vs Common Table Expressions.
  • Understand Switch Statement In Power AutomateApr 12, 2022. Generally to handle multiple conditions then like in javascript and C# .net switch will be used, in the same way in Power automate also we can use Switch action. In this article we can see how it can be used to decide whether a person can take vaccination or not.
  • Handle Nulls In Parse JSON Action In Power AutomateApr 07, 2022. Whenever working with json payload’s in power automate, always a possibility of receiving null values inside json, where Parse JSON Action will be errored out because of these null values. To handle this we have to modify Schema of the generated Schema for the provided json.
  • Understand Bound Action In Power AutomateMar 25, 2022. During certain scenarios it is required to call bound action . To call a bound action we can do it with javascript , plugins and power automate. In all the other methods except power automate you have to write explicit logic to call an bound action. As an example, we call a sample bound action which was built for contact entity/table from power automate.
  • Format Number In Power Automate Mar 14, 2022. Number Formatting during few scenarios is required based on the customer requirement. In Power Automate, this can be achieved with Format Number Action. As an example, numeric value ,currency , Mobile numbers were shown using Format Number Action.
  • CTE (Common Table Expression) and Recursive CTE in MS SQL ServerMar 11, 2022. In this article, we going to explore about CTE and Recursive CTE in MS SQL Server and their benefits.
  • Usage Of Peek Code In Power AutomateMar 09, 2022. In Power Automate, at times we need to write expressions manually, a quick way of doing is by using Peek code functionality that is present in every action in Power Automate . Especially this Peek code comes for rescue, when ever we are trying to work on actions like Lists, lookup values, Flow trigger conditions Peek code will be useful.
  • Understand Flow Trigger Condition In Power AutomateMar 04, 2022. In Power Platform, at times we must take care of the number of flow runs per day based on API Limits so that we can run the flow only when it is needed. In Power automate this can be taken care by using Flow trigger condition available on trigger point of the flow.To explain this a basic automated flow was taken where on modification of any contact record if at all discount is equal to 50 then only I want my flow to run in all other cases flow should not be run.
  • Usage Of Less Function In Power AutomateFeb 28, 2022. In Power Platform, at times we must compare values to identify whether the given number is less or not. In Power Automate, Less Function can be used quickly to find out whether the given integer/float is less or not by comparing with a number.
  • Usage Of Min Function In Power AutomateFeb 28, 2022. In Power Platform, at times we must compare values to identify the minimum number. In Power Automate, min Function can be used quickly to find out min value in the given set of integers /Array .
  • Usage Of Scheduled Cloud Flow In Power AutomateFeb 18, 2022. At times we tend to miss important updates especially some reminders, here in order to handle these kinds of things Scheduled cloud flows comes for rescue in Power Automate. As a real time scenario, we tend to forget to take break of 5 min for every hour while working with computers/ Laptops in this example I will try to explain this with Scheduled Cloud Flow.
  • Usage Of Trim Function In Power AutomateFeb 17, 2022. In Power Platform, at times we must omit the spaces that are present inside a string. To achieve this functionality Trim function in Power Automate can be used. As an example, String variable name was used to explain Trim functionality.
  • Usage Of Length Function In Power AutomateFeb 11, 2022. In Power Platform, at times we must length of a string or elements in an array to perform certain operations on them. In Power Automate, Length Function can be used quickly to find out whether the given string or Array have values or not.
  • Usage Of Empty Function In Power AutomateFeb 10, 2022. In Power Platform, at times we must verify whether the given json object or string or array have empty value or not. In Power Automate, Empty Function can be used quickly to find out whether empty value present or not.
  • Usage Of Union Function In Power AutomateFeb 04, 2022. In Power Platform, at times we must combine couple of Arrays or objects. In these scenarios, Union function in Power Automate can be used. As an example, Names String Array and Vehicles String Array were used to explain this behaviour.
  • Usage Of Intersection Function In Power AutomateFeb 04, 2022. In Power Platform, at times we must take common values present in Arrays or objects. In these scenarios, Intersection function in Power Automate can be used. As an example, Names Array and Names Object and Actual Names Array,Actual Names Objects were used to explain this behaviour.
  • Simple Paging With FetchXML On Lists In Power AutomateJan 27, 2022. In few scenarios when working on List of records for a given entity, we must provide paging to perform certain operations. In order to achieve this, we use different actions in Dataverse and power automate like do until, List Rows, Scope, Initialize, Increment and Set Variables . As an example for contacts entity with the help of changing page number dynamically with logic we can achieve this functionality.
  • Get Record Count For A List In Power AutomateJan 21, 2022. In few scenarios when working on List of records for a given entity it is needed to find out the count of total records present in that table to perform certain manipulations. Here length function in power automate can be used to get record count for a given list. As an example, contact table was considered.
  • Usage Of ChangeSet Request In Power AutomateJan 20, 2022. In certain scenarios we must bundle multiple operations together so that all should pass or fail, in any case if one of the operations fails then all the other operations gets roll backed to make atomic operations. To achieve this functionality in Power Automate we can use ChangeSet Request Action , as a business scenario operations on Contact and Task tables were considered .
  • Usage Of First And Last Function In Power AutomateJan 14, 2022. In Power Platform, for certain business scenarios we must extract first, and last characters of a given string or First and Last items present in an array. First And Last function can be used in power automate to achieve this functionality.
  • List Rows Based On Expand Query In Power AutomateJan 13, 2022. In order to get details of related entity for the selected entity without separate retrieve call we can leverage Expand Query .As a business scenario for the same vaccination use case extracting details of accounts that are present in list of contacts who took vaccination.
  • PowerApps - PCF - Input Formatter With Regular ExpressionJan 10, 2022. The benefit and advantage of this component is to dynamically apply validation pattern to HTML5 input control with the help of custom regular exppression. Along with this, it also provides some masked input types like “Date”, “DateTime”, “Time”, “Password”. Custom CSS Styles provides freedom to apply attractive styles as per design and branding. If the control is makred as Required, then input box border can be shown in red color just to highlight about invalid input. This code component is developed and distributed considering both Citizen developer and Pro developer use case scenarios. It is very simple to use and configure.
  • Getting Document ID Using Power AutomateJan 08, 2022. This article explains getting document ID using Power Automate.
  • List Contacts Based On FetchXMLQuery In Power AutomateJan 07, 2022. During certain scenarios we must work on List of records to perform certain operations like sending alerts to list of customers. In these scenarios it is critical to filter records to make sure actual requirement was met. In Power Automate, we can use FetchXMLQuery option under List Rows as an example we can see list of contacts in an environment.
  • Usage Of HTML Table In Power AutomateJan 06, 2022. In Power Platform for certain scenarios data needs to be represented in HTML Table , in those cases we can work with HTML Table Action, as an example we will show list of contacts in an HTML Table.
  • Usage Of Skip Function In Power AutomateDec 31, 2021. In Power Platform, at times we must skip few elements from an Array or few characters from a given strings. In these scenarios, Skip function in Power Automate can be used.As an example Employees String Array and Employee Name String variables are used to explain this behaviour.
  • Extract Choice Text Value In Power AutomateDec 30, 2021. In Power platform for some requirements, it is required to extract Choice values for entities. As an example, on update of Contact record, Status [Choice] Text Value will be extracted.
  • Get Lookup Field Text In Power AutomateDec 24, 2021. In Power Automate one of the common scenarios was to extract Look up Field Text which will be a nightmare for the people who are new to Power Automate about how to extract details of lookup field. As an example, on update of Contact Table, Account Details will be extracted.
  • Usage Of Join Function In Power AutomateDec 17, 2021. In Power Automate, at times we must join few items which received in the form of strings. As a scenario, response of the user was taken to show this function behavior.
  • Update A Row In An Excel Table Onedrive In Power AutomateDec 16, 2021. Most of the common usage of storing data in Excel Spread sheets and a common scenario was to update data in Spread Sheet. We can use an action Update a row into a Table in Power Automate under connector Excel Online (Business). As an example, Employee details will be updated in existing Spread sheet post sending emails in a new column Date when emails were sent through Power Automate.
  • Usage Of If Function In Power AutomateDec 10, 2021. In this article, you will learn about how to use If function in Power Automate
  • Usage of Equals Function in Power AutomateDec 02, 2021. In Power Automate, at times we must validate two values and proceed further if result is true, in these scenarios Equals function is used. As a scenario, name of the person and current years values were taken to show this function behavior.
  • Usage Of And Function In Power AutomateNov 26, 2021. In Power Automate, at times we must validate two expressions and proceed further if both the expressions are true, in these scenarios and function is used. As an scenario, name of the person and lucky number values were taken to show and function behavior.
  • Usage Of Do Until Function In Power AutomateNov 25, 2021. In Power Automate, at times we must repeat certain steps until a condition met. In these scenarios we make use of Do until function as an example counter value will be incremented till it become 3.
  • Usage Of Or Function In Power AutomateNov 18, 2021. In Power Automate, for doing validations or Function will be used. As an example, an String variable and a number is used to do this validation.
  • Usage Of Not Function In Power AutomateNov 12, 2021. In Power Automate, for doing validations Not Function will be used. As an example, an String variable used to work with Not function.
  • Usage Of Less Than Function In Power AutomateNov 11, 2021. In Power Automate, generic arithmetic operations like Less Than will be used to validate provided integer values. As an example, an integer variable used to work with Less than function.
  • Usage Of Greater Function In Power AutomateNov 05, 2021. In Power Automate, generic arithmetic operations like Greater will be used to validate provided integer values. As an example, an integer variable used to work with Greater function.
  • Usage Of JSON Function In Power AutomateOct 29, 2021. In Power Automate, at times we must work on JSON with String Values as input. We can use JSON function in power automate to convert string values to JSON and perform related operations. As an example, string values separated with comma and also xml string values are used.
  • Usage Of XML Function In Power AutomateOct 28, 2021. In Power Automate, at times we must work on strings which have XML values. We can use XML function in power automate to convert string value to XML and perform related operations. As an example, notification xml string is used here to send notification to required person.
  • Usage Of Int Function In Power AutomateOct 22, 2021. In Power Automate, at times we must work on strings which have integer values. We can use Int function in power automate to convert string value to integer and perform related operations. As an example, a small use case to increment age of a person post conversion of string value to integer value.
  • Usage Of Float Function In Power AutomateOct 21, 2021. In Power Automate, at times we must work on fraction values, float function is used to achieve this. As an example, in order to send discounts notifications to customers during festival season we make use of this fraction function to provide price of a product after discount.
  • Usage Of Bool Function In Power AutomateOct 14, 2021. In Power Automate, at times we need to take decision based on Boolean value, it could be string or Boolean value. As an example, Power outage variable with true value is considered for demonstration and then Bool function is used for condition validation.
  • Create Array Function in Power AutomateOct 08, 2021. In Power Automate, at times we need to merge 2 different strings into an Array we can use Create Array Function so that we can get easily desired result. As an example, let us see how to get an array of emails with 2 strings as well as process to merge two different arrays of questions and answers into a single array.
  • Usage Of Min Function In Power AutomateOct 07, 2021. In Power Automate, at times we need to compare values Min Function is used so that we can get easily desired result. As an example, let us see how to get Minimum age of 2 persons as well as minimum value from a given array of integers with the help of Min function.
  • Usage Of Max Function In Power AutomateOct 01, 2021. In Power Automate, at times we need to compare values Max Function is used so that we can get easily desired result. As an example, let us see how to get Maximum age of 2 persons as well as maximum value from a given array of integers with the help of Max function.
  • Usage Of Addition Function In Power AutomateSep 30, 2021. In Power Automate, at times we need to perform Addition arithmetic operations so that we can get easily desired result. As an example, let us see how to calculate total age of 2 persons with the help of Addition function.
  • Usage Of Subtraction Function In Power AutomateSep 24, 2021. In Power Automate, at times we need to perform Subtraction arithmetic operations so that we can get easily desired result. As an example, let us see how to calculate warranty period that is available in years for Generator with the help of Subtraction function.
  • Usage Of Multiplication Function In Power AutomateSep 23, 2021. In this article, you will learn about the usage of the Multiplication Function in Power Automate.
  • Usage Of Div Function In Power AutomateSep 17, 2021. In Power Automate, at times we need to perform division arithmetic operations so that we can get easily desired result. As an example, let us see how to calculate price of a candy for quick reference from a bundle cost with the use of div function.
  • Usage Of Mod Function In Power AutomateSep 16, 2021. In Power Automate, at times we need to perform Modular arithmetic operations so that we can get desired result, as an example we can see number of customers waiting for tables based on the customers present in a hotel , so that customers will get information about the number of customers waiting , so that they can plan accordingly.
  • Usage Of Range Function In Power AutomateSep 10, 2021. In Power Automate, at times we need to have array with integers starting from the specified index for doing different operations in design of online exams or quizzes to provide random questions this function would be useful.
  • Usage Of DayofWeek In Power AutomateSep 03, 2021. In Power Automate, there is a common task to extract complete day of the week from the given date, for this DayofWeek function will be used. Here in this example, we will see how to extract name of the day in a week.
  • Usage Of Add Days In Power AutomateSep 02, 2021. In Power Automate, one of the common scenarios is to do some operations on current date. So, Add Days is one of the functions of its kind which works on the current date so that certain actions like sending an email to alert or give information to user as an example here I am adding 5 days.
  • URIHost Function In Power AutomateAug 20, 2021. In Power Automate, most of the common scenario is to extract host details URI where in power automate can be used to form a dynamic url to open any record from an email link which can be achieved easily using URIHost Function .
  • Usage Of uriQuery Function In Power AutomateAug 19, 2021. In Power Automate, most of the common scenario is to extract parameters that are present in website url, which can be achieved easily using uriQuery Function as an example.
  • Usage Of Rand Function In Power AutomateAug 06, 2021. In Power Automate, in few of the scenarios we need to generate random number example to prepare a unique name with text and combination of Unique number so as to provide a quick test data then rand function is used.
  • Usage Of Encode URI In Power AutomateAug 02, 2021. In Power Automate, to return a uniform resource identifier (URI) encoded version for a string by replacing URL-unsafe characters with escape characters we can use either encodeUriComponent or uriComponent functions in expressions.
  • Quick Conversion From UTC To ISTJul 30, 2021. Power Automate, functions place an important role for conversions, in order to quickly see how to Convert UTC Time to IST Time we use Instant Cloud flow.
  • Use Of If Statement In RDec 03, 2020. In this article, we will discuss how to use one of the most common and widely used decision-making statements in R.
  • Learn About Regular Expressions In C#Oct 06, 2020. In this article, you will learn about regular Expressions in C#.
  • Using LINQ Expressions In C#Sep 18, 2020. In this article, you will learn how to use LINQ Expressions in C#.
  • C# Local Functions - Why And When To Use ThemSep 11, 2020. In this article you will learn about C# : Local Function Vs Lambda Expression.
  • 30 Days Of Python 👨‍💻 - Day 19 - Regular ExpressionsAug 11, 2020. In this article, you will learn about Regular Expressions in Python.
  • 30 Days Of Python 👨‍💻 - Day 12 - Lambda Expression And ComprehensionsJul 28, 2020. In this article, you will learn about Lambda Expression and Comprehensions.

About Expression-Web4

NA

OUR TRAINING