New Agent Experience - Adding Excel Tool

Hello,

Here are the documented values for the Excel Online (Business) connector in Copilot Studio (https://learn.microsoft.com/en-us/connectors/excelonlinebusiness/):

Location : me (user's OneDrive), a SharePoint site URL, users/UPN, or groups/groupId

Document Library : name of the document library (e.g. Documents)

File : path relative to the Drive (e.g. MyFile.xlsx or SubFolder/MyFile.xlsx)

Reading the last row : there's no native "get last row" action. If your table has a sortable column (date, ID), use List rows present in a table with $top=1 and $orderby.

Otherwise you'll need to retrieve all rows and take the last one note the default limit is 256 rows.

Use Add a row into a table (AddRowV2).

Regarding the failure in preview : the docs explicitly state that some capabilities from the classic experience are not yet available in the new agent experience, which may explain the inconsistent behavior you're seeing...