Showing results for 
Search instead for 
Did you mean: 
Resolver I
Resolver I

Export bot's topics to an excel file

Hi All,


I have used the O365 bot template available in PVA (I imported the bot into TEAMS as an app). I published the bot, it is available as a link, and I would like to check what are the missing topics? (before publishing the bot as an TEAMS app)

Instead of opening all the topics one by one, i would like to export all the topics to excel in order to facilitate my review.


I don't find the way to do it from TEAMS ?

and when i go to Power Apps, section chatbot, i don' t see my bot...


how can i do?


Thank you,

Super User
Super User

Hi @Peggy2019 ,


When you are using PVA for Web, you can see/export all topics as an excel file within the Power Apps portals.


1- Open 

2- Change the environment (top-right) to Default environment

3- Go to Dataverse (left menu) >> Tables

4- Change the filter (top-right) to "All"

powerapps-data-entities-view.png (2907×771) (

5- Filter by "Chatbot" table

6- Select the table

7- Go to Data tab (Within the table details)

8- Select the bot that you want

9- Click on the Edit record button in the top navigation

10- Then you will see all details from your bot and you can export the topic and so on.


From Teams, it's not possible yet.

You can vote in my idea below:

Export bot's topics to an excel file from PVA for ... - Power Platform Community (

Did I answer your question? Mark my post as a solution!

Renato Romão,

Connect with me here 😉

Power Virtual Agents course (+2.760 students) : English | Português

Hi @renatoromao , thanks for the solution but I got stuck at point 6, to which table are you referring to? That is what I see once I complete step 5:



Many thanks for any further support you could provide 😀


P.S. I have just tagged you in an idea I have posted which is similar to one of yours (i.e. excel report with topics): 

Super User
Super User

Hi @Francone ,


Step 6 is only to open the table (that you did).

Now, you can go to step 7 🙂


I've voted on your idea.

Did I answer your question? Mark my post as a solution!

Renato Romão,

Connect with me here 😉

Power Virtual Agents course (+2.760 students) : English | Português
Advocate I
Advocate I

Many thanks Renato, much appreciated! I have managed to export all topics successfully (page by page unfortunately) and the content of messages in the authoring canvas for each topic is unfortunately included in the content column along with the entire script.





While awaiting Microsoft to develop this feature, I need to think of a way to extract only the content of the actual answers, any suggestions?

Helpful resources

Canadian Cloud 2022 768x460.png

Register for a free PVA chatbot creation workshop.

Learn how to respond rapidly to your customers and employees at scale, using intelligent conversational chatbots.

PVA Community Blog Build Carousel (1) (1).png

What does the community say?

Discover what our community thinks about the announcements at Build 2022.

June 14th PVA AMA Carousel (up on May 25th, take down June 15th) (1).png

'Ask Microsoft Anything' about Power Virtual Agents!

Join the community to ask questions and provide helpful answers about Microsoft's conversational AI and Power Virtual Agents.

Top Kudoed Authors
Users online (1,615)