Skip to main content

Notifications

Topic Creation & Management
Unanswered

import PVA topics from excel

Posted on by 3

Hi all,

Is it possible to import topics with trigger phrases from excel in PVA?

I have an excel file that contains links to knowledge articles and multiple keywords for each knowledge article. I would like to automate the creation of PVA topics. For each knowledge article listed in the excel file I need to create a topic in PVA.

Thanks

  • Pstork1 Profile Picture
    Pstork1 63,085 on at
    Re: import PVA topics from excel

    I don't think that is going to be possible using the suggested Topics feature.  Its designed to pull in questions and make them Topics and then one answer for each question. The answer can include a hyperlink.  Take a look at the example here: Get topic suggestions from online content (contains video) - Power Virtual Agents | Microsoft Learn

  • jeffto Profile Picture
    jeffto 3 on at
    Re: import PVA topics from excel

    Thank you for your answer! It is very helpful. Is it also possible to import a "show a message" in PVA with an excel import? In the same excel file where I have the titles and keywords for the topics there is a column with links to knowledge articles that I need to get as an answer in PVA.

  • Pstork1 Profile Picture
    Pstork1 63,085 on at
    Re: import PVA topics from excel

    Yes, you can import topics from an Excel file using the Suggested Topics feature.  You can read about it here: Get topic suggestions from online content (contains video) - Power Virtual Agents | Microsoft Learn

    The main issue I've seen people have is that the Excel file needs to be accessible from a non-authenticated URL for the import.  

Helpful resources

Quick Links

Welcome to the Power Platform…

We are thrilled to unveil the newly-launched Power Platform Communities!…

Getting Started…

Welcome to the Power Platform Community! We appreciate your visit…

Welcome to the new Power Platform Community!…

We are excited to announce our new Copilot Cookbook Gallery in the Community…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 138,030

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,085

Leaderboard

Featured topics