How to Connect Microsoft Copilot to Microsoft Lists for Item Lookup

You want to use Microsoft Copilot to look up items stored in a Microsoft List without manually opening the list or running a Power Automate flow. Copilot can read data from Microsoft Lists when the list is stored in a SharePoint site that belongs to your Microsoft 365 tenant and when the list has the correct permissions. This article explains how to connect Copilot to a specific Microsoft List so you can ask for item lookups, filter results, and get summaries directly in the Copilot chat pane.

The connection relies on Copilot’s ability to ground responses using Microsoft Graph data, which includes SharePoint Online and Microsoft Lists. You do not need a separate plugin or connector. The key requirement is that the list must be indexed by Microsoft Search and that your account has at least Read access to the list. This guide covers the setup steps, how to phrase lookup queries, and what to do when the list does not appear in Copilot’s results.

By the end of this article, you will have a working connection between Copilot and your Microsoft List, and you will understand the limitations of what Copilot can retrieve from list data.

How Copilot Discovers and Reads Microsoft Lists

Microsoft Copilot uses the Microsoft Graph API to access data stored in Microsoft Lists. When you ask a question that references a list, Copilot sends a search query to Microsoft Search, which indexes the list content. The search index includes the list title, column names, and row values as long as the list is stored in a SharePoint site that is part of your Microsoft 365 tenant.

The list must be a standard Microsoft List, not a personal list created in the Lists mobile app without a SharePoint backing. Personal lists are not indexed by Microsoft Search and will not appear in Copilot results. Additionally, the list must have at least one column with data that Copilot can use for filtering. Empty lists or lists with only system columns will not return useful results.

Copilot does not require any special configuration in the Copilot admin center. The connection works automatically when the list is searchable and you have permission. However, if your organization has restricted Microsoft Search to specific content sources, the list must be included in those sources. Check with your Microsoft 365 administrator if you cannot see a list that should be accessible.

Prerequisites for List Lookup

Before you attempt any lookup, verify these three conditions:

• You are signed into Microsoft 365 with a work or school account that has a Copilot license. Copilot Pro or Copilot for Microsoft 365 both support list lookups.
• The Microsoft List is stored in a SharePoint site. Go to the list in your browser. The URL should contain sharepoint.com. If the URL is lists.microsoft.com, the list is a personal list and will not work with Copilot.
• You have at least Read access to the list. Open the list in SharePoint, click the gear icon, then select List settings and Permissions for this list. Your name or group must appear with Read or higher permissions.

Steps to Look Up Items in a Microsoft List Using Copilot

Follow these steps to connect and use Copilot for item lookup in a Microsoft List. The steps assume you are using Copilot in a Microsoft 365 app such as Teams, Outlook, or the web version at copilot.microsoft.com.

1. Open Copilot and sign in with your Microsoft 365 account
   Launch Copilot in Microsoft Teams, Microsoft 365 web, or the Copilot mobile app. Ensure your account has a Copilot license and is connected to the same tenant where the list is stored.
2. Verify the list is indexed by Microsoft Search
   In a browser, go to the SharePoint site that contains the list. In the search bar at the top of the site, type the name of your list. If the list appears in the search results, it is indexed. If it does not appear, ask your SharePoint administrator to re-index the site or enable search for the list library.
3. Ask a lookup question using natural language
   Type a query in the Copilot chat pane. Use the format: “Show me items from [List Name] where [Column Name] equals [Value]”. For example: “Show me items from Project Inventory where Status equals Active.” Copilot will return a table with matching rows.
4. Refine the query with multiple filters
   To narrow results, add more conditions. Example: “Show me items from Project Inventory where Status equals Active and Owner equals John.” Copilot supports AND and OR logic in the same sentence.
5. Request a summary or count of items
   Ask for aggregate information. Example: “How many items are in Project Inventory with Status equals Overdue?” Copilot will return a count and can also summarize the values in a specific column.
6. Open the list item directly from Copilot
   If Copilot returns a specific item, click the item name or the link provided. Copilot will open the list item in SharePoint or the Lists app. This works only when Copilot returns a clickable link.

If Copilot Cannot Find the List or Returns No Results

When Copilot does not find the list or returns empty results, the cause is usually one of the following issues. Check each one in order.

Copilot Returns “I cannot find that list” or “No results found”

This error occurs when the list is not indexed by Microsoft Search or when you do not have permission to view it. First, confirm the list appears in SharePoint search as described in Step 2 above. If it does not appear, the list may be in a site that is excluded from search. Contact your SharePoint administrator to verify the site is included in the search scope.

If the list appears in search but Copilot still cannot find it, try using the full list name exactly as it appears in the SharePoint site. Copilot is case-sensitive for list names. For example, “Project Inventory” is different from “project inventory”.

Copilot Returns Data from the Wrong List

When two lists in different sites have similar names, Copilot may return results from the wrong list. To fix this, include the SharePoint site name in your query. Example: “Show me items from Project Inventory in the Marketing site where Status equals Active.” Copilot will use the site context to disambiguate.

Copilot Returns Only Partial Column Data

Copilot can return up to 20 columns from a list by default. If your list has more than 20 columns, Copilot will only show the first 20. To see all columns, ask for specific column names: “Show me the Name, Status, and Owner columns from Project Inventory.”

Copilot List Lookup vs Manual List Search: Key Differences

Item	Copilot List Lookup	Manual Search in SharePoint
Query method	Natural language in chat	Keyword search in SharePoint search box
Filtering	Supports multiple conditions in one sentence	Requires building a view or using the filter pane
Aggregations	Can return counts and summaries	Cannot aggregate; must open list and use Excel export
Column limit	20 columns returned by default	All columns visible in the list view
Access requirement	Must have Read permission and list must be indexed	Must have Read permission and list must be in a searchable site
Result format	Inline table in chat	Link to list with search results highlighted

Copilot list lookup is faster for simple queries and aggregations. Manual search is better when you need to see all columns or edit items directly from the results.

You can now connect Copilot to any Microsoft List in your tenant by ensuring the list is indexed and you have the correct permissions. Use natural language queries with the list name and column filters to get instant results. For advanced lookups across multiple lists, try asking Copilot to combine data from two lists by name in one query, though this may return incomplete results if the lists are not related by a common column.