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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Copilot Studio / Power Virtual Agent Go...
Copilot Studio
Unanswered

Power Virtual Agent Governance - how to get all agents extracted/listedd

(1) ShareShare
ReportReport
Posted on by 25

Hi everybody,

 

is there any option to extract a list of all Power Virtual Agents? I already checked for PowerShell CmdLets and Flow actions but wasn't successful.

Background: I want to expand our current governance process also to Power Virtual Agents. For this, I need a list of all PVA's (ideally with owner, etc.). In a second step, I want to disable and delete PVA's which have not been assessed/approved by the decision bodies.


Many thanks in advance and best regards,

Christian

Categories:
I have the same question (0)
  • Verified answer
    Expiscornovus Profile Picture
    33,189 Most Valuable Professional on at

    Hi @ArnoldC,

     

    You could use a list rows action in a Power Automate flow against the ChatBot table in Dataverse. That will give you a list of chatbots against that current environment. Hopefully that is a good start 🙂

     

    dataverse_listchatbots.png

     

     

  • ArnoldC Profile Picture
    25 on at

    Many thanks @Expiscornovus for the quick answer.
    Do you also know, if and how I would be able to find out, if a PVA is still used (e.g. last activity date, ...)?

  • Expiscornovus Profile Picture
    33,189 Most Valuable Professional on at

    Hi @ArnoldC,

     

    You could check the conversationstarttime property of the ConversationTranscipts table.

     

    Below is another list rows which uses a filter with a lookup to the ChatBot id in an apply to each.

    _bot_conversationtranscriptid_value eq @{items('Apply_to_each')?['botid']}

     

    transcript_conversationstarttime.png

     

  • KevinGodfrey Profile Picture
    12 on at

    @Expiscornovus - I found your suggestions / blog post really helpful.
    @ArnoldC  - Did you ever find a way to get retrieve ChatBots for all environments?


  • HenryJammes Profile Picture
    on at

    The CoE Starter Kit does a pretty good job at helping you make an inventory of all the bots in your tenant: Microsoft Power Platform Center of Excellence Kit - Power Platform | Microsoft Docs

  • KevinGodfrey Profile Picture
    12 on at

    @HenryJammes 
    Thanks for the reply.  I had a look at the CoE Starter Kit.  That uses legacy Dataverse connector to query Chatbots table in Dataverse, but even that flow excludes Teams environments, because you can only access tables in Dataverse for Teams from the same environment.
    We're considering using Dataverse for Teams for end-user / citizen development.
    However there does not seem to be a way to inventory bots in Dataverse for Teams environments.  It's a shame there isn't a connector for PowerVirtualAgents for Admins with an action to 'List all Bots' as there are for Power Automate and Power Apps.

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Copilot Studio

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 255 Super User 2025 Season 2

#2
Romain The Low-Code Bearded Bear Profile Picture

Romain The Low-Code... 205 Super User 2025 Season 2

#3
S-Venkadesh Profile Picture

S-Venkadesh 101 Moderator

Last 30 days Overall leaderboard