Power Platform Community Forum Thread Details

I'm trying to set a dynamic value for the document library in Copilot Studio and then get a table from an Excel file stored in that library. When I set the document library as a dynamic value, it asks for "Identify as." I don't see an option for "Text." What should I choose? Also, I'm encountering a 400 error when trying to get the table action. Here are the steps I've taken:

- Set the location to https://weecopilot.sharepoint.com/sites/Sharepointsite

- Selected the document library "Documents"

- Chose the file "Copy of Copilot Test Data2.xlsx"

- Encountered a 400 error with the message: "The connector 'Excel Online (Business)' returned an HTTP error with code 400."

Any guidance on how to correctly set the dynamic value and resolve the error would be greatly appreciated!