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...
Unanswered

Issue with “Add Row to Table” Tool in Excel Business and Agent Tool Access

(1) ShareShare
ReportReport
Posted on by 7
Hello everyone,

i have an issue related to the tool “Add row to table” (Excel Business). The topic is supposed to handle queries where the agent receives a meeting transcript, which should first be unformatted and then inserted into an Excel log.
This query was still working until the beginning of last week, even though the entries weren’t exactly as I wanted them.
Unfortunately, for the past few days, the agent has been asking: “Please specify the row to be added to the Excel table.” When I provide a row, I get the message: “Could not assign input 'Row'.”
Actually, the agent should determine where the next free row is and make the entries there.
The tool’s input “Row” is set to “Fill dynamically with AI” and the value cannot be changed.

For testing, I had added a weather query (also as a tool and topic) to the agent some time ago, and it always worked without any issues.
Unfortunately, the agent now gets stuck on the question “What’s the weather like today?” and apparently can’t access the tool anymore.
Are there currently any updates being made, or have any changes been implemented, or does anyone know how to fix these problems?

Thank you in advance!

Best regards,
Pascal
 
 
EDIT:
I deleted and recreated the tools. The weather can now be queried again. Unfortunately, I keep encountering the issue where the connection to the Excel tool is removed, and I can no longer add it back. The connection seems to remain active for now, but the system still asks for the row. Therefore, the original problem persists.
Categories:
I have the same question (2)
  • Michael E. Gernaey Profile Picture
    51,671 Super User 2025 Season 2 on at
    Issue with “Add Row to Table” Tool in Excel Business and Agent Tool Access
     
    There have absolutely been updates and when that happens... things break.
     
    That being said, can you look at the Activities Tab and let's see what its doing when you try.
     
    Also, is there any chance in your license (is it a Trial copilot? or to your Power Apps or Power Automate (all depending on your Copilot license that might already include premium licenses))
     
     
  • CU01100452-0 Profile Picture
    4 on at
    Issue with “Add Row to Table” Tool in Excel Business and Agent Tool Access
    Same problem! Is there any new update for this?
     
     
     
     
  • DAnny3211 Profile Picture
    132 on at
    Issue with “Add Row to Table” Tool in Excel Business and Agent Tool Access
    Hi,
    
    The issue you're experiencing with the **“Add row to table”** tool in Excel Business—where the agent now prompts for a specific row and fails to assign it—is likely related to recent backend updates in Copilot Studio that have affected dynamic input handling.
    
    Here are a few steps you can take to troubleshoot:
    
    1. **Check the Activities tab**: Ensure that the tool is still properly connected and that the activity is listed and active. Sometimes, tools may become unlinked after updates.
    
    2. **Review license and permissions**: Some features, especially those involving dynamic AI input, may depend on specific license tiers or tenant configurations. Make sure your environment still meets the requirements.
    
    3. **Reconfigure the tool input**: Even though the “Fill dynamically with AI” option is selected and locked, try removing and re-adding the tool to the topic. This can sometimes reset the configuration and restore functionality.
    
    4. **Weather tool issue**: If the agent is stuck on questions like “What’s the weather like today?”, it may indicate a broader issue with tool invocation. Verify that the tool is still accessible and that the topic hasn’t lost its orchestration settings.
    
    For more details, you can refer to the official documentation:  
    - Copilot Studio: Add row to Excel table  
    - Copilot Studio: Tool orchestration and troubleshooting
    
    Please check if these steps help resolve the issue.
    
    Thanks and best regards,  
    Daniele  
    *Note: This response was prepared with support from Copilot to ensure clarity and completeness.*
  • Michael E. Gernaey Profile Picture
    51,671 Super User 2025 Season 2 on at
    Issue with “Add Row to Table” Tool in Excel Business and Agent Tool Access
     
    We should take this a new direction.
     
    I am going to post some specific actions for you to do if you are cool with it.
     
    What I do really need is if you can share a copy of your Bot in a way I can use it to repro it?
     
    I'd love to solve this for you and the other 2 people who are asking.
     
    Thanks!!
  • Pascal. Profile Picture
    7 on at
    Issue with “Add Row to Table” Tool in Excel Business and Agent Tool Access
    Update: 

    First of all: Thank you very much for all the messages and support!

    Due to vacation and other, more important topics, I unfortunately haven’t had the chance to try out much more.
    In the meantime, I received a full license for copilot studio from our IT department, but this had no effect on the problem either.

    A few days ago, I tried again for the first time in 1–2 weeks, and it worked. Unfortunately, the issue reappeared during the second test (about 30–60 minutes later).

    What I’ve tried so far

    1. Deleted the tool and added it again

    2. Created a new agent and set up the tool there

    3. In both cases (1 and 2), created new connections

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…

Chiara Carbone – Community Spotlight

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

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