Skip to main content

Notifications

Community site session details

Community site session details

Session Id : 5RSKushYU5GqOAX+b85PFO
Copilot Studio - General
Suggested answer

Agent Creation

Like (2) ShareShare
ReportReport
Posted on 14 Apr 2025 07:04:59 by
Greetings, I am trying to build an agent which can read financial data from the excel provided as knowledge. The agent must be capable enough to read the data from the knowledge and provide the calculated result effectively, it should render all the matched results. How can I achieve this result? Is it possible for an agent to calculate implicitly without hardcoding? Tried with creating agent using description but not that effective. Can anyone help me with this? How can I achieve this ? 
Categories:
  • Suggested answer
    w.p Profile Picture
    4,090 on 14 Apr 2025 at 17:57:24
    Agent Creation
    an example reading interest rate from excel file knowledge source.
  • ronaldwalcott Profile Picture
    3,625 on 14 Apr 2025 at 17:39:22
    Agent Creation
    What type of description did you use?
     
    Look at this example of using Copilot in Excel
     
    The agent will first have to understand the relationship between the columns. It cannot calculate without understanding what it is calculating. 
     
    You can use flows for the calculations but the logic has to be added into the flow.
     

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…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,731 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,075 Most Valuable Professional

Leaderboard
Loading started