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 :
Power Platform Community / Forums / Copilot Studio - General / Aggregating from diffe...
Copilot Studio - General
Unanswered

Aggregating from different columns in excel

(1) ShareShare
ReportReport
Posted on by AL-05110734-0 2
How can we prompt Copilot Studio to extract data from two separate columns in an Excel file and aggregate the values? We've found that Copilot often fails to correctly interpret queries involving summing across multiple columns
Categories:
General
I have the same question (0)
  • Romain The Low-Code Bearded Bear Profile Picture
    Romain The Low-Code... 1,373 Super User 2025 Season 2 on at
    Aggregating from different columns in excel
    hello,
     
    Default behavior of IA is using RAG to get few best result and summarize, it's not intented to make calculation on data. If you wana achieve this i recommand to use the prompt tool and enable code interpreter from the tool settings and explein you'r prompt, the column you need to use in the excel and let it create the python code to make calculation.

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

Quick Links

Responsible AI policies

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

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Congratulations to the October Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Copilot Studio

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 479 Super User 2025 Season 2

#2
Romain The Low-Code Bearded Bear Profile Picture

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

#3
DAnny3211 Profile Picture

DAnny3211 49

Last 30 days Overall leaderboard

Featured topics

Generative orchestration updates coming to Microsoft Copilot Studio! 
Please Read for Updates on Forums & Blogs
Tips & tricks for using the Power Virtual Agents Boost Conversational Coverage Preview

Product updates

Microsoft Power Platform Community release plans