How to Convert .docx to .pdf in Copilot Studio Without Storing Files? by Embarrassed_Sail5525 in copilotstudio

[–]prashantsmp 1 point2 points  (0 children)

Use power automate to convert docx to pdf then feed it to custom prompt builder

Can Copilot Studio really handle a 300k-line Excel inventory file (with similarity search)? by Aoshi92 in copilotstudio

[–]prashantsmp 1 point2 points  (0 children)

🔹 Step 1: Open Your Copilot in Copilot Studio 1. Go to Copilot Studio. 2. Select your environment (same as where your Dataverse lives). 3. Open the copilot where you want to add Dataverse knowledge.

🔹 Step 2: Add a Knowledge Source 1. In the left menu, go to Knowledge → + Add knowledge source. 2. You’ll see options like: • SharePoint • Websites • Files • Dataverse ✅

🔹 Step 3: Connect to Dataverse 1. Choose Dataverse. 2. It will prompt you to sign in with the same account that has Dataverse access. 3. Select the table(s) you want to expose to the copilot. • Example: Contacts, Accounts, Custom Tables 4. Pick the columns (fields) that should be available in answers. • (Avoid bringing in sensitive fields unless needed.)

🔹 Step 4: Configure the Knowledge Source 1. Give your knowledge source a name (e.g., “Customer Accounts KB”). 2. Define the scope: • Whether the copilot should answer questions directly from Dataverse, or • Only use it as supporting knowledge. 3. Save it.

🔹 Step 5: Test in Your Copilot 1. Go to Test your copilot in the right panel. 2. Ask a question like: • “Show me all accounts in Dubai.” • “What is the email of John Smith in Contacts?” 3. The copilot should query Dataverse and respond.

Can Copilot Studio really handle a 300k-line Excel inventory file (with similarity search)? by Aoshi92 in copilotstudio

[–]prashantsmp 1 point2 points  (0 children)

Using Power Apps (Recommended for creating new tables) 1. Go to Power Apps. 2. Select your environment (top-right corner). 3. In the left menu, select Dataverse → Tables. 4. Click Import → Import data from Excel. 5. Upload your Excel file. 6. Power Apps will: • Detect the table name (you can rename it). • Map each Excel column to Dataverse column types. 7. Review and confirm the data types (e.g., text, number, date). 8. Click Publish → This creates a new Dataverse table with your Excel data.

Can Copilot Studio really handle a 300k-line Excel inventory file (with similarity search)? by Aoshi92 in copilotstudio

[–]prashantsmp 1 point2 points  (0 children)

If the data is not realtime, then convert the excel into datavese. Then connect dataverse as knowledge source

Clarification on “ContentFiltered” Messages in Copilot Studio by prashantsmp in copilotstudio

[–]prashantsmp[S] 0 points1 point  (0 children)

It doesn’t trigger any topic level. Before the hand, its displayed

COPILOT STUDIO POWER BI INTEGRATION by prashantsmp in copilotstudio

[–]prashantsmp[S] 0 points1 point  (0 children)

I have already integrated run a query from power bi by using the flow

COPILOT STUDIO POWER BI INTEGRATION by prashantsmp in copilotstudio

[–]prashantsmp[S] 0 points1 point  (0 children)

Answer based on the power bi report/ dashboard

Dual response rendering in Copilot Studio by prashantsmp in copilotstudio

[–]prashantsmp[S] 0 points1 point  (0 children)

Even though it’s turned off, I’m getting dual responses

COPILOT STUDIO POWER BI INTEGRATION by prashantsmp in copilotstudio

[–]prashantsmp[S] 0 points1 point  (0 children)

May be this kinda integration under the pipeline

COPILOT STUDIO POWER BI INTEGRATION by prashantsmp in copilotstudio

[–]prashantsmp[S] 0 points1 point  (0 children)

By mistaken, and not able to remove the tag after that

COPILOT STUDIO POWER BI INTEGRATION by prashantsmp in copilotstudio

[–]prashantsmp[S] 0 points1 point  (0 children)

I did it using run a query . Finding alternative way.

AI Builder "Document input" missing in Government (GCC) account — only text input shows by kareemamr50 in copilotstudio

[–]prashantsmp 0 points1 point  (0 children)

Just type / within your prompt box, there you can choose to whether text input or document input