web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Copilot Studio - Calling Actions from Copilot S...
Suggested answer

Calling tools from an Agent to create a prepopulated Excel

(0) ShareShare
ReportReport
Posted on by 2
I have created an Agent to read input file , analyze it and create an output excel file which is prepopulated.  I am using tools to create Excel , but How do I tell it to read the content from the Agent's knowledge source ?
ere is my flow;   The excel is not prepopulated as I expected it
 
Categories:
I have the same question (0)
  • Suggested answer
    Michael E. Gernaey Profile Picture
    50,275 Super User 2025 Season 2 on at
    Calling tools from an Agent to create a prepopulated Excel
     
    Add a string Input into your Agent flow, that points to the file.
    Then in the Agent flow use Get File Contents (depending on SharePOint or OneDrive)
     
    Get the content and use it to iterate through and save the data into your Excel

    If these suggestions help resolve your issue, Please consider Marking the answer as such and also maybe a like.

    Thank you!
    Sincerely, Michael Gernaey

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Tom Macfarlan – Community Spotlight

We are honored to recognize Tom Macfarlan as our Community Spotlight for October…

Leaderboard > Copilot Studio

#1
Romain The Low-Code Bearded Bear Profile Picture

Romain The Low-Code... 523 Super User 2025 Season 2

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 378 Super User 2025 Season 2

#3
DAnny3211 Profile Picture

DAnny3211 132

Last 30 days Overall leaderboard

Featured topics