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

[ArnoldC]

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

[Expiscornovus · Accepted solution]

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 🙂

[ArnoldC]

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]

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']}

[KevinGodfrey]

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

[HenryJammes]

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