Resources   No resource found

• Microsoft Fabric Update: You Can Now Adjust Column Width in the SQL Analytics Endpoint User InterfaceJun 26, 2026. This article is about the new feature in Microsoft Fabric that allows you to adjust column width
• How to Implement Soft Delete in SQL Server Using Flag ColumnsMay 04, 2026. Implement soft delete in SQL Server using flag columns for data preservation, audit trails, and recovery. Learn best practices, advantages, and real-world use cases.
• How to Dynamically Add Choices in SharePoint Choice Column using Power AutomateApr 30, 2026. Learn how to dynamically update SharePoint choice columns with Power Automate! This tutorial uses _api/contextinfo to automate choice options, saving time and ensuring accuracy.
• SharePoint Lookup Column Threshold in PowerApps Custom FormsApr 06, 2026. Overcome the SharePoint lookup column threshold in PowerApps! Learn why it happens and how to fix it by simplifying forms and data structures for optimal performance.
• How to Add Theme Switcher in Web Apps (Light, Dark & Custom Colors)Mar 24, 2026. Explore column themes for web design! Customize backgrounds with white, black, pink, blue, or yellow. Enhance user experience and accessibility. Learn how!
• What Are the Different Types of NoSQL Databases?Mar 11, 2026. Learn the four main types of NoSQL databases including document, key value, column family, and graph databases. Understand their architecture, use cases, and real world examples.
• Understanding Indexed Columns in SharePointMar 11, 2026. Optimize SharePoint list performance! Learn how indexed columns speed up filtering, sorting, and queries in large lists, bypassing the 5,000-item threshold. Improve PowerApps & Automate flows.
• How to Fix Delegation Warnings and Handle 10,000+ Records in Power Apps with SharePointFeb 26, 2026. Delegation issues can break your Power Apps solution when working with large SharePoint lists. This article explains why delegation warnings occur and provides a practical, step-by-step solution to build scalable, high-performance apps without data loss.
• How to Fix “Cannot insert NULL into column Srno” When Srno Must Be Auto-Increment (SQL Server)Feb 27, 2026. Fix "Cannot insert NULL into column 'Srno'" in SQL Server when Srno should auto-increment. Learn a production-safe solution involving temporary tables and foreign keys. Avoid data loss and table name changes!
• How to Fix Patch Not Working & Duplicate Records in Power AppsFeb 27, 2026. Solve Power Apps Patch issues! Prevent duplicate records and silent failures when saving data to SharePoint. Learn to update or create records reliably using LookUp. In real-world Power Apps projects, Patch failures and duplicate SharePoint records are common challenges that impact data integrity and user experience. This article explains the root causes behind these issues and how to handle them effectively. Learn practical techniques like proper form validation, conditional Patch logic, and duplicate checks. A real-world scenario walkthrough makes it easy to implement these solutions in your own apps.
• How to Filtering a SharePoint Choice Column at the App LevelFeb 27, 2026. Control SharePoint Choice column options in Power Apps without modifying the list! Filter choices based on user roles for tailored dropdown experiences. Keep your data clean!
• How to Configure and Use Validation Settings in SharePointFeb 20, 2026. Master SharePoint validation! Learn to configure column & list validation for data accuracy. Enforce rules, prevent errors, and improve data quality in SharePoint lists.
• How to Get Image from a SharePoint Image Column Using Power AutomateFeb 18, 2026. Struggling to extract images from SharePoint image columns in Power Automate? This guide provides a simple solution to retrieve and use those images in your flows. Learn how to access image data and automate image extraction for email attachments or other integrations.
• How to Use SharePoint Calculated ColumnsFeb 12, 2026. Automate calculations in SharePoint lists using calculated columns! Learn to create dynamic formulas for text, numbers, dates, logic, and more. Boost productivity!
• How to Create or Update a Lookup Column Using Web API in Power PagesJan 29, 2026. Learn how to create and update lookup columns in Power Pages using the Web API. This guide covers configuration, table permissions, and web role assignments for seamless integration.
• Understanding the LOOKUPVALUE DAX Function in Power BIJan 17, 2026. In this article, I demonstrated how to master the LOOKUPVALUE DAX function in Power BI W lean how to fetch values between tables without relationships, similar to VLOOKUP, and when to use it effectively.
• Understanding Filter rows and Expand Query in Dataverse (Power Automate)Dec 29, 2025. Unlock Dataverse power in Power Automate! Learn to efficiently filter and retrieve related data using Expand Query and Lookup Columns. Optimize flows and boost performance.
• Working With SharePoint Choice Columns in Power AppsDec 23, 2025. Master SharePoint choice columns in Power Apps! Learn to use Choices(), LookUp, Filter, and Patch with clear examples. Handle single & multi-select fields effectively.
• How to get lookup column records in Power Pages using Web APIDec 19, 2025. Learn how to retrieve data from Dataverse lookup columns in Power Pages using Web API and JavaScript. Access related records efficiently and securely with practical examples.
• How to Save Microsoft Forms Multi-Select Choices to a SharePoint Multi-Select Choice ColumnDec 12, 2025. Learn how to seamlessly transfer multi-select answers from Microsoft Forms to a SharePoint multi-select choice column using Power Automate. Streamline your data collection!
• How to Check if a SharePoint Rich Text Column Is Blank in Power AutomateDec 08, 2025. Struggling with blank SharePoint Rich Text columns in Power Automate? This guide provides a step-by-step solution to accurately identify and handle empty fields, ensuring reliable flow execution. Learn to convert HTML to text and trim unwanted content!
• Measures vs Columns in Power BI: Understanding the DifferenceDec 09, 2025. This articles explains what is measure and calculated column and difference between both in simplied manner.
• A Complete Guide to Auto-Fetching RSS Feed Images and Storing Them in a SharePoint Image Column Using Power AutomateDec 09, 2025.
• How to Create or Update Multi-Select Person or Group Column in SharePoint Using Power AutomateDec 07, 2025. Learn how to create or update SharePoint multi-select Person or Group columns using Power Automate, including validating Office 365 users to skip invalid emails and ensure reliable, error-free flows execution.
• Building Dynamic Reordering Functionality in Power Apps Using Up/Down Arrow IconsDec 01, 2025. Effortlessly reorder items in your Power Apps Gallery with up/down arrow icons! This tutorial provides a simple, intuitive solution for dynamic record arrangement, improving user experience and control. Perfect for navigation menus, task prioritization, and more.
• Dynamic Row & Column Permission System (Field-Level Security Using a Rule Engine)Nov 19, 2025. Implement dynamic row and column-level security for enterprise apps. Centralize permissions, enforce rules at the API, and mask sensitive data. Enhance security and compliance.
• Dynamic Row & Column Permission System | Field-Level Security and Rule Engine for Angular + .NET ApplicationsNov 19, 2025. Implement dynamic row & column permissions in Angular & .NET apps. Secure sensitive data with field-level security, a rule engine, and metadata-driven access control.
• Building a Universal Data Import Wizard — mapping columns, preview, validationNov 18, 2025. Build a robust Angular data import wizard! Map columns, preview data, validate entries, and ensure secure, scalable imports. Includes code snippets & best practices.
• How to Construct a Toeplitz Matrix from a Given Row and Column in PythonOct 07, 2025. This article provides a comprehensive guide on constructing Toeplitz matrices from a given row and column, highlighting their significance in signal processing, particularly in wireless communication systems like 5G. Learn how to leverage SciPy for efficient implementation, explore real-world applications, and optimize performance for faster computations. Discover how this matrix structure bridges abstract algebra and practical engineering for high-speed, low-latency connections.
• How to Split Columns Easily in Fabric Dataflow Gen2Oct 01, 2025. Learn how to easily split columns in Microsoft Fabric Dataflow Gen2 to transform unstructured data into a structured format for better analysis. This guide covers splitting columns by delimiters like commas and semicolons, enabling you to parse skills, locations, or product codes. Streamline your data preparation workflows and unlock valuable insights in Power BI and Fabric Lakehouse with this powerful transformation technique. Master Dataflow Gen2 for efficient data reshaping!
• Fetch Column Headers from Excel Files in a Folder using Power AutomateAug 15, 2025. In this article its mainly focus on extracting the column header names from multiple excel sheet stored in a folder using Power Automate.
• Architecting Reusable Metadata (Site Columns) with Content Type HubAug 15, 2025. Even though I’ve worked with the Content Type Hub in several projects, I often found it confusing to set up and wasn’t always sure which best practices to follow. This time, I’ve been given a unique requirement that lets me combine what I’ve learned before with a fresh point of view. It finally feels like the right time to share my experience based on real, hands-on work.
• Dataverse Gets Smarter! Introducing Prompt Columns in Power PlatformAug 07, 2025. If you're working with Microsoft Power Platform, especially Dataverse, here’s a cool update you should know about – a new column type called "Prompt" is now available (in preview as of writing this post).
• Create SharePoint Lists and Columns in SPFx Using PnPjsAug 04, 2025. Learn how to use PnPjs (spfi) in SPFx to dynamically create various SharePoint list columns like text, number, date, choice, and lookup fields using addFieldAsXml for seamless customization and automation.
• How to Use PnPjs in SPFx to Query SharePoint List ColumnsJul 11, 2025. Learn how to configure PnPjs in your SharePoint Framework (SPFx) project and query all common SharePoint column types including Lookup, Person, Choice, and more.
• Hide Column Headers and Show Row Headers in C#Jul 08, 2025. Learn how to display DataGridView data horizontally in a WinForms application. This article shows you how to set up row headers, add columns, and rotate data display programmatically.
• How Indexed Columns Improve SharePoint List SpeedJun 04, 2025. Indexed columns in SharePoint help improve list and library performance by allowing faster filtering and searching, especially in large lists with thousands of items.
• How to Use the Sort Function in Power Apps with Dynamic Column Values from a SharePoint ListMar 22, 2025. This article covers features, advantages, disadvantages, and step-by-step instructions to enhance your data management and user experience.
• Efficiently Splitting SharePoint Column Values Using Power Apps Split FunctionMar 20, 2025. This article explores how to use the Split function in Power Apps to dynamically extract and display the first and last names from a full name stored in a SharePoint list's people picker column.
• Reduce NULL Storage in SQL Server with Sparse ColumnsFeb 05, 2025. SQL Server Sparse Columns optimize storage by not allocating space for NULL values, improving efficiency. They support filtered indexes and column sets for dynamic queries but add a 4-byte overhead for non-NULL values, requiring careful use.
• How to Concatenate Dynamic Column Values in Power AppsJan 23, 2025. Learn to use the Concatenate function in Power Apps to combine dynamic column values in a gallery. Simplify data presentation, reduce redundancy, and enhance user experience with this versatile tool for custom business applications.
• Add Data Bars UI in SharePoint List Column Formatting in SharePoint ListJan 01, 2025. This article walks you through the process of customizing your SharePoint list columns for better data visualization and enhancing the current view with conditional formatting to display dynamic, visually appealing data bars.
• Using Derived Column Task in SQL Server Integration ServicesDec 30, 2024. The Derived Column Task in SQL Server Integration Services (SSIS) allows you to transform or modify data within your ETL process. It enables the creation of new columns or updates to existing ones using SSIS expressions.
• Understanding List Column Data Types in SharePoint Oct 15, 2024. SharePoint allows users to create and manage lists with various column types, such as text, number, date, and lookup fields. These columns help organize and store data effectively, ensuring better reporting and data integrity.
• Database Dictionary (1-1) --- Server, Database, Schema, Table and ColumnSep 24, 2024. This article is to discuss the major schemata in SQL server.
• Dynamic SharePoint Column Creator with jQuerySep 24, 2024. Unlock the power of SharePoint with our Dynamic SharePoint Column Creator using jQuery! This innovative tool allows users to effortlessly create and customize columns in SharePoint lists.
• Trigger Approval flow with SharePoint Column FormattingSep 21, 2024. To trigger a workflow with a button using column formatting in SharePoint, you can create a column that uses JSON formatting to display a button that, when clicked, initiates a workflow.
• How to Keep SQL Server Table Columns in SyncSep 19, 2024. how to keep columns in sync across SQL Server tables using efficient methods like triggers, SQL scripts, and the MERGE statement.
• Site Column & List Column and Site Content TypeSep 03, 2024. This article covers SharePoint's Site Columns, List Columns, and Site Content Types. It explains the differences between Site and List Columns, including their scope, reusability, and management.
• jQuery DataTable Plugin to Customize Tables in Power Pages PortalJul 19, 2024. How to integrate the jQuery DataTable Plugin into custom tables within the Power Pages Portal. The DataTable Plugin enhances tables by providing features such as pagination, column filtering, efficient search capabilities, and customizable styling.
• Dynamically Creating a Table in SQL Server from Information SchemaJul 19, 2024. This SQL script dynamically creates a table in SQL Server by utilizing INFORMATION_SCHEMA and system views. It constructs the table definition, including columns, data types, constraints, and default values.
• Working with Choices Columns in Dataverse using Power AutomateJul 03, 2024. Over the past few months, I've led a project using the Power Platform, achieving remarkable results. Today, I will share tips on working with Choices Columns in the Dataverse. Unlike SharePoint, Dataverse assigns unique IDs to each choice, requiring specific handling in Power Automate and PowerApps,
• How to Seed Identity in SQL ServerJul 03, 2024. Discover SQL Server's IDENTITY columns for automatic unique number generation. Learn to create tables with IDENTITY, insert data without specifying IDs, seed values with DBCC CHECKIDENT, manage explicit ID insertions with IDENTITY_INSERT, and reset identity seeds using TRUNCATE TABLE.
• Create Different Values in Same Dropdown Control in PowerAppsJul 03, 2024. Learn to customize dropdown values in PowerApps based on form requirements. Explore methods for different forms requestor and approver using single-line text or choice columns. Ensure data integrity and usability with dynamic dropdowns tailored to user roles and project phases.
• Query to find Table Name, Row Count, Column Count and Data SizeJul 02, 2024. This guide covers techniques to query and display table names, row counts, column counts, and data sizes efficiently. Ideal for database administrators and developers seeking to optimize data management and performance analysis.
• Dataverse Multi Choice Columns in PowerAppsJul 02, 2024. Discover how to efficiently work with PowerApps and Dataverse, specifically focusing on handling Multi Choice Columns. Learn how to use the Concat function to display multi-choice values in a label within a vertical gallery. Enhance your PowerApps skills with this practical guide!
• Updating Lookup Columns in Dataverse with Power AutomateJul 02, 2024. Navigating Lookup Columns in Dataverse using Power Automate requires precise handling. Unlike simpler data sources, such as SharePoint, updating these columns demands using a specific format like "Contacts(83c259e2-1039-4110-af70-79f353dc92a5)".
• Understanding the PowerApps GroupBy FunctionJul 02, 2024. 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. Essential for efficient data organization in PowerApps applications.
• How to Remove Extra Column from DataGrid WPF ControlMay 31, 2024. The WPF DataGrid often displays an extra column due to default behavior. This issue arises when the source data contains fewer columns than displayed. By adjusting the XAML code and setting the ColumnWidth attribute to "*", the extra column can be removed, ensuring proper alignment of data in the DataGrid.
• Enhance Your Blazor QuickGrid with Dynamic with Button on ColumnsMay 16, 2024. Learn how to enhance your Blazor QuickGrid by adding dynamic buttons to columns. This tutorial explores integrating interactive buttons within column cells, offering users tailored actions and improved functionality.
• Column Values Reverse Order in SQLMay 08, 2024. Learn how to reverse the order of column values in SQL using the ORDER BY clause with the DESC keyword. This tutorial covers sorting data in descending order, manipulating column values, and enhancing database management skills.
• How to Create Calculated Column in SharePoint OnlineMar 22, 2024. SharePoint Online offers robust tools for collaboration and data organization. Learn how to update calculated column formulas to adapt to evolving business needs seamlessly. Follow a step-by-step guide to configure formulas, ensuring accurate data and enhancing analysis capabilities.
• React Apexcharts: Create & Download Column Bar Chart with BootstrapMar 16, 2024. In this tutorial, we will learn how to create a vertical column bar chart component in the React JS functional component. Creating a Column Bar Chart component in React using Apexcharts and Bootstrap. Configure data and options for visualization.
• How Indexing Columns works in SharePoint Online?Mar 11, 2024. This article illustrates the process of creating an index column within SharePoint Online List/Library to enhance the efficiency of querying and retrieving results from SharePoint Online List/Library.
• Fromula-Based Columns in Dataverse TablesMar 05, 2024. This content discusses the concept of formula columns in Microsoft Dataverse tables, highlighting their functionality in displaying calculated values using Power Fx, a user-friendly programming language. It provides steps on how to add a formula column and explores various use cases and limitations associated with this feature.
• Understanding Grouping by Columns in SharePoint ListsMar 04, 2024. In this article, we will discover how to efficiently organize and manage data in SharePoint Lists by understanding the powerful grouping capabilities.
• Calculated Columns vs. Measures in Power BIFeb 29, 2024. In this article, calculated columns and measures are crucial in Power BI for robust data analysis. Calculated columns, akin to spreadsheet columns, are static and impact data refresh performance. Measures, dynamic calculations, enhance report efficiency, adapting to context changes.
• 2D Array with Matrix Multiplication in C ProgrammingFeb 28, 2024. A double subscripted variable, also known as a two-dimensional array, is a variable that has two subscripts assigned to it in order to represent a list of items.
• Power Automate Flow to Update Sharepoint Column ValueFeb 27, 2024. In this article, I will be explaining how you can update the old value to the new value in the SharePoint list column using power automate flow.
• Clustered Column Chart in Power BIFeb 23, 2024. A clustered column chart in Power BI will allow easy customization and formatting. Users can adjust the colors, labels, and axes to better suit their needs and preferences.
• Date and Time Column Behavior in SharePoint List/LibraryFeb 12, 2024. In this article, we will learn how managing date and time column conversions in applications becomes challenging when your organization spans multiple offices across different time zones.
• Filter PowerApps Gallery with Column Chart SelectionFeb 11, 2024. In this article, explore how to enhance PowerApps with interactive features. Learn to synchronize column chart selections to filter galleries seamlessly for a more dynamic user experience.
• Understanding Site Column in SharePointJan 09, 2024. What is a Site Column in SharePoint, How to create a Site Column, and what are the benefits of a Site Column? This guide explores the importance of site columns in SharePoint Online, detailing their role in ensuring consistency, reusability, and improved content organization.
• How to Create Pyramid in C#?Oct 18, 2023. This article explains how to create a pyramid pattern using asterisks in the C# programming language. This pattern is created by printing rows of asterisks, with each row containing an increasing number of asterisks, creating the shape of a pyramid. It also explains the purpose of each line of code in the provided C# program.
• Retrieve All Column Values with PnP JS in SPFxSep 20, 2023. In this blog post, we'll delve into the process of extracting various field values from a SharePoint list using PnP JS, demonstrating how this can seamlessly integrate with SharePoint Framework (SPFx) for enhanced functionality.
• Update Size of File Column in Dataverse TableSep 17, 2023. This article will walk you through that how we can update the size of already created file type column in Dataverse table.
• Using PowerApps Filter Function for All SharePoint List ColumnsSep 06, 2023. This blog will show you how to use the Filter function to organize information in different SharePoint list columns, whether they contain words, numbers, dates, or choices. We'll make it easy with step-by-step instructions, so you can set up filters and customize your app's look. Get the most out of your SharePoint data by learning how to use the Filter function in PowerApps effectively.
• How to Use the Dataverse Patch Function?Aug 11, 2023. In this article, we'll delve into the utilization of the patch function for generating a record within a Dataverse custom table. This will encompass tables with intricate columns such as lookup, user, file, image, etc.
• Column And Row In Jetpack ComposeAug 07, 2023. In this article, We will learn about Row and Column in Jetpack Compose.
• Create Various Types of Charts in Word Documents in C# and VB.NETJul 17, 2023. By creating charts in your Word document, you can enhance the impact of your content and make it more engaging and informative for your readers. In this article, we will explore how to create Column Chart, Line Chart, Pie Chart, Bar Chart, Scatter Chart, Bubble Chart, 3D Surface Chart in a Word document using C# and VB.NET.
• Build PowerApps Gallery with Four Column LayoutJun 28, 2023. In this solution, a step-by-step guide is provided to design a gallery control with multiple columns and rows. The process involves selecting a blank vertical gallery, setting the data source, configuring properties such as size and wrap count, and adding additional fields using a vertical container and labels.
• Invoke PowerAutomate on the Change Specific Field/Column Value of DevOpsJun 26, 2023. Reducing unnecessary Power Automate invocations, this article presents a solution to trigger automation only when specific column values change in Azure DevOps, optimizing consumption and flow history while maintaining efficiency.
• Sync SharePoint Online Column with Azure DevOps Fields using Power AutomateJun 23, 2023. This article introduces extracting Azure DevOps work item drop-down values using Power Automate. It covers creating a work item, extracting values, and syncing them with SharePoint Online List choice columns.
• Power Apps - Fetch Image Property From Multi People Picker Column Based On Dropdown SelectionMar 27, 2023. In this article, you will learn how to fetch image property from multi people picker column based on dropdown selection.
• Power Apps - Fetch Image Property From Multi People Picker ColumnMar 27, 2023. In this article, you will learn about how to fetch image property from multi people picker column in Power Apps.
• What Is The Difference Between Relational And Non-Relational DatabaseMar 20, 2023. Relational databases and non-relational databases, also known as NoSQL databases, represent two fundamentally different approaches to storing and organizing data. Understanding the key differences between these two types of databases is essential for making informed decisions when choosing the most suitable database solution for specific use cases.
• 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
• How To Customize Table In Oqtane ModuleFeb 08, 2023. In this article, I'm going to explain, how we can add use a new column in the table of the Oqtane custom module
• How To Delete A Column With Default Constraints In SQL ServerJan 25, 2023. This article let us know, how to delete a column that has a default constraint in SQL server.
• Create Column Charts, Pie Charts or Line Charts in PowerPoint in JavaJan 18, 2023. This article will introduce how to create a clustered column chart, a pie chart and a line chart in a PowerPoint document in Java by using Spire.Presentation for Java.
• Find Blank Column Using LINQ In UiPath Jan 03, 2023. In this article, you will learn how to find blank column Using LINQ in UiPath.
• Use Of Filter Data Table Activity In UiPath Dec 27, 2022. Idea about how to use the Filter Data Table Activity in UiPath Studio.
• Delete Files Based On Excel Column Name In Azure Data FactoryDec 19, 2022. In this article we are going to discuss about how to pick and delete only specific files from the ADLS directory based on filenames present inside the excel file. We are going to see this with a real-time use case.
• Cascading Dropdown In Power Apps With Dataverse Look Up ColumnsNov 30, 2022. During this article, we will learn how to make cascading dropdown with dataverse look up columns in Power Apps
• HighCharts - Column ChartsNov 15, 2022. Column Charts using High Charts.
• How To Rename Columns In Dataframe Using PythonNov 04, 2022. In this article, you will learn how to read Microsoft SQL table, add the results to DataFrame, rename the columns in DataFrame and export DataFrame to excel.
• How To Add New Columns To A DataFrame Using PythonNov 03, 2022. In this article, you will learn how to read Microsoft SQL table, add the results to DataFrame, add new columns to a DataFrame and export DataFrame to excel.
• Formatting A Text Based On Number Of Columns In PythonSep 26, 2022. How to display very long text when user viewable area is limited? Check out this article to know more...
• What Is The Difference Between DBMS And RDBMS?Sep 13, 2022. DBMS (Database Management System) and RDBMS (Relational Database Management System) are both software systems used to manage and organize databases. The main difference between the two lies in the way they handle data and the relationships between data. A DBMS is a software application that allows users to interact with databases, providing an interface to create, retrieve, update, and delete data. RDBMS is a specific type of DBMS that manages databases based on the relational data model.
• How To Give Name To A Size Column In PythonAug 10, 2022. This article explains how one can label the size column that is generated programmatically.