cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
chrisj76
New Member

xls format for topic suggestions

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

5 REPLIES 5
Pstork1
Dual Super User
Dual Super User

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

image.png



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

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.

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.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
mikecaronna
Regular Visitor

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.

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.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

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.

Top Solution Authors
Top Kudoed Authors
Users online (4,243)