Skip to main content

Notifications

Community site session details

Community site session details

Session Id : ca3BDHA7EBXM6/OT0OeeFX
Copilot Studio - General
Unanswered

How to integrate an Excel file into Microsoft Copilot Studio from Microsoft Teams ?

Like (1) ShareShare
ReportReport
Posted on 14 Mar 2024 12:52:44 by 8

Hello, I have a favor to ask the community. I have an Excel file that contains 2 columns. "Abkürzung" which means initial in German and "Bedeutung" which means meaning. My aim is that with the Microsoft Copilot Studio software, in Teams I can integrate the Excel file and then if a user wants to know the meaning of an initial, the software will look it up in the Excel file and come up with the meaning. This saves the bot creator a lot of time by not having to handwrite the initials and meanings. Is this clear to you, and if so, how do I know if it's possible?

Categories:
  • AlwinV225 Profile Picture
    8 on 08 Apr 2024 at 13:51:46
    Re: How to integrate an Excel file into Microsoft Copilot Studio from Microsoft Teams ?

    In fact, when I test it, it shows me directly in my channel on Teams, but when I want to activate my bot in my channel, it doesn't respond. Why is this?

  • AlwinV225 Profile Picture
    8 on 08 Apr 2024 at 13:19:24
    Re: How to integrate an Excel file into Microsoft Copilot Studio from Microsoft Teams ?

    Hello @Jcook @theMac 

     

    I've already managed to work on my flow on Power Automate from Microsoft Teams. That's the first thing I've done, but the problem is that, according to the screenshot you can see, my flow works but when I test it by asking for initials, it doesn't return anything. Do you think you know why?

  • AlwinV225 Profile Picture
    8 on 27 Mar 2024 at 13:11:51
    Re: How to integrate an Excel file into Microsoft Copilot Studio from Microsoft Teams ?

    Hello

    Regarding your message @Jcook, I've checked under AI feature and there's nothing that allows to load a file in Microsoft Copilot Studio from Teams unfortunately.

     

    @theMac, I had already tried with Power Automate with your idea but I got error messages. I'd have to review my model again to get it to work again. But with your link, it might work.

     

    Thank you both for your replies. I hope it works, but if it doesn't, I'll get back to you 😀

  • theMac Profile Picture
    on 26 Mar 2024 at 09:57:56
    Re: How to integrate an Excel file into Microsoft Copilot Studio from Microsoft Teams ?

    Unless there have been recent developments, Copilot's AI does not work well with structured data in tables while it is much better with unstructured data (text in word, pdf with a lot of text, etc.).
    To do what you are asking, you can use copilot by calling up a flow of Power Automate, without bothering the AI: in Power Automate you will do the matching in the Excel file by providing the initials as input and it will return the corresponding string to copilot as output.
    Please note that in excel the data must be structured in a table with headers in the first row (it is not enough to have entered them in a simple excel sheet)
    See here:
    https://powerusers.microsoft.com/t5/General/Copilot-and-PowerAutomate-Excel-get-a-row-function/m-p/2667682#M9844

  • Jcook Profile Picture
    7,770 Most Valuable Professional on 26 Mar 2024 at 09:15:26
    Re: How to integrate an Excel file into Microsoft Copilot Studio from Microsoft Teams ?

    Hi @AlwinV225 

     

    Should be under AI features. Some UIs are different depending on region and settings.

  • AlwinV225 Profile Picture
    8 on 25 Mar 2024 at 09:58:54
    Re: How to integrate an Excel file into Microsoft Copilot Studio from Microsoft Teams ?

    Hello @Jcook 

    Thank you for your message, but in the "Settings" sidebar of my chatbot in Microsoft Teams, there is only :

     

    • Details
    • AI integration tools
    • Channels
    • Engagement hub
    • Security
    • Skills
    • AI features

     

    There's no "Generative AI" in the settings, so no "Upload a document" (preview) and I searched for a while anyway.

     

    Is there a particular reason for this?

  • Jcook Profile Picture
    7,770 Most Valuable Professional on 17 Mar 2024 at 04:55:59
    Re: How to integrate an Excel file into Microsoft Copilot Studio from Microsoft Teams ?

    Hi @AlwinV225

    you can follow this guide from the docs:

    https://learn.microsoft.com/en-us/microsoft-copilot-studio/nlu-documents#uploading-a-document

     

     

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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Copilot Studio - General

#1
Ekta Gupta Profile Picture

Ekta Gupta 4

#2
ricardodesouza Profile Picture

ricardodesouza 2

#2
L-1234567-0 Profile Picture

L-1234567-0 2

Overall leaderboard