Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
Announcing Mentions and Quick Responses!
Give Back to the Community this Month
Join us in the Community for an AMA: December 12th Register Today
News and Announcements icon
Power Platform Community / Forums / Copilot Studio - Topic Creation & Management / Copilot Studio Sharepo...
Copilot Studio - Topic Creation & Management
Answered

Copilot Studio Sharepoint Excel

(1) ShareShare
ReportReport
Posted on by AC-07110539-0 10
Dear All,
 
I am trying to test the Sharepoint Knowledge Source with Excel file i did the followowing.
 
1. Created the knowledge Source as Sharepoint.
2. Pointed to the file under documents folder
3. Created the "Inputs" Section, you can see the screen shot attached.
4. Created the "outputs" Section, you can see the screen shot attached.
 
Still i am not able to get any answers while testing the agent, it says " No information was found that could help answer this."
 
Please help me here....
Categories:
General
Knowledge.png
Inputs Section.png
Output Section.png
  • Verified answer
    Vinoth Selvam Profile Picture
    Vinoth Selvam 1,067 on at
    Copilot Studio Sharepoint Excel
    I have tried and the below links works as expected.
     
     
    Please make sure there are no issues related to security and Authentication. Can you try with Manual authentication method?
     
     
     
    Thanks.
     
  • Suggested answer
    AC-07110539-0 Profile Picture
    AC-07110539-0 10 on at
    Copilot Studio Sharepoint Excel
    Dear All,
    i could able to solve the issue by changing the setting located at "Using generative AI in conversations" to "AI Generative"
     
    Thanks for all the support
  • AC-07110539-0 Profile Picture
    AC-07110539-0 10 on at
    Copilot Studio Sharepoint Excel
  • AC-07110539-0 Profile Picture
    AC-07110539-0 10 on at
    Copilot Studio Sharepoint Excel
    Thank you for replying to my question, I have seen couple of videos where in Excel is formatted as table and can extract the data, here are the videos...
     
     
    This is what I am trying to do..
     
    1. My sales and accounts team will post the updated excel to one of my sharepoint location.
    2. I wanted this agent to answer the question to all other relevant departments.
     
    Ofcourse I am formatting as table etc etc.
     
    Please suggest.
     
    Regards
    Anil Charan.
  • CU07110739-0 Profile Picture
    CU07110739-0 2 on at
    Copilot Studio Sharepoint Excel
    Hi, according to documentation for Copilot Studio, gen AI supported content don't include excel...

    Generative answers obtain content stored in these formats:

    • SharePoint pages (modern pages)
    • Word documents (docx)
    • PowerPoint documents (pptx)
    • PDF documents (pdf)
    https://learn.microsoft.com/en-us/microsoft-copilot-studio/nlu-boost-node#supported-content

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

News and Announcements

Welcome to the Power Platform Communities
Announcing Mentions and Quick Responses!
Give Back to the Community this Month
Join us in the Community for an AMA: December 12th Register Today

Quick Links

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

more Community News

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,532

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 64,050

Leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans