web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Copilot Studio / Autonomous Agent to pe...
Copilot Studio
Suggested Answer

Autonomous Agent to perform QA

(0) ShareShare
ReportReport
Posted on by 2
Hi All,
 
I am exploring creation of a Copilot Studio Agent that can perform set of Quality assurance scripts on a fixed frequency basis. Please find below a brief summary of the context.
 
  1. As a part of our QA process to validate adherence to internal policy we perform a set of scripts on a monthly basis. They fall into two major categories
    1.  Validating certain fields are accurately populated in our inventory, checking if an user is still active in the company etc.
    2. Validate if the in scope teams have documented control procedures as required by policy
  2.  The major sources of information for this would be 
    1.  Inventory Report
    2. Policy documentation
    3.  Individual documentation by each of the teams
  3.  We have a set of scripts to verify adherence to each of the policy standard
This is what i could find out based on my readings about Copilot Agent.
  1. Can access Sharepoint (this is where all the documentation will be stored)
  2. Can be triggered based on event such as Recurrence
  3.  If required can access send out an email for human in loop scenarios.
I am looking for some guidance on the following
  1.  Is it possible to have the Agent perform set of tasks (basically execute a set of scripts i.e. prompts) and store the output of this whole exercise in a predefined excel sheet
  2. How can agent access external systems for e.g. checking if a certain employee is still active, posting the results of the QA in an external system ( I think this will require MCP).
 
Thanks
Categories:
I have the same question (0)
  • Suggested answer
    Michael E. Gernaey Profile Picture
    53,978 Moderator on at
     
    See inline
     
    This is what i could find out based on my readings about Copilot Agent.
    1. Can access Sharepoint (this is where all the documentation will be stored)
    2. Can be triggered based on event such as Recurrence
    3.  If required can access send out an email for human in loop scenarios.
    I am looking for some guidance on the following
    1.  Is it possible to have the Agent perform set of tasks (basically execute a set of scripts i.e. prompts) and store the output of this whole exercise in a predefined excel sheet 
      [Michael] Yes it is
    2. How can agent access external systems for e.g. checking if a certain employee is still active, posting the results of the QA in an external system ( I think this will require MCP).
      [Michael] No this does not require MCP, it requires connectors. It is possible that the external system HAS an MCP built for it, but if not, you need to use a Custom Connector or HTTP Connector to call API's it exposes.
     

    If these suggestions help resolve your issue, Please consider Marking the answer as such and also maybe a like.

    Thank you!
    Sincerely, Michael Gernaey
  • NP-02012003-0 Profile Picture
    2 on at
     
    Are there any materials/guide that I can read up for both of these.
    In my usecase the QA analyst today manually checks a data dump and documents to verify if they are in line with internal policy. 
    I am thinking this as a multi agent solution
    1) Agent to procure the data
    2) Agent to clean up the data
    3) Agent to execute the checks
     
    For Point 2 below
    I thought MCP is required for an LLM to interact with system.
     
    1.  Is it possible to have the Agent perform set of tasks (basically execute a set of scripts i.e. prompts) and store the output of this whole exercise in a predefined excel sheet 
      [Michael] Yes it is
    2. How can agent access external systems for e.g. checking if a certain employee is still active, posting the results of the QA in an external system ( I think this will require MCP).
      [Michael] No this does not require MCP, it requires connectors. It is possible that the external system HAS an MCP built for it, but if not, you need to use a Custom Connector or HTTP Connector to call API's it exposes.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Copilot Studio

#1
Valantis Profile Picture

Valantis 835

#2
Vish WR Profile Picture

Vish WR 294

#3
Haque Profile Picture

Haque 248

Last 30 days Overall leaderboard