Welcome to part 9 and the final part of this blog post series.
If you missed the previous parts, visit the links below:
- Part 1: Create a Microsoft Form
- Part 2: Create a Power Platform Environment
- Part 3: Create a Copilot Studio Agent (Name, Image, Description, and Instructions)
- Part 4: Create an Excel Spreadsheet Listing Trainers and Qualified Courses
- Part 5: Create an Excel Log File to Record Mentor Requests
- Part 6: Create a Trigger in Copilot Studio
- Part 7: Add Tools to a Copilot Studio Agent
- Part 8: Amend Existing Agent Instructions to Use Tools
In this blog post, I’ll test the autonomous agent end to end to ensure everything works as expected.
During this test, I will:
- Submit the Microsoft Form created in part 1, selecting SC-401 as the requested course
- Wait for the agent to trigger automatically
- Verify that the agent reads the Mentors.xlsx file and identifies a suitable mentor
- Confirm that an email is sent to the mentor associated with the SC-401 course
- Check that a new row is added to the RequestLogs.xlsx file with the request and assignment details
Task: Test the autonomous agent
- Access the Microsoft Form created in part 1 of this blog post series and submit a new response.


2. Check that the Microsoft Form has been submitted successfully.

3. Now we wait for the autonomous agent to do its job. In my case, it took less than a minute for the agent to start processing the request.
Email sent to Mentor ✅
An image is shown below confirming that the mentor received the email notification

Mentor Assignment Confirmed ✅
Hannah Doe has been correctly identified as the mentor for the SC‑401 course. The file shown below confirms that Hannah is listed as the mentor for SC‑401.

Log file updated with requester details and assigned mentor ✅
RequestLogs.xlsx file has been automatically updated with the requester’s details and the assigned mentor.
The image below shows the log entry confirming Hannah Doe was assigned as the mentor for the SC‑401 course.

The next step is optional. If you’d like to test the trigger manually without submitting another Microsoft Form response, follow the steps below.
- Go to Copilot Studio at copilotstudio.microsoft.com and select the agent
- Click Test, located in the top right corner of the Copilot Studio interface
- Click the three dots, as shown in the image below
- Click Test Trigger
- Select When a new response is submitted

Select the response you want to test, then click Start testing

The screenshot below illustrates how the agent processed each task step by step, from detecting the form submission to completing all configured actions.

And that’s it.
I hope you enjoyed following this blog post series and learned something new.
If you have any feedback or thoughts, I’d love to hear them, please feel free to leave a comment below.


This was an easy to follow series. Thank you