SharePoint List Agent with Microsoft 365 Copilot – Create Lists Instantly with Natural Language

GiulianoDeLuca​  While this new agent looks promising on the surface, in practice it falls short in several key areas. Based on our testing, and what others are reporting, there are some significant limitations:

• It can only create new lists and cannot work with existing ones
• It can populate some data during list creation, but only at a very small scale. In our case, it struggled with a dataset of around 60 rows and 8 columns. Even when it does process the data, the results are inconsistent, with missing values and partially populated columns
• There is no support for ingesting multiple files and generating a structured dataset. Currently, using Edit with Copilot in Excel is a more reliable option for this type of scenario
• It frequently creates lists that do not match the requested structure, requiring repeated deletion and retries
• It appears to cache source data. Even after updating the input Excel file and waiting an extended period (couple of hours), it continued referencing the original version

Given these issues, it is surprising to see this released as General Availability. The current experience feels closer to an early preview or experimental feature as part of Frontier.

Hopefully, Microsoft continues to invest in refining this capability, particularly around reliability, data handling, and alignment with user intent.