web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Copilot Studio - Copilot Studio Skills Development / Dataverse knowledge so...
Copilot Studio - Copilot Studio Skills Development
Unanswered

Dataverse knowledge source - lookup colums

(2) ShareShare
ReportReport
Posted on by MR-10091350-0 48

Hi everyone,

I would like to ask if anyone has experience using Dataverse as a knowledge source in Copilot Studio. I find that when I search in all columns except lookup, it works fine, but it is unable to identify my data in a lookup column, even though I have added the table that is referenced in the lookup to my knowledge source.


I have ensured that my views, Dataverse index, and Quick Find search fields are set up correctly.

I hope someone can help, thank you in advance.

Categories:
Extensibility
I have the same question (0)
  • Suggested answer
    Vinoth Selvam Profile Picture
    Vinoth Selvam 1,565 Super User 2025 Season 2 on at
    Dataverse knowledge source - lookup colums
     
    There are some limitations when using Dataverse Knowledge source directly.

    Anyhow you still have workaround to achieve it. More than using the knowledge source directly here, we tried using Custom Prompt with AI builder and connect to dataverse tables. By which we will be able to modify the responses to a larger extent.
     
    Below is the Post that you can refer .
     
     
     
     
    Kindly try this approach and provide your suggestions on how it works.
     
    Thanks.
  • Suggested answer
    SaiRT14 Profile Picture
    SaiRT14 1,988 Super User 2025 Season 2 on at
    Dataverse knowledge source - lookup colums
    1. Add both the lookup column and the related table (the table being looked up) are included in the knowledge source.
    2. create calculated or virtual fields that bring over values from related tables into the main table so that Copilot can directly access them without having to traverse relationships.
     
  • ZA-01102209-0 Profile Picture
    ZA-01102209-0 4 on at
    Dataverse knowledge source - lookup colums
    I am member of dataverse, but I didnt even think of using it as  source.Could it be being governed or censored by your company?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Our Community Code of Conduct has been updated!
Responsible AI policies for the Community

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

MS.Ragavendar – Community Spotlight

We are honored to recognize Ragavendar Swaminatha Subramanian as our September…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Copilot Studio

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 410 Super User 2025 Season 2

#2
trice602 Profile Picture

trice602 146 Super User 2025 Season 2

#3
Romain The Low-Code Bearded Bear Profile Picture

Romain The Low-Code... 137 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Welcome to the Copilot Skills Development Forum (Please Read First)

Product updates

Microsoft Power Platform Community release plans