Hello,
I may have found a solution regarding file generation, but it required a lot of testing.
I created an agent in Copilot Studio to retrieve data from an Excel file which I manually load in the chat and generate a new file with a specific format using the data from the original file.
I encountered many issues with Copilot Studio, and below is what works and how:
- You need short but precise instructions. Long instructions may cause timeouts with all the thing Copilot studio has to process
- You need to have Code Interpreter enabled in the parameters
- You need to use GPT‑5 as the model
- Your input file must be clean, or at least contain one sheet with no specific formatting
- Your input file must be a CSV file. The Code Interpreter requires a CSV file. With an XLSX file, it may do “something”, but there is no actual output—even if the agent says the file has been transformed. The generated code simply does nothing
- AI Builder works in a similar way, but it requires more technical steps (Power Automate, variables), and all of this also consumes credits
I did not test the agent once published to Teams. The behavior may be different and would probably require some adjustments...
These are all my tests and recommendations that finally allowed my agent to transform the file. It need some upgrade to avoid new issues
It is very frustrating because it worked well with an XLSX file last week, and then it suddenly stopped working for no clear reason, so I had to adapt my agent.
Hope it will help some of you