Skip to main content
Community site session details

Community site session details

Session Id : 08w80LMBJwVI7gjMpZNeAE
Copilot Studio - Topic Creation & Management
Unanswered

xls format for topic suggestions

Like (0) ShareShare
ReportReport
Posted on 1 Apr 2022 12:42:55 by 2

Hi All,

 

i am also struggling in creating a suitable xls sheet for getting suggested topics. I have 2 columns. in column 1 i out several triggers and column2 contains the answers.

 

1. when i import the xls the triggers are not shown as single triggers but all together in 1 and the answers are cut if there is a comma in that sentence. can anyone tell me what a proper format looks like?

 

thx

chris

  • Anurooprtj Profile Picture
    8 on 26 Jul 2022 at 10:57:48
    Re: xls format for topic suggestions

    Yes. We can add trigger phrases along with the topic using the two column (question, answer) excel sheet. In the question cell, the first sentence will be taken as topic and remaining sentences will be taken as trigger phrases along with the topic name. We can use either commas to seperate or just give each phrase in the new line 

  • Pstork1 Profile Picture
    67,079 Most Valuable Professional on 13 May 2022 at 13:36:53
    Re: xls format for topic suggestions

    Please post this as a new question.  You'll get a lot more responses that way and others will be able to find the answer once its solved.

  • Community Power Platform Member Profile Picture
    on 13 May 2022 at 08:39:52
    Re: xls format for topic suggestions

    Hi. I'm also having a similar issue. I want to prepopulate lots of triggers associated with a single answer, such as a static exchange rate. I'd like people to be able to ask for a rate in various ways: "Japan rate", "Japanese rate", "JPY exchange rate", "Yen rate", and have it answer "121". So far I haven't been able to get the suggest topics feature to work with this. To be clear, I can get suggest topics to work, but so far it's only been on a 1 to 1 (one question, one answer) basis.

     

    Is a two column excel sheet with the triggers separated by commas in the first column the way to go? Has anyone actually succeeded with this? Or is there another way? I'd be really interested to hear anyone else's experiences.

  • Pstork1 Profile Picture
    67,079 Most Valuable Professional on 01 Apr 2022 at 13:42:45
    Re: xls format for topic suggestions

    I haven't tried using questions that contain commas.  But in the sample I used there was an answer that contained a comma.  It was not truncated when I imported the .xlsx file.  It came in as Baltimore, MD.  But I have seen it missfire a couple times and truncate on a comma.  It should work, but it isn't consistent.

  • chrisj76 Profile Picture
    2 on 01 Apr 2022 at 13:38:27
    Re: xls format for topic suggestions

    thank you so much @Pstork1. this gives me abit of an idea 🙂

    my thought was to have several trigger expressions already in the xlsx and the answer as well as the answer

     

    Capture.PNG

    I thought i want to upoad the triggers directly instead of putting them in manually. does that make sense?

     

    i still have the problem that every question and answer containing a comma will be cut after the comma.

  • Pstork1 Profile Picture
    67,079 Most Valuable Professional on 01 Apr 2022 at 13:11:31
    Re: xls format for topic suggestions

    PVA doesn't support .xls, only .xlsx.  The following works for me when saved as an .xlsx

    image.png

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

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Copilot Studio

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 169 Super User 2025 Season 2

#2
Romain The Low-Code Bearded Bear Profile Picture

Romain The Low-Code... 150

#3
sandeep_angara Profile Picture

sandeep_angara 75 Super User 2025 Season 2

Featured topics

Loading started
Loading complete