How To Disable Title As Mandatory Field From SharePoint List Using Power Automate?

Have you noticed that the Title column is mandatory by default when you create a SharePoint list using Power Automate? If you try to set it as non-required by directly adding “Required”: false in the HTTP request while creating the list, you’ll likely run into an error because there’s no direct property for that!

But don’t worry! In this tutorial, I’ll show you how to create a SharePoint list and disable the Title column as a mandatory field using Power Automate.

Disable Title As Mandatory Field From SharePoint List Using Power Automate

Imagine you’re automating the creation of SharePoint lists for different departments in your organization. Each department requires a customized list with specific columns, but they don’t need the default “Title” column to be mandatory.

SharePoint makes the Title column a required field by default. As we know, there is no direct property. Instead of directly creating it, we need to create the list first and then update the column settings to make it optional.

To do this, follow the below steps:

1. Open Power Automate, click on Create, and select Instant cloud flow. Choose the Manually trigger a flow trigger. Then, click + Add an input and add three text inputs:

• Site Address – Enter the SharePoint site URL
• List Display Name – Enter the Display Name of the SharePoint list
• List Internal Name – Enter the Internal Name of the SharePoint list

2. Add the Send an HTTP request to SharePoint action to create a SharePoint list. Provide the action with the following parameters:

• Site Address: Select the SharePoint Site Address from the dynamic content.
• Method: Select POST as the method
• URI: Provide the below URI:

_api/web/Lists/

• Header: Use the below headers to make REST API calls to SharePoint:

{
  "content-type": "application/json;odata=verbose",
  "accept": "application/json;odata=verbose"
}

• Body:

{ '__metadata': { 'type': 'SP.List' },
'AllowContentTypes': true,
'BaseTemplate': 100,
'Description': 'My list description',
'Title': '@{triggerBody()?['text_2']}' }

The list is created with an internal name fetched from the trigger body (internal_name). This is necessary because SharePoint does not allow setting an internal name separately during list creation.

3. Add another Send an HTTP request to SharePoint action to rename the List to set the Display Name. Provide the action with the following parameters:

• Site Address: Select the SharePoint Site Address from the dynamic content.
• Method: Select POST as the method
• URI: Provide the below URI:

_api/web/lists/getByTitle('@{triggerBody()?['text_2']}')

• Header: Use the below headers to make REST API calls to SharePoint:

{
  "Accept": "application/json;odata=verbose",
  "Content-Type": "application/json;odata=verbose",
  "IF-MATCH": "*",
  "X-HTTP-Method": "MERGE"
}

• Body:

{
    "__metadata": {
        "type": "SP.List"
    },
    "Title": "@{triggerBody()?['text_1']}"
}

This step renames the list from the internal name (internal_name) to the display name (display_name).

4. Add another Send an HTTP request to SharePoint action to get the SharePoint list’s GUID. Provide the action with the following parameters:

• Site Address: Select the SharePoint Site Address from the dynamic content.
• Method: Select GET as the method
• URI: Provide the below URI:

_api/web/lists/getbytitle('@{triggerBody()?['text_1']}')

The response will return all the list details, but we want only the SharePoint list’s GUID. This GUID can be used in further API requests.

5. Add another Send an HTTP request to SharePoint action to update the title column to make it optional. Provide the action with the following parameters:

• Site Address: Select the SharePoint Site Address from the dynamic content.
• Method: Select POST as the method
• URI: Provide the below URI:

_api/web/lists(guid'@{body('Send_an_HTTP_request_to_SharePoint_1')?['d']?['Id']}')/Fields/getbytitle('Title')

• Header: Use the below headers to make REST API calls to SharePoint:

{
  "Accept": "application/json;odata=verbose",
  "Content-Type": "application/json;odata=verbose",
  "X-HTTP-Method": "MERGE",
  "IF-MATCH": "*"
}

• Body:

{
  "__metadata": { "type": "SP.FieldText" },
  "Required": "@{false}"
}

Since the Title column is mandatory by default, this API request makes it optional.

Run the Flow to Disable Title As Mandatory Field From SharePoint List

Now, save the flow -> Click Test (top-right corner) -> Select Manually and click Test again. -> Enter  SharePoint Site Address, Internal name, and Display name in the input fields.

Click Run flow and wait for execution. After the flow runs successfully, click the title column to that list setting. You can verify that this column requires information to be selected as ‘no. ‘

In this tutorial, we learned how to create a SharePoint list using Power Automate and then update its settings to make the Title column optional.

Related Power Automate tutorials:

• Disable Include Time Option in SharePoint List Date Time Column Using Power Automate
• Rename SharePoint List Using Power Automate
• Check if SharePoint List Already Exists in Power Automate
• Get and Delete a SharePoint list view using Power Automate
• Send Email Reminders From a SharePoint List Using Power Automate