Skip to main content

Notifications

Copilot Studio - Topic Creation & Management
Answered

Export bot's topics to an excel file

(0) ShareShare
ReportReport
Posted on by

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,

  • Re: Export bot's topics to an excel file

    thank you unfortunately i don't have PVA standalone license. But thanks for the quick and comprehensive reply, i assume that it will help me later.

  • Verified answer
    whatever_cary Profile Picture
    whatever_cary 14 on at
    Re: Export bot's topics to an excel file

    @Francone Did you ever some up with a solution for this? I am currently staring at the data overthinking how I can extract the topics and get rid of all of the other code.

     

    Thanks 🙂 

    Cary

  • Francone Profile Picture
    Francone 4 on at
    Re: Export bot's topics to an excel file

    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.

     

    Francone_0-1641983615127.png

     

     

    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?

  • renatoromao Profile Picture
    renatoromao 6,819 on at
    Re: Export bot's topics to an excel file

    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.

  • Francone Profile Picture
    Francone 4 on at
    Re: Export bot's topics to an excel file

    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:

     

    Francone_0-1641910553000.png

    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): https://powerusers.microsoft.com/t5/Power-Virtual-Agents-Ideas/Export-topics-and-full-content-of-authoring-canvas-for-each/idi-p/1412852 

  • renatoromao Profile Picture
    renatoromao 6,819 on at
    Re: Export bot's topics to an excel file

    Hi @Anonymous ,

     

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

     

    1- Open make.powerapps.com 

    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) (microsoft.com)

    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 (microsoft.com)

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,422

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,711

Leaderboard

Featured topics