New Agent Experience - Adding Excel Tool

Hello everyone,

I want an agent in the new Copilot Studio experience to read the latest row from an Excel table and then append a new row.

Has anyone successfully configured the Excel Online (Business) tools dynamically in the new Copilot Studio experience? Which values should be passed for Location, Document Library/Drive, and File, etc.?

In preview, the agent fails but when I prompt it, it ends up adding the row. If anyone could also guide me to resources to learn about how to configure tools in the new experience, I would even be more grateful.

Thank you !