New Agent Experience - Adding Excel Tool

Hi,

For Excel Online (Business), use:

• Location = OneDrive for Business or SharePoint Site (depending on where the file is stored)
• Document Library = usually Documents
• File = workbook path
• Table = an actual Excel Table (Table1, Orders, etc.)

I've also seen cases where the test pane reports a failure even though the row is successfully created. If you need to read the latest row and then insert a new one, I'd recommend wrapping the logic inside an Agent Flow/Power Automate flow and exposing it as a single action to the agent. It tends to be more reliable than calling multiple Excel actions directly.

Hope that helps! 👍