Streamlining SharePoint Integration: A Copilot Studio Tutorial

This tutorial demonstrates how to utilize Copilot Studio’s connector feature to connect to SharePoint lists and display its contents in an adaptive card within a chat window.

To begin, access Copilot Studio at https://copilotstudio.microsoft.com

1. Create a new copilot and name it as “SharePoint Connector”
2. Navigate to Topics & Plugin in the left-hand side menu.
3. Click on the “Create” button, then select “Topic” and choose “From blank.”
4. Once the blank Topic is created,
5. Set the Trigger action phrase as “Get SharePoint Lists”
6. Add the action “Ask a question” with the following properties:
  - Message: Enter SharePoint URL…
  - Identify: URL
  - Save user response as: strURL (create new variable)
7. Click the + icon and select Call an action from the menu. Then choose the Connector (preview) tab and search for SharePoint connectors by entering “SharePoint”
8. Select the “Get Lists” connector action from the search results. This will prompt a Connect or Pick a connection dialog box. Check SharePoint connector is connected and Click Submit to create the connection.
9. After adding the connector action, set the Site Address value as the strURL value.
10. Click the + icon again and select Send a message action. In the message action, click the Add button menu and choose Adaptive Card.
11. In the added Adaptive Card media type, click the Media box to open the Adaptive card properties panel on the right side.
12. In the properties panel, switch from Edit JSON to Edit Formula and add the following value to the Adaptive Card JSON.
13. Click the Close icon to save the adaptive card formula
14. Finally, click the Save button to save the topic.

During testing, in the Test copilot window, input “Get SharePoint List” to trigger the topic. It will prompt you to enter the SharePoint URL. After entering a valid URL, it will establish the connection and display the list’s contents using the Adaptive Card action.