web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Copilot Studio / Setting Dynamic Values...
Copilot Studio
Unanswered

Setting Dynamic Values for Document Library and Getting a Table in Copilot Studio

(0) ShareShare
ReportReport
Posted on by
 

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!

Screenshot 2025-0...

Your file is currently under scan for potential threats. Please wait while we review it for any viruses or malicious content.

I have the same question (0)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Copilot Studio

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 251 Super User 2025 Season 2

#2
Romain The Low-Code Bearded Bear Profile Picture

Romain The Low-Code... 201 Super User 2025 Season 2

#3
S-Venkadesh Profile Picture

S-Venkadesh 93 Moderator

Last 30 days Overall leaderboard