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!


Report
All responses (
Answers (