Function Resources

Share

Related resources for Function

Sum Function in PowerFx using Canvas App with Power Apps12/16/2024 10:40:06 AM. Learn how to use Power Fx's Sum function in Power Apps to build custom business applications quickly. This guide covers creating a simple Canvas app, using Text Box and Label controls, and integra
Min Function in PowerFx using Canvas App with Power Apps12/13/2024 12:16:52 PM. Reading this article, you can learn how to perform the Min function from Power Fx using Microsoft Power Apps. Also, you will be able to learn Text box, Label control in the Power Apps environment.
Understanding the AI_EXTRACT SQL Function in Databricks12/12/2024 7:17:56 AM. This article dives into the mechanics of AI_EXTRACT, its syntax, and various use cases with examples. AI_EXTRACT in Databricks extracts structured data, like names and dates, from unstructured text us
Max Fnction in PowerFx using Canvas App with Power Apps12/11/2024 4:51:08 AM. Reading this article, you can learn how to perform the Max function from Power Fx using Microsoft Power Apps. Also, you will be able to learn Text box, Label control in the Power Apps environment.
Average Function in Canvas App using PowerFx with Power Apps12/9/2024 6:29:35 AM. Reading this article, you can learn how to perform the Average function from Power Fx using Microsoft Power Apps. Also, you will be able to learn Slider control, Label control in the Power Apps enviro
Python Functions and Variable Scope LEGB11/29/2024 7:28:30 AM. This article explores Python variable and function scopes, including the LEGB model: Local, Enclosing, Global, and Built-in. Learn practical examples and understand scope behavior for effective coding
Azure Function to Read Incoming Message in Twilio11/27/2024 10:44:55 AM. Learn how to create an Azure Function that reads incoming SMS messages from Twilio. This tutorial covers the setup of Azure Functions, integrating with Twilio's API, and processing incoming messag
Rank Functions in SQL server11/26/2024 6:44:08 AM. In this article, we will learn about Rank functions in SQL Server, like RANK(), DENSE_RANK(), ROW_NUMBER(), and NTILE(), are used to assign rankings to rows within a result set.
User-Defined Functions in SQL Server11/21/2024 5:14:12 AM. SQL Server supports two types of User-Defined Functions (UDFs): Table-Valued and Scalar-Valued. Table-valued functions return a table based on logic, while Scalar-Valued functions return a single valu
Setting Default Dates in Power Apps: Using Today(), Date(), Year(), and DateAdd() 11/14/2024 6:39:41 AM. Learn how to set default dates in Power Apps using functions like Today(), Date(), Year(), and DateAdd(). This guide explains how to simplify date fields, enhance user experience, and improve app func
Explaining Deep Linking in Power Apps 11/12/2024 10:49:37 AM. Deep linking in Power Apps enables direct navigation to specific screens, improving user experience and engagement. By using URL parameters, custom schemes, and StartScreen functions, developers can c
Explaning AWS Lambda Function11/12/2024 7:11:04 AM. AWS Lambda is a service that computes the code without any server. It doesn't need any server running, so It is said to be serverless computer. The code is executed based on the response of events
Build an Azure Blob Trigger Function to Compress Images with Sharp11/12/2024 5:17:35 AM. This guide walks through creating an Azure Blob Trigger Function that compresses images uploaded to Azure Storage using the Sharp image processing library. It covers setting up Azure Blob Storage, co
How to Sort a List of Objects in TypeScript by Property11/9/2024 10:11:36 AM. This guide covers sorting lists of objects in TypeScript, with examples for sorting by string, numeric, and date properties. It demonstrates using the sort() method, localeCompare for strings, custom
Library Component Type in SharePoint Framework (SPFx)11/9/2024 7:06:52 AM. SPFx Library Components enable the creation of reusable, modular code in SharePoint. By centralizing utility functions, services, and UI elements, developers can enhance maintainability and consistenc
Exploring the New T-SQL Enhancements in SQL Server 202211/5/2024 5:39:41 AM. In this article we will explore the powerful new T-SQL enhancements in SQL Server 2022, including features like DATE_BUCKET, DATETRUNC, and IS DISTINCT FROM, designed to simplify data handling and opt
BIT Functions New T-SQL Enhancements in SQL Server10/30/2024 5:58:33 AM. In this article, we’ll explore some of BIT functions new enhancements in SQL Server 2022, their practical applications, and a modified example to demonstrate their usage.
Map, Filter and Reduce in TypeScript with Examples10/30/2024 5:47:41 AM. This guide provides a comprehensive overview of these essential functions, complete with practical examples to illustrate their use in real-world applications. Enhance your coding skills and streamlin
Windowing Enhancements New T-SQL Enhancement in SQL Server10/29/2024 6:29:27 AM. SQL Server 2022 introduces advanced T-SQL features, enhancing window functions, aggregations, and NULL handling. New options like the WINDOW clause and IGNORE NULLS optimize complex data queries, redu
Automate SharePoint Site Creation with Azure Functions and AD Auth10/28/2024 8:53:35 AM. This guide demonstrates how to automate SharePoint site creation using Azure Function Apps with custom Azure Active Directory (AD) authentication. It covers prerequisites, creating an Azure Function A
How Select and SelectMany Works in C#10/26/2024 5:05:45 AM. Learn key differences, practical use cases, and examples that demonstrate how these methods simplify data manipulation, making it easier to work with nested and complex data structures in C#.
TRIM Function New T-SQL Enhancements in SQL Server10/25/2024 10:44:09 AM. The enhanced TRIM function in SQL Server 2022 adds flexibility for removing unwanted characters in strings, beyond just spaces. Now, developers can use BOTH, LEADING, and TRAILING keywords to trim fro
GENERATE_SERIES Function New T-SQL Enhancements in SQL Server10/25/2024 6:06:40 AM. The GENERATE_SERIES function in SQL Server 2022 creates sequences of numbers or dates between specified start and end values, with an optional step. It's beneficial for reporting, filling data gap
Understanding the Role of Servers in Modern Networking10/25/2024 4:56:40 AM. Servers play a crucial role in modern networking by managing data storage, processing, and communications across networks. From web hosting and cloud computing to secure data transfer, servers enable
TypeScript for advanced type inference in React10/24/2024 4:43:27 AM. In this article, Ziggy Rafiq discusses advanced type inference techniques in React with TypeScript, focusing on hooks and JSX elements.
Compiling Multiple Files to Build an Application10/22/2024 10:46:04 AM. This article explains how to compile multiple C files into a single executable using the C compiler. It covers two approaches: compiling multiple files with the cc command or using the #include direct
DATETRUNC New T-SQL Enhancements in SQL Server10/9/2024 6:48:59 AM. This new feature simplifies date truncation by allowing developers to truncate dates to specific intervals, such as year, month, or day. It improves query performance and data manipulation in SQL.
Exploring Aggregate Functions in Azure Cosmos DB10/7/2024 4:43:48 AM. Aggregate functions in Cosmos DB allow efficient data summarization and analysis across multiple documents. They perform calculations such as AVG, COUNT, SUM, MAX, and MIN to retrieve meaningful insig
DATE_BUCKET Function New T-SQL Enhancements in SQL Server10/5/2024 6:28:43 AM. This article will delve into the DATE_BUCKET function, its syntax, and its practical use cases using the AdventureWorks2022 sample database. We’ll also compare DATE_BUCKET with other similar T-SQL fun
NTile Function in SQL Server10/3/2024 11:44:37 AM. The NTile function in SQL Server divides a result set into a specified number of groups, assigning ranks to records within each group. Unlike Dense_Rank, NTile focuses on groups rather than individual
Understanding Service, Factory, And Provider10/3/2024 11:38:34 AM. AngularJS provides three methods for creating reusable utilities: Service, Factory, and Provider. All serve the same purpose but differ in implementation. Services are singletons, Factories return new
How To Create An HTTP Trigger Azure Function App Using Visual Studio 201710/1/2024 8:24:46 AM. Azure Functions is a serverless cloud solution that allows you to run code on-demand without managing infrastructure. It supports multiple programming languages, offers a pay-per-use pricing model, an
What is the Filter Function in Power Apps9/30/2024 11:14:40 AM. The Filter function in Power Apps allows users to narrow down data sets by applying specific criteria. It is essential for creating dynamic applications that require user input to display relevant inf
What is the Collect Function in Power Apps?9/30/2024 8:32:00 AM. Power Apps enables users to create custom applications with minimal coding, utilizing features like the Collect function for data management. This function allows dynamic storage of various data types
Rank and Dense_Rank Function in SQL Server9/30/2024 4:48:24 AM. RANK and DENSE_RANK functions in SQL Server assign sequential numbers to rows based on ordering. RANK skips numbers for ties, while DENSE_RANK does not. Both can partition results using the PARTITION
User Record Management in C9/29/2024 5:22:32 AM. This content focuses on implementing functions in C programming to efficiently add and display user records. It covers the creation of structures for storing user details, such as name, age, and conta
How to Download Code from Your Azure Function App9/27/2024 5:59:14 AM. In this article, we will learn how to easily download code from your Azure Function App using built-in tools like the Azure Portal, App Service Editor, or source control integration.
Getting Dynamic Input Value and Post to the AJAX function9/27/2024 3:20:29 AM. This article explores how to dynamically retrieve input values from a user interface and send them to an AJAX function for processing. It covers essential concepts like event handling and asynchronous
Solid Introduction to Expression Trees in C#9/26/2024 4:50:55 AM. This article provides a comprehensive introduction to Expression Trees in C#. You'll learn about their structure, how they represent code as data, and their applications in LINQ queries.
Implement Insert, Update and Delete Functionality in the WebGrid: Part 19/24/2024 11:54:26 AM. In this tutorial, we introduce how to implement essential CRUD (Create, Read, Update, Delete) functionality in a WebGrid. This is Part 1 of a series, focusing on adding new records, updating existing
What is the Notify Function in Power Apps?9/23/2024 5:09:43 AM. The Notify function in Power Apps displays messages to users, providing instant feedback on their actions. It supports various notification types, such as success, error, warning, and information, hel
A Comprehensive Guide to Migrating Azure Functions C# to C# 12 with .NET 8 Isolated9/21/2024 4:12:20 AM. Ziggy Rafiq shows how to leverage modern C# features, and how to optimize the performance and scalability of Azure Functions by migrating them to .NET 8 Isolated Processes.
Learn Higher Order Functions in JavaScript9/18/2024 4:33:53 AM. A higher-order function in JavaScript is a function that takes another function as an argument, returns a function, or both. This allows for reusability, code abstraction, and functional programming.
How to create a language translator using Google's API and JavaScript9/17/2024 10:42:21 AM. This article demonstrates how to create a language translator using the Google API and JavaScript. It covers integrating the Google API for translating text, contrasting it with previous methods like
Dealing With Excel Sheets9/17/2024 10:25:24 AM. Learn essential techniques for managing Excel sheets effectively! This guide covers everything from basic data entry and spreadsheet formulas to advanced features like automation and troubleshooting.
Build a Smart Private Chatbot with Semantic Kernel and APIs9/12/2024 4:23:50 AM. This guide covers integrating advanced NLP techniques and machine learning to create a secure, efficient, and customizable AI chatbot with robust data privacy.
Creating Azure Functions For SharePoint Operations Using Managed CSOM9/10/2024 11:53:12 AM. This article explains how to create Azure Function Apps to perform SharePoint operations using Managed CSOM code. It covers setting up an HTTP-triggered function, uploading required assembly files via
Centralizing String Utility Functions in Java9/10/2024 6:26:13 AM. This article explains how to consolidate common string utility functions in Java by creating a utility class like StringUtils. It covers methods for checking if a string contains only alphanumeric cha
Learn Factory Functions in JavaScript9/10/2024 4:25:39 AM. In this article, we will learn about Factory Functions in JavaScript. This article introduces factory functions in JavaScript, demonstrating how they create objects efficiently without code duplicatio
Working With Azure Functions From SharePoint Components9/9/2024 11:48:43 AM. This article explains how to trigger Azure functions from SharePoint pages using HTTP trigger functions. It covers creating a SharePoint list from an Azure function using C# and SharePoint CSOM, passi
SQL: Not Using Aggregate Function in WHERE Clause, instead, Using HAVING Clause9/5/2024 12:51:37 PM. This article will discuss the issue that SQL: Not Using Aggregate Function in WHERE Clause, instead, Using HAVING Clause
Atan2 Function From Power Fx Using Power Apps9/3/2024 6:26:24 AM. Reading this article, you can learn how to perform Atan2 function from Power Fx using in Microsoft Power Apps. Also, you will be able to learn Button control, Label control and TextInput control in th
Harnessing the Power of Function Calling with Local LLMs using Ollama8/25/2024 11:45:29 AM. Function calling with Local LLM (Ollama) using C# Semantic Kernel.
Type Of Functions In Javascript8/21/2024 10:46:06 AM. This content explores various types of functions, including function declarations, expressions, arrow functions, and callbacks, offering insights into their usage, syntax, and differences in JavaScrip
CountDown Timer in JavaScript8/21/2024 6:07:01 AM. This article demonstrates how to implement a countdown timer using JavaScript's setTimeout method. It explains how to create a countdown function that updates the display every second, integrating
Describing Musical Domain with F#8/20/2024 7:47:25 AM. It covers domain-specific language (DSL) creation, music representation, algorithmic composition, and sound synthesis, showcasing how F# can facilitate advanced music analysis and generation.
Image Scaling by Slider Using HTML58/16/2024 5:02:08 AM. Learn how to scale images dynamically with an HTML5 slider in this tutorial. Using the drawImage method on a canvas element, we adjust image size based on slider input. The article covers HTML setup,
Func, Action And Local Function In C# 78/9/2024 12:03:08 PM. This article covers using Func, Action, and local functions in C# 7. It explains how Func returns a value, Action does not, and how local functions can be defined within other methods. Examples includ
How to Call JavaScript Function in Angular 18 Component?8/8/2024 9:38:18 AM. Learn how to integrate JavaScript functions within an Angular 18 component. This guide covers how to call and use JavaScript functions effectively in your Angular components, ensuring seamless interac
Understanding the NTILE Window Function in SQL8/7/2024 4:10:20 AM. Understanding the NTILE Window Function in SQL" delves into the NTILE function, a powerful SQL tool used to divide result sets into a specified number of roughly equal groups.
Understanding ROW_NUMBER() in SQL Window Functions8/2/2024 4:46:39 AM. ROW_NUMBER() is a window function in SQL that assigns a unique number to each row within a partition of a result set. It’s useful for ranking, removing duplicates, pagination, and selecting the top N
Count(*) vs Count(1) in SQL8/1/2024 4:11:33 AM. When counting rows in SQL databases, both `COUNT(*)` and `COUNT(1)` are used, but there is no performance difference between them. Modern databases optimize both functions similarly. Prioritize code r
@@ROWCOUNT in SQL Server7/29/2024 9:28:40 AM. @@ROWCOUNT is a SQL Server function used to retrieve the number of rows affected by the last executed statement. It provides valuable insights for data manipulation and validation processes, helping t
Blazor Web Assembly 3.2 Add/Edit/Delete Fully Functional Application - Part One7/29/2024 8:37:43 AM. This article guides you through creating a Blazor web assembly app with .NET Core hosting. It covers setting up .NET Core APIs, Entity Framework Core for SQL Server data access, and implementing CRUD
Functionality of DMA in C Programming7/28/2024 1:08:57 PM. Direct Memory Access (DMA) in C programming is a powerful technique for efficient memory management and data transfer. It allows peripherals to directly access memory without CPU intervention, enhanci
JavaScript Functions to Simplify Your Code7/26/2024 5:02:58 AM. Discover how to streamline your JavaScript code with our comprehensive tutorial on essential functions. Learn best practices, coding tips, and techniques to simplify your programming. Perfect for begi
SQL Essentials: GROUP BY vs. PARTITION BY Explained7/26/2024 4:08:59 AM. Discover how GROUP BY aggregates data into summary rows, while PARTITION BY divides data into partitions for window functions. Master these techniques to enhance your SQL querying skills.
Tracking Visits and Visitor Details on PowerApps Page7/25/2024 12:07:39 PM. Learn to track unique page views in PowerApps by integrating SharePoint lists and using global variables. This guide covers designing lists, configuring PowerApps screens, and patching view counts. It
Understanding flatMap in Java7/23/2024 7:42:33 AM. The flatMap operation in Java is a powerful tool for transforming and flattening collections. Learn about Java's `flatMap` operation in this article, which maps each element to a stream and flatte
Detailed Explanation of Procedure and Function in SQL Server7/22/2024 6:22:57 AM. Stored procedures are precompiled sets of one or more SQL statements that can be executed together. Functions in SQL Server are essential database objects that contain a series of SQL statements and p
Practical approach to EF Core with Scalar functions7/21/2024 6:32:25 PM. Learn how to implement and migrate scalar SQL functions in an ASP.NET Core application using Entity Framework Core. This guide covers creating a scalar function to calculate total unit prices, integra
Understand jQuery Ajax Function: Call Web Service Using jQuery Ajax Method7/18/2024 3:19:09 PM. Learn how to use the jQuery Ajax function to call web services and code-behind C# methods. This guide is perfect for novice developers. It covers creating a simple web service, setting up jQuery Ajax
Understand jQuery Ajax Function: Read XML Data Using jQuery Ajax Function7/18/2024 3:18:31 PM. This guide delves into using the jQuery Ajax function to read and parse XML data efficiently. It covers the basics of jQuery and Ajax, demonstrating how to make asynchronous requests to fetch XML file
How to Call C# Method/Function Using jQuery Ajax7/18/2024 3:18:09 PM. Learn how to call a C# method or function using jQuery Ajax in this step-by-step guide. We'll cover setting up your ASP.NET backend, writing the C# code, and creating the jQuery Ajax call to inter
Save as draft and Submit with required, optional functionality and by default required functionality in PowerApps7/18/2024 10:24:46 AM. This is most required feature in any app. If the form is lengthier, it is very useful feature. Any user can fill in the half of the forms and save the form as draft. Later can come in and pickup the f
Interactive Rating Control in PowerApps7/17/2024 2:23:06 AM. Explore the integration of rating controls in social media and user-interactive applications using SharePoint lists. Learn about setting display modes, default properties, and user validations to enha
Error handling in Transact-SQL (T-SQL) 7/13/2024 10:59:58 AM. Effective error handling in T-SQL (Transact-SQL) is vital for managing unexpected issues in database operations. Using TRY-CATCH blocks, RAISEERROR, and error functions like ERROR_MESSAGE and ERROR_NU
How to Convert varbinary to Base64 String in SQL Server7/12/2024 8:47:14 AM. Learn how to convert varbinary data to Base64 strings in SQL Server using XML functions and the CAST method. This tutorial provides clear steps and SQL examples for encoding binary data, crucial for w
Lambda Functions and High Order Functions in Android kotlin7/11/2024 4:59:01 PM. The provided Kotlin examples demonstrate basic and high-order functions. In lambda. kt, a lambda function adds two integers. In HighOrder.kt, a high-order function accepts another function as a parame
JavaScript - Closures Demystified7/10/2024 12:38:31 PM. Function closures in JavaScript encapsulate variables from their defining scope, allowing functions to retain access to these variables even when executed outside that scope. This tutorial explores cl
ACot function from Power Fx using Power Apps7/10/2024 9:23:53 AM. Build custom business apps swiftly with Power Apps, leveraging Power Fx for low-code development across Microsoft Power Platform. Learn to implement the ACot function and utilize Button, Label, and Te
Cot function from Power Fx using Power Apps7/10/2024 4:28:42 AM. Reading this article, you can learn how to perform Cot function from Power Fx using in Microsoft Power Apps. Also, you will be able to learn Button control, Label control and TextInput control in the
Azure Functions Hosting Models: In-Process and Isolated Models7/8/2024 8:37:11 AM. Explore Azure Functions' hosting models: In-Process offers low latency and simplicity with shared process hosting, while Isolated ensures enhanced isolation and custom dependencies with each funct
Essential Components of Prompt Design in GPT's Search7/8/2024 4:49:51 AM. Explore the crucial elements of prompt design within GPT's search capabilities through a comprehensive analysis. Delve into the intricacies of optimizing natural language prompts for enhancing use
Understanding @wraps in Python: Preserving Function Metadata7/7/2024 6:28:30 PM. Explore the intricacies of Python's @wraps decorator, essential for preserving function metadata. Learn how @wraps simplifies debugging, maintains docstrings, and ensures correct function signatur
Ranking Functions in SQL: RANK, DENSE_RANK, and ROW_NUMBER7/3/2024 12:19:25 PM. Learn how these powerful functions operate within SQL queries to assign ranking values based on specified criteria, enhancing your ability to analyze and manipulate data efficiently in relational data
What are Custom Hooks in ReactJS7/3/2024 9:19:26 AM. Custom Hooks in ReactJS empower developers to extract reusable logic from components into standalone functions, enhancing code organization and reusability. They encapsulate stateful logic, side effec
PDF Viewer Search functionality in Telerik UI for .NET MAUI7/3/2024 9:07:41 AM. Enhance your mobile and desktop applications with robust search functionality using the PDF Viewer in Telerik UI for .NET MAUI. Easily integrate and navigate through PDF documents with advanced search
Connect to Dynamics CRM with Dataverse from Azure Function7/3/2024 4:46:56 AM. Connect seamlessly to Dynamics CRM using Azure Functions with Dataverse integration. Learn how to leverage serverless computing to automate data processes and enhance business workflows.
Understanding the PowerApps GroupBy Function7/2/2024 7:03:28 AM. Learn about PowerApps' GroupBy function syntax and limitations. It's effective for grouping text, number, date, and duration columns but doesn't support Choices and Lookup columns. Essenti
Learn Use of Lambda Operator in C#7/1/2024 6:28:21 AM. Explore the versatility of lambda expressions in C#, powerful tools for creating inline functions without the need for traditional method declarations. Discover their syntax, applications in LINQ quer
The Functioning of Array of Integer Pointers6/30/2024 3:19:12 PM. In C programming, an array of integer pointers is declared similarly to a regular integer array, with the primary distinction being the addition of an asterisk (*) before the array name.
Understanding React Hook at a Glance6/28/2024 6:36:47 AM. React Hook at a Glance" provides a concise overview of React Hooks, the revolutionary feature introduced in React 16.8 that allows developers to use state and other React features in functional c
IIF in Microsoft SQL Server6/28/2024 6:29:20 AM. IIF function in SQL, also known as "Immediate If," provides a concise way to perform conditional evaluations within queries. It allows SQL developers to return different values based on whet
The Implementation of Pointer to Function6/27/2024 11:58:19 AM. This content explores the implementation of pointers to functions in C and C++ programming. It delves into their syntax, usage, and benefits, such as dynamic function calls, callback functions, and ef
Find and Replace in PowerApps6/27/2024 10:52:39 AM. Learn to streamline data entry and enhance user experience by implementing powerful text manipulation techniques within your canvas apps, leveraging Microsoft's Power Platform capabilities seamle
App Settings in App Service Vs App Configuration Resource in Azure6/24/2024 9:19:22 AM. Learn the distinctions between Azure App Settings and Azure App Configuration for effective application configuration management in Azure. Azure App Settings are tailored for individual FunctionApps/A
API vs Service vs Function Connections in Azure Logic Apps6/24/2024 9:08:23 AM. Azure Logic Apps helps automate tasks, business processes, and workflows by connecting to various services. API Connections integrate with third-party and Azure APIs, Service Provider Connections dire
Adding Facebook Share Functionality To An ASP.NET Website With A Master Page6/24/2024 9:02:49 AM. Learn how to add Facebook share functionality to your ASP.NET website with a master page. This guide provides step-by-step instructions to integrate the Facebook Share button, enabling seamless social
Integrating Azure SQL Database with Azure Functions - Azure Essentials Series - Ep: 46/24/2024 8:23:23 AM. In this episode, you'll learn how these two services can work together to build scalable, serverless applications that efficiently manage and process data.

Topics