Forum Discussion
MicrosoftExcel Connector Issue in Copilot Studio for Agent using SharePoint as Knowledge Source
I have the same issue while trying to add Excel connectors to my Copilot Agent. It's really frustrating.
- If i don't use static value, AI cannot fill them correctly
- If i use static value, it doesn't work and keep returning 400 404 error
I really need a video instruction from Microsoft team but can't find them anywhere (youtube, microsoft community).
This is why I prefer using other easier Agent apps like Make, n8n which make what Copilot Agent took 3-4 hours of my time to setup (but failed) turns to 20 minutes or less. The only reason why I'm still trying this is due to company data policies. But please Microsoft! I'm begging for more video instructions, examples, not just text.
Sorry for the rant, this problem has been haunting me nearly 6 to 8 hours without success.
Hope a clear solution is given.
MicrosoftHere is a YouTube video which helped! - Using Structured Data with Copilot Studio using Excel as an Example.
Thanks a ton MarianneCherayil​!
I'm so grateful he posted this video. Really useful and easy to follow. I managed to make the Excel connector work as expected.