Its unfortunately very hard to diagnose a copilot issue with just that description.
I am not sure what you mean you cannot retrieve information from SharePoint (in what way, lists, files?)
Please outline your Bot, the instructions you are using, the DataSources, the Settings you are using for Gen AI, Public websites, you name it. what channels are you posting it to (Teams/M365?), what is your authentication set too?
If you look in the Activities tab in the designer what is it doing or not doing.
Please give a really solid example of:
-in my SQL Table, I have a field called Blue and it contains a simple true false, it also has an ID number for an order, and when I ask if my order is Blue or not, it says, Go jump in a lake, or has no answer.
So we can figure out via the Activities tab and your configuration what it thinks its supposed to do, versus what its trying.
Are you using Topics, Tools, in your instructions are you telling it what sources to use for specific questions?
Happy to help but need more information as beyond that its not enough to understand as you also forgo to give an example of what you asked it and what it said or didn' say.
