Creating List Columns with pnp/sp not being created

Question

So I can create a list just with ensure:

sp.web.lists.ensure(list)
    .then((ler: ListEnsureResult) => {

        if (ler.created) {
            console.log(list, " was created; creating column");

            ler.list.fields.addText("myTestColumn");
        }
        return ler.created;
    });

But is not creating a column.

I have also tried code samples from here and here, neither of which have worked.

your code works fine. Go to your list settings, the column will be present there. — Gautam Sheth, Sep 10 '18 at 07:33
So it adds a column to the site, not to the list? How do I add a column to a list then? — Holden1515, Sep 10 '18 at 12:59
no, it adds column to the list only. Go to the created list and then click on the list settings from the gear icon in top right section, you will find the column there :) — Gautam Sheth, Sep 10 '18 at 13:00
Ha! You're right! Thank you! Any idea how to get the columns to display? — Holden1515, Sep 10 '18 at 13:42

score 1 · Accepted Answer · answered Sep 10 '18 at 16:16

As mentioned in comments, your code is working fine.

Its just that the column is not visible in the List View. It is already created in the List and is visible when we check the list settings page or try to create a new list item.

So, now you need to add the column to the default list view. For that, you just need to make additional REST API call to make it visible in the default list view as below:

sp.web.lists.ensure(list)
    .then((ler: ListEnsureResult) => {

        if (ler.created) {
            console.log(list, " was created; creating column");

            ler.list.fields.addText("myTestColumn").then(function(){

                const view = ler.list.defaultView;

                view.fields.add("myTestColumn");

          });           

        }
        return ler.created;
    });

Creating List Columns with pnp/sp not being created

1 Answers1