← Al Davies, 250 High Street

Create a SharePoint list with Copilot: what Microsoft documents and what it needs

Short answer: Microsoft's page "Get started with Copilot in SharePoint" says the Copilot capabilities include "Create and edit pages, libraries, or lists," and that users must have "an active Microsoft 365 Copilot license." That page does not show prompts or the columns Copilot builds, so this guide does not list them. Microsoft still labels the feature public preview, with general availability rolling out from September 30, 2026.

What the Microsoft page says

Source: Microsoft Learn, Get started with Copilot in SharePoint.

Where lists fit in

Microsoft's page has a two-column table. The column "Included with the Microsoft 365 Copilot license" lists, among other items:

The column "Requires Copilot Credits" lists, among other items:

Microsoft says Copilot Credit use "varies based on the type and complexity of the task and nature and volume of the content involved." It also says that users with credits "are asked to confirm before moving into advanced work that spends Copilot credits."

Our advice, not a Microsoft rule: one new list for a small team reads like the first column, and a job that spans a whole site reads like the second. Where the line sits for your list is a question for your admin.

What the page does not say

Microsoft's page does not give:

(delete; sentence starts "If you have Copilot,")If you have Copilot, try one small prompt and read the result. Our advice, not a Microsoft rule: check every column type before anyone enters data. A date typed as text, or a Choice column with the wrong values, is harder to fix after the list has rows.

What the page says about availability

Which license do you hold

Microsoft's page "License Options for Microsoft Copilot" says Microsoft Copilot "is available with Microsoft 365 E7 or as an add-on for eligible commercial, US Government, and education subscription plans." It lists eligible prerequisite plans, and notes that Microsoft Copilot Business is for organizations with up to 300 users. I have left out prices. Ask your admin which license you have.

No Copilot: build the list yourself

You do not need Copilot to get a working list. The steps are the same for any tracker.

  1. Write the columns on paper first: the name, one date, one person, one status.
  2. Make the status a Choice column with numbered values such as 1 Open, 2 In progress, 3 Done.
  3. Create the list in Microsoft 365 and add the columns.
  4. Add three sample rows and check the form and the view.

If your data lives in a spreadsheet, see "Import Excel into an existing SharePoint list". For a choice between a spreadsheet and a list, see "SharePoint list vs Excel". For worked column designs, see "Set up an asset register in SharePoint" and "Set up a vendor list with renewal dates".

After the list exists

Copilot or not, the same checks apply.

When to get help

You can build all of this yourself in Microsoft 365. If you would rather have it built and tested for your team, I do that. A tracker like this is a fixed price: $5,000 for one, built in 2 weeks. See "What a SharePoint tracker costs to build". Bring one example of the problem to a free call.

Tell me what's still manual

I am Al Davies. I run 250 High Street LLC and build SharePoint trackers and Power Automate flows for operations teams. I work remotely. The first call is free, and I will not try to sell you anything.

See trackers I built: Tools I built

FAQ

Can Copilot create a SharePoint list?

Microsoft's page lists "Create and edit pages, libraries, or lists" as an included capability of Copilot in SharePoint.

Do I need a Microsoft 365 Copilot license to use Copilot in SharePoint?

Yes. Microsoft says users must have an active Microsoft 365 Copilot license.

Does creating a list cost extra Copilot Credits?

Microsoft puts creating and editing lists in the included column and lists doing it "at scale" under Copilot Credits.

Is Copilot in SharePoint available to everyone yet?

Not always. Microsoft's page still labels it public preview, says general availability began rolling out on September 30, 2026, and says capabilities may appear in your tenant as rollout progresses. It also needs a Microsoft 365 Copilot license.

Can I hide Copilot on one site?

Microsoft says site owners can open Settings, then Site AI, and hide the Copilot button for visitors. An enabled Restricted Content Discovery setting also hides it.

Sources