Error when using SharePoint Site Script to create a list with subaction "setTitle"

[michaelmaillot]

Target SharePoint environment

SharePoint Online

What SharePoint development model, framework, SDK or API is this about?

SharePoint REST API

Developer environment

None

What browser(s) / client(s) have you tested

• 💥 Internet Explorer
• 💥 Microsoft Edge
• 💥 Google Chrome
• 💥 FireFox
• 💥 Safari
• mobile (iOS/iPadOS)
• mobile (Android)
• not applicable
• other (enter in the "Additional environment details" area below)

Additional environment details

No response

Describe the bug / error

Hello,

In our site templates, we use site scripts and we met an issue with a specific action.

We wanted to use the "createSPList" action to create a list (template type 100) and rename it in order to distinct explicit title from technical one (URL).

Below the JSON content of the site script:

{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/site-design-script-actions.schema.json",
  "actions": [
    {
      "verb": "createSPList",
      "listName": "testlist",
      "templateType": 100,
      "subactions": [
        {
          "verb": "setTitle",
          "title": "Feedback"
        }
      ]
    }
  ]
}

When I want to apply it to a site, I run the following POST query:

https://[TENANT_URL].sharepoint.com/sites/[SITE_URL]/_api/Microsoft.Sharepoint.Utilities.WebTemplateExtensions.SiteScriptUtility.ExecuteTemplateScript()

However, here's the returned error I have:

{
    "odata.metadata": "https://[TENANT_URL].sharepoint.com/sites/[SITE_URL]/_api/$metadata#Collection(Microsoft.SharePoint.Utilities.WebTemplateExtensions.SiteScriptActionResult)",
    "value": [
        {
            "ErrorCode": -2147467259,
            "Outcome": "1",
            "OutcomeText": null,
            "Target": null,
            "TargetId": null,
            "Title": "Créer ou mettre à jour la liste « testlist »",
            "Verb": "createSPList"
        }
    ]
}

But if I try to run the same query when creating a library instead of a list (template type 101), here's the returned content:

{
    "odata.metadata": "https://[TENANT_URL].sharepoint.com/sites/[SITE_URL]/_api/$metadata#Collection(Microsoft.SharePoint.Utilities.WebTemplateExtensions.SiteScriptActionResult)",
    "value": [
        {
            "ErrorCode": 0,
            "Outcome": "0",
            "OutcomeText": null,
            "Target": "https://[TENANT_URL].sharepoint.com/sites/[SITE_URL]/testlist",
            "TargetId": "5b093d3b-1365-459f-82c2-741482e97f01",
            "Title": "Créer ou mettre à jour la bibliothèque « testlist »",
            "Verb": "createSPList"
        },
        {
            "ErrorCode": 0,
            "Outcome": "0",
            "OutcomeText": null,
            "Target": null,
            "TargetId": null,
            "Title": "Définir le titre de la liste sur « Feedback»",
            "Verb": "createSPList.setTitle"
        }
    ]
}

I didn't find anything in the documentation about limitations of the subaction "setTitle", and the returned error is not explicit.

Steps to reproduce

1. Open a console or an app with which you can perform HTTP POST calls
2. Type the URL https://[TENANT_URL].sharepoint.com/sites/[SITE_URL]/_api/Microsoft.Sharepoint.Utilities.WebTemplateExtensions.SiteScriptUtility.ExecuteTemplateScript() and replace [TENANT_URL] & [SITE_URL] with real values
3. Setup header parameters (bearer token or cookie value) and add in the body the "createSPList" action with "setTitle" subaction

Expected behavior

As there's nothing declared in the documentation regarding limitation in "setTitle" subaction between Generic List (template type 100) & Document Library template type 101), I expect this to work. And if there's a specific error, I expect a clear outcome message.

[Ashlesha-MSFT]

Hello @michaelmaillot ,
Thank you for bringing this issue to our attention. We will look into it and get back to you shortly.
If you don’t receive a reply within two working days, please use this escalation form to escalate.

[Ashlesha-MSFT]

@michaelmaillot,
the behavior you mentioned isn’t documented, so I’ll need to check with engineering and investigate further. To help me reproduce and analyze the issue more effectively, could you please share:

• The HTTP status code returned when executing the site script.
• The permissions granted to the Azure AD token used for the request.

So far, I haven’t been able to reproduce the exact issue on my side, so having these details will help narrow down the root cause.

[michaelmaillot]

Hello @Ashlesha-MSFT,

Thanks for escalating this.

• The HTTP status code is always 200
• Permissions granted: Graph AllSites.FullControl & SharePoint Sites.FullControl.All

[michaelmaillot]

I've pushed forward the tests and looks like there's an issue with the "createSPList" action when it's about a generic list (template type 100):

• Creating a list with any template type than "100" is working, wether we add "setTitle" subaction or not
• Creating a generic list without any subaction is creating a list but without any built-in view:

https://[TENANT_URL].sharepoint.com/sites/[SITE_URL]/_api/Microsoft.Sharepoint.Utilities.WebTemplateExtensions.SiteScriptUtility.ExecuteTemplateScript()

{
    "script": "{\"$schema\":\"https://developer.microsoft.com/json-schemas/sp/site-design-script-actions.schema.json\",\"actions\":[{\"verb\":\"createSPList\",\"listName\":\"ListTestMS5\",\"templateType\":100}]}"
}

Response:

{
    "odata.metadata": "https://[TENANT_URL].sharepoint.com/sites/[SITE_URL]/_api/$metadata#Collection(Microsoft.SharePoint.Utilities.WebTemplateExtensions.SiteScriptActionResult)",
    "value": [
        {
            "ErrorCode": 0,
            "Outcome": "0",
            "OutcomeText": null,
            "Target": "https://[TENANT_URL].sharepoint.com/sites/[SITE_URL]/Lists/ListTestMS5",
            "TargetId": "9df1b79a-f9cb-49f1-a404-f9237e29dccf",
            "Title": "Créer ou mettre à jour la liste « ListTestMS5 »",
            "Verb": "createSPList"
        }
    ]
}

404 error when going to above target URL https://[TENANT_URL].sharepoint.com/sites/[SITE_URL]/Lists/ListTestMS5:

And when I go to list parameters: