Is the copilot works for below queries or do I need to set the code manually:

Question

1. Creating the SharePoint lists using copilot
2. Update the column type mandatory for existing SharePoint list
3. Update the choice column data for SharePoint list.

Answer 1

Hello Kapil Jindal,
Copilot works only for the first one. For the other two, you must update them manually or via PowerShell/code.
Copilot for SharePoint supports creating new SharePoint lists using natural language, Excel files, or existing lists as references. It can automatically generate columns and infer column types, making it useful for initial list design.
However, Copilot has important limitations: it cannot reliably enforce mandatory (required) fields, apply validation rules, modify advanced column settings, update existing column properties, or change choice column values after creation. Tasks such as making a column mandatory or updating choice values must be done manually through the SharePoint UI or via PowerShell (e.g., PnP PowerShell).
In practice, Copilot is best used as a list designer for initial setup, while administrative and governance tasks require manual configuration or scripting.

Answer 2

The Copilot feature in SharePoint can assist with some operations, but there are limitations to consider:

1. Creating SharePoint Lists: Copilot can help create new SharePoint lists using templates, but the specific capabilities may depend on the environment and whether Copilot is enabled.
2. Updating Column Types: Updating the column type for existing SharePoint lists may require manual coding, as the documentation indicates that certain operations, like updating existing column definitions, might not be fully automated.
3. Updating Choice Column Data: Similar to updating column types, modifying the data for choice columns may also necessitate manual intervention, as the Copilot's capabilities in this area are not explicitly defined in the context provided.

In summary, while Copilot can assist with creating lists, updating existing structures like column types and choice data may require manual coding or configuration adjustments.