Why Won't My Copilot Studio Agent Work Like ChatGPT? - Video

Microsoft Excel Tutorial: Why Won't My Copilot Studio Agent Work Like ChatGPT?

In this episode, we dive into the challenges and victories of integrating custom GPTs from ChatGPT into Microsoft Copilot Studio. Bill shares his progress on building an agent that formats YouTube captions into sentence-broken text with correctly capitalized Excel functions. While the GPT works flawlessly in ChatGPT, replicating the experience in Copilot Studio is a work in progress.

This video is Bill sharing imperfect, in-progress insight that I am still wrestling with. With the integration into the Word Copilot chat pane, then Copilot custom agents should win. I feel like I am so close. Does anyone have ideas of how to bring this project home?

Special highlights include the differences between ChatGPT custom GPTs and Copilot Studio agents, the mystery behind file uploads, agent provisioning delays, and the ongoing friction in pushing processed text back into Word. Bill walks through his trial-and-error process, including key moments where things suddenly start working—and where they still don’t.

The video touches on related tools like Markdown (.md) and .txt file handling in Microsoft environments, using SharePoint vs. OneDrive, and strategies for speeding up your AI-powered workflow. These are crucial considerations for anyone building custom solutions in Microsoft Copilot Studio.

If you have any answers or insights into these quirks, drop a comment below! Don’t forget to like, subscribe, and ring that bell for more deep dives and practical Excel (and now Copilot) tips from MrExcel.

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

Table of Contents
(0:00) Wrestling with Copilot Studio vs ChatGPT GPTs
(0:37) Recap of Previous Video and GPT Workflow
(1:01) Building a Caption Formatter GPT in ChatGPT
(1:31) Missing File Upload Features in Copilot
(1:53) Testing the Agent in Word with Mixed Results
(2:40) Success and Confusion with Agent Performance
(3:00) Insert button does not insert into Word document
(3:22) Open Questions and Call for Community Help
(3:40) Problems with .md vs .txt Files and Upload Paths
(3:57) Insert Function in Word Not Working
(4:03) New agent works in Studio, but not in Word
(4:20) Final Thoughts


#ChatGPT #CopilotStudio #Microsoft365 #CustomGPT #AIWorkflow #RevCaptions #ExcelTips #MrExcel #ProductivityTools #GPTAgent

This video answers these common questions:
How do I create a custom GPT in ChatGPT?
Why doesn't my Copilot Studio agent work right away?
How can I reformat YouTube captions using AI?
Why can't I upload Markdown files to Copilot Studio?
What are the differences between ChatGPT GPTs and Copilot agents?
How long does it take for a Copilot agent to become active?
Why won’t the Insert button work in Copilot with Word?
Can I use SharePoint to upload files to Copilot Studio?
Is there a way to automate YouTube caption formatting in Word?
What limitations does Copilot Studio have compared to ChatGPT?