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

Suggest Topic (CSV and XLSX format)

Hi,

 

In Power Virtual Agent, 'Suggest Topic' option allows us to add online CSV or XLSX file. However, I could not figure out what is the CSV format or XLSX. Any working sample?

I tried adding a CSV file with 2 columns, and it failed. The error message is 'We couldn't get suggestions. Try adding support or FAQ content.'

 

CSV Example,

"insurance type","We have Life, Medical and Term insurance"
"benefit","Yearly dividend, life protection"
"location","Damansara Heights"

1 ACCEPTED SOLUTION

Accepted Solutions
Jcook
Super User
Super User

Hello @lcp2021 

 

These docs explain the requirements for the files:

https://docs.microsoft.com/en-us/power-virtual-agents/advanced-create-topics-from-web#prerequisites

Here is a snippet of the requirements:

Important

  • The URLs must be secure (they must start with https://).
  • The URLs must be publicly available, that is, they can't need a user to log in.
  • For online files, we do not support file upload. You must provide the full URL to the location of the file, including the file extension, as in the example https://www.microsoft.com/thisisafile.pdf.
  • For online files, we currently support PDF, DOCX, PPTX, TXT files and 2-column formats in TSV, XLSX (first sheet only), and CSV. The file extension must be included in the URL.

 


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

If you like my post please hit the Thumbs Up


Proud to be a Flownaut!


Check out my blog for Power Automate tips,
tricks, and guides
FlowAltDelete





View solution in original post

3 REPLIES 3
Jcook
Super User
Super User

Hello @lcp2021 

 

These docs explain the requirements for the files:

https://docs.microsoft.com/en-us/power-virtual-agents/advanced-create-topics-from-web#prerequisites

Here is a snippet of the requirements:

Important

  • The URLs must be secure (they must start with https://).
  • The URLs must be publicly available, that is, they can't need a user to log in.
  • For online files, we do not support file upload. You must provide the full URL to the location of the file, including the file extension, as in the example https://www.microsoft.com/thisisafile.pdf.
  • For online files, we currently support PDF, DOCX, PPTX, TXT files and 2-column formats in TSV, XLSX (first sheet only), and CSV. The file extension must be included in the URL.

 


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

If you like my post please hit the Thumbs Up


Proud to be a Flownaut!


Check out my blog for Power Automate tips,
tricks, and guides
FlowAltDelete





View solution in original post

Jcook
Super User
Super User

Hi @lcp2021 


Could you provide an update on your issue?


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

If you like my post please hit the Thumbs Up


Proud to be a Flownaut!


Check out my blog for Power Automate tips,
tricks, and guides
FlowAltDelete





Jcook
Super User
Super User

Hi @lcp2021 

Just following up on this

 

@renatoromao 


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

If you like my post please hit the Thumbs Up


Proud to be a Flownaut!


Check out my blog for Power Automate tips,
tricks, and guides
FlowAltDelete





Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Planning-build-bot-2-5-20-768x460.png

New Year’s Resolution - Build Conversational Bots!

Access all of the Power Virtual Agents learning resources and join the January learning challenge.

Top Kudoed Authors
Users online (2,547)