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

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Copilot Studio / Using Excel tool to se...
Copilot Studio
Suggested Answer

Using Excel tool to search

(0) ShareShare
ReportReport
Posted on by menphis 58
Hi
I am trying to create an agent that should search on an Excel portfolio.

i have created a tool "List rows present in a table" and i am trying to create a topic (when the user mentions an asset, ask him which asset you want to search for)
So i am trying to filter the query of my tool using the variable that contains the asset but its not working
Can you help me please ?

Thank you
@Valantis@chiaraalina@Michael E. Gernaey

Categories:
Copilot Studio pre-built agents/templates
Topic creation & management
Copilot Studio skills development
General topics
I have the same question (0)
  • Suggested answer
    chiaraalina Profile Picture
    chiaraalina 2,425 Super User 2026 Season 1 on at
    Hi  @menphis
     
    I get the exact same error.
     
    I checked for known issues in the Power Platform Admin Center and found this:
     
     
    A solution is being planned. 
     
    To workaround the problem, we can configure the input using PowerFx. Follow these steps. 
     
    1. Navigate to the tool created
    2. Using the code editor, remove all the inputs that are properties of the records that needs to set from the Topic node
    3. Navigate to the Topic node
    4. Add an input
    5. Select the record of the properties that needs to be set
    6. Select the Formula option
    7. Enter the inputs as an object { key: "String Value" , key2: Topic.Variable }
      Result: There is no error and inputs are passed to the tool.
     
    The workaround worked for me!
     

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

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Copilot Studio

#1
Valantis Profile Picture

Valantis 277

#2
11manish Profile Picture

11manish 206

#3
sannavajjala87 Profile Picture

sannavajjala87 156 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Announcing the "Microsoft Copilot Studio ❤️ MCP" lab
Block PII/PCI in Copilot Studio agent user prompt

Product updates

Microsoft Power Platform Community release plans