Provision multiple typed fields on a list from a schema specification.

Maps a name -> FieldType schema (like migration tools do) and creates each field via the generic FieldCreationInformation.

Reference

• https://learn.microsoft.com/en-us/sharepoint/dev/apis/rest-api

View source

import argparse

from office365.sharepoint.client_context import ClientContext
from office365.sharepoint.fields.creation_information import FieldCreationInformation
from office365.sharepoint.fields.type import FieldType
from tests.settings import cert_path, cert_thumbprint, client_id, site_url, tenant

LIST_TITLE = "Tasks"
FIELDS = {
    "CustomerName": FieldType.Text,
    "Quantity": FieldType.Number,
    "DueDate": FieldType.DateTime,
    "Status": FieldType.Choice,
    "Notes": FieldType.Note,
}


def main():
    parser = argparse.ArgumentParser(description="Provision typed fields from a schema spec")
    parser.add_argument("--list-title", default=LIST_TITLE, help="Target list")
    parser.add_argument("--keep", action="store_true", help="Keep created fields (default: delete after demo)")
    args = parser.parse_args()

    ctx = ClientContext(site_url).with_client_certificate(
        tenant, client_id=client_id, thumbprint=cert_thumbprint, cert_path=cert_path
    )
    lst = ctx.web.lists.ensure_list(args.list_title)

    for name, field_type in FIELDS.items():
        info = FieldCreationInformation(Title=name, FieldTypeKind=field_type)
        if field_type == FieldType.Choice:
            info.Choices = ["Not Started", "In Progress", "Completed", "Deferred"]
        field = lst.fields.ensure(info).execute_query()
        print(f"  created {name:16s} ({field_type.name}) -> {field.internal_name}")


if __name__ == "__main__":
    main()

---

← Back to Fields (Site Columns)