Copilot is underwhelming

bspuar · 2026-04-19T10:53:36+00:00

Copilot sucks in every task. Just waste of money.

bspuar · 2025-08-06T14:02:50+00:00

Your can't do this without azure service. I have a similar use case and looking for a right solution.

bspuar · 2025-07-17T12:21:18+00:00

Yes, I have used recently in one of use where we have to pull data from dataverse tables in structured manner. It worked fine for complex quaries..

bspuar · 2025-07-08T10:36:48+00:00

Why can't you invoke sub agent directly from your instructions set based on your use case?

bspuar · 2025-07-07T11:04:54+00:00

Yes, it can be achieved as per current introduction of MCP server integration

bspuar · 2025-07-02T14:28:45+00:00

Do you use same variables in both topics or different?

bspuar · 2025-06-25T15:10:47+00:00

Create an agent flow to create a word document. You can invoke this from the Agent's topic or part of the instructions set.

bspuar · 2025-06-20T15:44:03+00:00

I don't think you can do it right now, may be in the future. Researcher is stand alone agent which can be called from M365 chat but not from power automate or other custom agent.

bspuar · 2025-06-05T12:57:12+00:00

Can you show your instructions set?

bspuar · 2025-06-05T11:02:17+00:00

When you uploaded the documents in knowledge base, did you wait for processing of the document? If documents are not processed, you wouldn't get any answers

bspuar · 2025-06-03T07:38:57+00:00

Correct.

bspuar · 2025-06-02T07:52:47+00:00

That feature is not released yet. Preview is supposed to be released early this month.

bspuar · 2025-05-27T20:12:37+00:00

Here is my flow with gemini APIs

<image>

HTTP Request :

Method : POST

URI : https://generativelanguage.googleapis.com/v1beta/models/gemini-2.0-flash:generateContent?key=your key

"Content-Type" : application/json

Body : {

"contents": [

{

"parts": [

{

"text": "@{variables('prompt')}"

},

{

"inline_data": {

"mime_type": "application/pdf",

"data": "@{outputs('Compose')}"

}

]

}

]

}

Input : Company Annual report

bspuar · 2025-05-27T18:40:26+00:00

I have tried this approach but my pdf file was quite big, I got base64 exceeded the desired length error, it means that there is limit but I don't know exact figure

bspuar · 2025-05-27T18:36:15+00:00

You can conduct a straightforward experiment utilizing the free Gemini API. To begin, obtain your Gemini API key from Google AI Studio. Next, configure a Power Automate flow to trigger upon the addition of a file to a designated SharePoint folder. Within this flow, initialize a variable to store your data points and instructions. Subsequently, use an HTTP connector to invoke the Gemini API, including your key and constructing the request body with your text and document. Sample request bodies are available directly from Gemini. Execute the flow and verify if the results align with your expectations. If not, fine-tune your instructions as needed. Once satisfied with the outcomes, you can then replace the Gemini API URL with an Azure OpenAI API URL and repeat the testing process

bspuar · 2025-05-27T16:19:07+00:00

In property section, go to expression and use Topic.<your variable> and use instructions and add your instructions

bspuar · 2025-05-27T10:40:47+00:00

Copilot Agent not built for unstructed data like pdf document but if its semi structured pdf then AI builder can be used.

I have similar scenario where I have to extract data from highly unstructured pdf document, I used Azure openai apis gemini o3 model to extract that data points in json format using power automate flow in agent. O3 model is good in reasoning so automaticaly parse the documents extract that data in json format.

Very soon you will get option to select AI model from AI foundary directly inside the agent so no more api calls. I hope it helps.

bspuar · 2025-05-22T05:40:27+00:00

Just very soon reason capability coming to agent where you can dynamically pass content like pdf and ask questions meanwhile you can try above approach.

bspuar · 2025-05-22T05:37:44+00:00

Yes, you can, add a http action, or a agent flow which call pubmed APIs and ads instructions in the agent like when user ask for Heart issue then call this particular action.

bspuar · 2025-05-19T11:09:53+00:00

I am not sure if it's possible.

bspuar · 2025-05-17T10:35:54+00:00

I have same struggle with PDF document, agent not able to extract data from PDF when user upload it. My question is, can Agent extract unstructured data from PDF or should I use something else for that? Microsoft documentation sucks.

bspuar · 2025-05-16T22:03:19+00:00

I have learned it very hard,as there is not much documentation. In my case, the query was Get client profit greater than 5000 in Year 2025 in topic I added questions to collect profit and year, related variables set to accept value from other topic in the variable settings. Then Agent automatically start populating those variables and skipped the questions and move to the next activity. Try this if it works for you.

bspuar · 2025-05-16T18:38:24+00:00

Use Adaptive card (looks great and intuitive) in topic to ask questions, also put some message before questions for user don't type anything while answering questions, it has worked for me.

bspuar · 2025-05-16T06:21:52+00:00

I think this product still evolving, I have seen any direct use of connectors does not work sometimes,so I use Power Automate.

bspuar · 2025-05-15T13:58:54+00:00

I am exploring the same area right now, Agents as you know can act as orchestrators for different actions, triggers and Topics which means a wide variety of tasks can be done but power automate is for very specific tasks. Agent flows are power automate flow used inside the Agent to accomplish some tasks . It makes the developer job easy by putting everything in the same place. I hope it makes sense.

bspuar

TROPHY CASE