Yes/No Column PnP PowerShell

PnP PowerShell: Add Yes/No Column in SharePoint Online

SharePoint Online provides a powerful platform for collaboration and data management. One way to customize your lists and libraries is by creating custom columns. In this tutorial, we’ll focus on creating a Yes/No Site Column using PnP PowerShell.


Before you begin, make sure you have the following:

  1. SharePoint Online Site: Ensure you have the necessary permissions to create columns.
  2. PnP PowerShell: Install the PnP PowerShell module if you haven’t already. Refer to another blog post on for guidance on installing the PnP PowerShell Module.

Steps to Create a Yes/No Column

Follow these steps to create a Yes/No column in SharePoint Online using PnP PowerShell:

Step 1: Connect to SharePoint Online

Open PowerShell and connect to your SharePoint Online site using the following command:

Connect-PnPOnline -Url "" -Interactive

Step 2: Create a Yes/No Site Column

To create a Yes/No column, use the Add-PnPField cmdlet. Here’s an example of creating a Yes/No column named “IsApproved” with specific settings:

Add-PnPField -DisplayName "IsApproved" -InternalName "IsApproved" -Group "Custom Columns" -Required
  • DisplayName represents the name displayed in the SharePoint UI.
  • InternalName: A unique identifier for the column.
  • Group: Specify the column group to organize it logically.
  • Required: add the parameter if the column is mandatory.

Step 3: Verify Column Creation

After running the command, verify that the column has been created successfully. You can check the SharePoint site or use the following command:

# This command retrieves information about the newly created column.
Get-PnPField -Identity "IsApproved" | Select DisplayName, InternalName, Type


Creating a Yes/No Site Column using PnP PowerShell in SharePoint Online is a quick and efficient way to customize your lists. With this column in place, you can enhance the data capture and improve the overall usability of your SharePoint site.

Experiment with different parameters and options to tailor the column to your specific requirements. As you continue to explore PnP PowerShell, you’ll discover its potential for automating various SharePoint tasks and making your collaboration experience even more powerful.

Related Posts

Leave a Reply

Your email address will not be published. Required fields are marked *