CoPilot Agents - Word Tables

Hi,

We have been trying to create a CoPilot agent within the business that can read data in a referenced folder within SharePoint and output a summary. Now the prompt I'm using works perfectly when using the "Researcher" agent within CoPilot, but when I use it in the agent the output is very different.

For added context. I have made a SharePoint site which has a folder for each project and then all the docs relating to that project within. The user says to the agent, "give me a project overview for QXXXX", what should happen is, the agent finds that folder, which it's seemingly doing and it provides all the info in the layout I've mentioned in the prompt. So it can find the right folder, and it gives a good overview of the project. But any information that's within a table in word, it doesn't retrieve, I've even told it what document has the content in the table it should be bringing back and it says it can't read tables in Word. When I've researched this it seems to be the way CoPilot interprets the data is different depending whether you upload the file or just reference it like my agent is doing.

Then in Researcher alternatively, I copy and paste the prompt into the text box, attach cloud files and select the project folder and the output is perfect. It retrieves all the content, dates etc and it's exactly what we need.

My aim was to make an agent that can do the same but doesn't require the user to attach the folder, they can just give it the project number and it does it's thing.

I'm still pretty new to agents, and appreciate it's still slightly new, but it doesn't feel like it should be doing that.

Would anyone with some expertise in agents be able to assist in me fixing this? And if possible, be available via email for me to ask some further questions?

Happy to provide any further information if needed.

Thanks