Columns

Resources

How to sync SharePoint choice values to Dataverse choice columns using Power AutomateAug 07, 2026. Master syncing SharePoint choice values to Dataverse using Power Automate. Learn to map text labels to integer values for seamless integration.
How to Use DropColumns in Power Apps: Remove Unwanted Columns from DataJul 24, 2026. Master Power Apps' DropColumns() to efficiently remove unwanted columns from tables, collections, and data sources, simplifying your data.
How to Use Indexed Columns in SharePoint to Improve List PerformanceJul 17, 2026. Boost SharePoint list performance with indexed columns. Learn how to speed up filtering, sorting, and avoid list view threshold issues.
How to bulk delete custom columns of SharePoint List using Power AutomateJul 09, 2026. Learn to efficiently bulk delete custom columns from SharePoint lists using Power Automate. Streamline your list management with this step-by-step guide.
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.
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.
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.
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!
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 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 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.
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,
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)".
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.
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 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...
Some System Columns Cannot Be DeletedMar 16, 2022. In this article, we will go through the use case and how to remove the system column from the SharePoint site conent types.
Get All Columns in a Table Schema Information In One ClickJul 22, 2021. Get Table All Columns Schema Information in One Click In this article, I will show how we can get table columns information like ColumnName, DataType, DataType Length, is mandatory, and column brief description
Drag And Drop Table Columns In Angular 10 ApplicationFeb 01, 2021. In this article, you will learn how to drag and drop table columns in angular 10 application.
How Date-Time Columns Work In SharePointJan 11, 2021. In this article, we will learn how SharePoint displays the value of date-time columns in lists or libraries.
Send Email With SharePoint Lookup Columns Data Using Power AutomateAug 06, 2020. In this article, you will learn how to send email with SharePoint Lookup Columns Data using Power Automate.
EF Core - SELECT DISTINCT on a Few Columns OnlyApr 26, 2020. In this article, you will learn about implementing EF Core - SELECT DISTINCT on selected columns only.
How To Sort A Table Using Multiple Columns In Power BIMar 30, 2020. In this blog, we will learn how we can sort a table using multiple columns for the table visualization in Power BI.
MS Flow - Issue With Getting Value Of All Columns Using Get Items ActionMar 16, 2020. In this article you will learn about this error of MS Flow - Issue With Getting Value Of All Columns Using Get Items Action.
SharePoint Online Columns Formatting Using JSONAug 09, 2019. In this article, you will learn about SharePoint online columns formatting using JSON.
ASP.NET MVC 5 - Matchheight.js📦 - Create Equal Height Of Columns In Row Using jQueryJan 16, 2019. Here, we are going to learn how to match the height of the tallest of each row by the column height and why should learn this.
Bind Auto Columns HTML Table Using jQuery/JSONSep 28, 2018. This article explains how to bind an HTML table to jQuery. without passing the column name in JSON data.
Updating Dynamic Columns On The Go In SQLSep 11, 2018. I hope you all are doing fine. This particular article is about updating the dynamic columns on the go.
How To Enforce Unique Value For SharePoint Columns Using C#Aug 12, 2018. Step by step instructions to enforce unique value for SharePoint columns using c#. It. It is used for enforcing uniqueness on values for SharePoint list or library columns
Learn SharePoint In Series - Part Twenty Seven - Managed Metadata Columns TypeJul 25, 2018. In this article, I have explained Managed Metadata columns in brief
Matrix In R - Adding Rows And Columns To A Matrix In RJul 20, 2018. In this article, we shall learn how to add rows and column to a matrix in R using R studio?
Learn SharePoint In Series - Part Twenty Five - Calculated Columns In SharePointJul 18, 2018. In this article, calculated columns is explained at very basic level.
Learn SharePoint In Series - Part Twenty - Currency And Yes No Columns Type In SharePointJul 03, 2018. This article talks about Currency and Yes/No column types in SharePoint.
Learn SharePoint In Series - Part Nineteen - Choice And Number Columns Type In SharePointJul 01, 2018. This article talks about how to use Number and Choice column types in SharePoint lists
Learn SharePoint In Series - Part Eighteen - Multiple Lines Of Text Columns Type in SharePointJun 29, 2018. This article covers every aspect of multiple lines of text, including creation, property configurations, editing etc.
Learn SharePoint In Series - Part Seventeen - List Columns In SharePointJun 27, 2018. Delve into list columns in SharePoint, covering data types, customization, and metadata management. Learn how to optimize content organization and ensure efficient data validation for enhanced collaboration and productivity.
Move Site Columns From A SharePoint Site To Another Using PNP PowerShellMay 30, 2018. This is about moving site columns or import/export site columns from one site to another.
Add Multiple Columns Using DAX In Power BIMar 17, 2018. In this article we will talk about how can we add multiple columns in Power BI using DAX expression.
Hide And Group Columns In SSRS Using A ParameterMar 16, 2018. Learn how to enhance reports without creating multiple versions. Utilize SSRS features like parameters, expressions, and visibility settings to dynamically adjust data presentation, catering to user requests while maintaining report integrity.
Ordering The Columns In SharePoint Online List FormsJan 04, 2018. In this article, I would like to share the steps to order the SharePoint list columns for list forms.
Calculated Columns In Power BINov 15, 2017. In this article, we will talk about calculated columns in Power BI. To prepare any report in real life, we must have to prepare calculated columns and measures in Power BI.
Convert Rows To Columns Using Dynamic Pivot In SQL ServerSep 17, 2017. In this article, we will show how to convert rows to columns using Dynamic Pivot in SQL Server.
Site Columns In SharePoint 2013Jul 15, 2017. Site column is on of the good features in SharePoint . You can reuse the column within your site and subsites. you can also reuse within content type in SharePoint.
Identifying Relationship Between Columns In SQLMay 30, 2017. Identifying relationship between columns in SQL. The query is given below to find the relation between any two columns in the given database. How to search the column in the database by its name.
Provision SharePoint List With Custom Site Columns And Content Type Using SharePoint FrameworkMay 16, 2017. Provision SharePoint List With Custom Site Columns And Content Type Using SharePoint Framework.
Provisioning SharePoint Site Columns Using SPFx SolutionApr 03, 2017. In this article, let us look at provisioning SharePoint site columns (fields) using SharePoint Framework components.
All We Should Know About Site Columns In SharePoint OnlineFeb 17, 2017. In this article, you will learn about about Site Columns in SharePoint Online.
Sharepoint Columns ExploredJan 02, 2017. In this article, you will learn everything about SharePoint columns. I am going to talk about the single line of text column type.
Site Columns Through SharePoint Hosted AppsSep 24, 2016. In this article, you will learn about Site Columns through SharePoint Hosted Apps.
Steps To Create Site Columns In SharePoint 2013 Using Visual StudioSep 23, 2016. In this article, you will learn how to create Site Columns in SharePoint 2013, using Visual Studio.
Reorder The Columns In SharePoint List Content Type Programmatically Using CSOM C# And JSOMAug 17, 2016. In this article, you will learn how to reorder the columns in SharePoint List Content Type programmatically, using CSOM C# and JSOM.
Working With List Columns On SharePoint Using PnP PowerShellJul 05, 2016. In this article, you will learn how we can add, retrieve, and delete columns/fields on to SharePoint lists, using PnP PowerShell.
Working With Site Columns On SharePoint Using PnP PowerShellJul 03, 2016. In this article, you will learn how we can create, retrieve and delete site columns on SharePoint sites, using PnP PowerShell.
Remove Multiple Columns From Default View of Document Library From Site CollectionApr 29, 2016. In this article you will learn about a PowerShell script to remove Multiple Columns from Default View of Document Library from a selected set of Site Collections in a single go.
Computed Columns In SQL ServerApr 13, 2016. In this article, you will learn about Computed Columns in SQL Server.
Site Columns In SharePointApr 07, 2016. In this article you will learn about Site Columns in SharePoint.
How To Create Columns In A List Using REST API In SharePoint Online And Office 365Apr 03, 2016. In this article you will learn how to create columns in a list using REST API in SharePoint Online and Office 365.
How To Get All Site Columns Using REST API In SharePoint Online And Office 365Apr 02, 2016. In this article you will learn how to get all Site Columns using REST API in SharePoint Online and Office 365.
a href Columns In Grid in JQueryNov 13, 2015. In this post we will how we can customize a column in jQWidget jQX Grid.
Hide The Rows And Columns In Kendo Grid Using jQueryOct 25, 2015. In this article you will learn how to hide the rows and columns in kendo grid using jQuery.
Add Site Columns To Site Content Type On Host Web Using JSOMOct 07, 2015. In this article, we will see how to add Site Columns to Site Content Type on Host Web using JSOM.
Create Site Columns On Host Web From App Web Using JavaScript In SharePoint 2013Oct 03, 2015. This article explains how to create site columns on Host Web from App web in SharePoint 2013 using JavaScript (JSOM).
List With Content Type And Additional Columns In SharePointSep 14, 2015. In this article we can explore a real world problem in SharePoint.
Create a Spiral Matrix by Taking Number of Rows and Columns as InputAug 10, 2015. In this article you will learn how to create a Spiral Matrix by taking the number of rows and columns as input from the user using C#.
Show or Hide Columns in ExcelJul 13, 2015. In this article we will learn how to show or hide columns in excel.
Show or Hide Columns in JQWidgets JQX GridJun 22, 2015. Today we will learn how to show/hide columns in JQWidgets JQX Grid.
Indexed Columns to Improve List PerformanceMay 25, 2015. In this article we can explore Indexed Columns that is a less-used feature in SharePoint.
Save and Load a DataGrid's Columns Graphical Properties in WPFMay 12, 2015. We'll see in this article how a user can customize a DataGrid, ordering columns or modifying their width, saving those changes for later use (in other words, when the program will show again a specific grid).
Alter Columns DataType Without Dropping Table in SQLFeb 28, 2015. In this article, I will explain how to alter a database table column without dropping the table with simple example.
Mastering WPF DataGrid in a Day: Hour 6 DataGrid Columns In-DepthNov 10, 2014. In my last article, I demonstrated how to use some of the basic columns functionality. In this Hour 6 part of Mastering WPF DataGrid in a Day series, I will cover some of the advanced functionality of DataGrid columns.
Computed Columns in SQL ServerJul 10, 2014. Computed columns are derived columns based on the other existing columns. Computed columns are data types can create based on the situation.
How to Get The List Columns in SharePoint Online Using REST APIApr 25, 2014. In this article you will see how to get all the columns for a particular list using the REST API in SharePoint 2013 Online.
Get All Site Columns in SharePoint 2013 Online Using REST APIApr 20, 2014. In this article you will see how to get all the site columns using the REST API in SharePoint 2013 Online.
Get the Count or List of Columns of a Table in SQL ServerMar 20, 2014. In this article, I will show how to count the number of columns in a table that exists in your database.
Hide Columns in SharePoint 2010 New, Edit and Disp FormsJan 10, 2014. This article explains how to hide columns in SharePoint new, edit and disp forms.
Finding Duplicates Among Multiple Columns in SQLMay 15, 2013. Here I show how to find duplicates and their frequency among multiple columns using the GROUP BY clause.
Load Multiple Columns in Auto Complete Dropdown in LightSwitch 2012May 03, 2013. In this article you will learn how to show multiple columns in a single dropdown list in LightSwitch 2012.
Display Multiple Columns Into ComboBox From Database Table in C#Mar 13, 2013. In this article I explain how to bind multiple column values into a combobox in C#.
Displaying Multiple Columns Under a Single Column in GridView in ASP.NETJan 11, 2013. In this article, we will see how to display multiple columns under a single column in GridView in ASP.NET.
Sum of Columns of Two Tables Into One Column in SQL Server 2012Dec 26, 2012. This article will give you an idea of how to add columns of two tables into one column and also defines how to handle a null value in SQL Server.
Customizing Datagrid Columns Window Application in VB.NETNov 10, 2012. This article explains about how to customize the datagrid in window application using vb.net.
Merge Cells Columns in Row of GridView in VB.NETNov 09, 2012. In this article we will be able to merge GridView cells ,columns in GridView rows.
Displaying Rows as Columns With Total Displayed on Each Row and ColumnAug 19, 2012. In this article you will see how to display rows as columns with totals displayed on each row and column.
Merge Two Datatable Columns and Bind to ComboBox ControlJul 28, 2012. In this article, let us see how to bind a combobox with various columns from various datatables.
How to Localize Site Columns in SharePoint 2010 Using Visual Studio 2010Jun 20, 2012. In this article you will be seeing how to localize site columns in SharePoint 2010 using Visual Studio 2010.
Display Columns as Rows in GridView in ASP.NETMay 12, 2012. In this article I will describe how to display GridView columns as rows.
How to Store Date and Time in Separate Columns in SQL Server 2005Mar 29, 2012. In this article I will explain how to store Date and Time in SQL Server 2005 using a User Defined Type.
Show The Data of Respective Columns of a Database in TextboxJan 13, 2012. This article explains how to show the data of respective columns of a database to the corresponding textboxes present in a web page.
Using Temp Table in SQL Server And Adding Columns DynamicallyJul 16, 2011. In this article we'll see how to use the Temporary tables, what are the necessary step to be taken while using them and moreover sometimes it's required to add column in Temporary tables dynamically.
Convert Rows to Columns in SQL ServerMay 29, 2011. This article will help to convert values in rows to column/fields name or headers.
Working with Rows and Columns in XAML in SilverlightApr 27, 2011. In this article, you will learn how to work with rows and columns in Silverlight.
Editable GridView - All Columns in GridView are Editable Apr 07, 2011. I am submitting all process to step by step first fill then create bool function and go to assemble row editing & updating Event.
Searchable columns in SharePoint 2010Mar 02, 2011. In this article we will be seeing about Searchable columns in SharePoint 2010.

Tags