Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Copilot Studio - General
Answered

Has anyone wired up the PVA to the Dataverse core Product entity?

(0) ShareShare
ReportReport
Posted on by

I want to use a Bot to answer questions about some product families and units within the Product Catalog.   What are some of the different approaches to enable that?  

Categories:
  • Pstork1 Profile Picture
    66,477 Most Valuable Professional on at
    Re: Has anyone wired up the PVA to the Dataverse core Product entity?

    To the best of my knowledge this constraint has not changed. You will still need to use Power Automate to access data stored in Dataverse

  • Community Power Platform Member Profile Picture
    on at
    Re: Has anyone wired up the PVA to the Dataverse core Product entity?

    hello and happy new year (Belated).   Has this contraint changed with the latest wave up updates?   The use case that I am looking for is the same.   The goal is to be able to use Flow or Native PVA to get a collection of variables (attributes as variants) from the Data Verse product catalog.   

  • Verified answer
    Pstork1 Profile Picture
    66,477 Most Valuable Professional on at
    Re: Has anyone wired up the PVA to the Dataverse core Product entity?

    Yes, you cannot build a dynamic list of products and PVA bots don't have a way to directly reference Dataverse entities.  But you can access Dataverse entities by calling a Power Automate flow from a PVA bot.  So here is what I think you can do.

    1) Have a topic with keywords like "I would like information on a product".

    2) Have the bot then ask a question. What Product?

    3) Pass the answer from #2 to a Power Automate flow and use that to look up details about that product. 

    4) Have the flow format the results of the query and pass it back to the BOT

    5) Have the Bot display the result.

     

    I hope that clarifies.

  • Community Power Platform Member Profile Picture
    on at
    Re: Has anyone wired up the PVA to the Dataverse core Product entity?

    Thank you.  That is unfortunately what I discovered last night.   Topics and Entities do not accomplish what I want to do.  What I was really hoping for was that I could simply pull data directly from a "Dataverse Entity".   So my hope was that I could simply reference the Product table in Dataverse (Or D365 Products) and access PRICE LIST and QUANITY.  Also Product attributes like variant (Small, Medium and Large and quantity on hand.   

     

    So here is an affirmation of what you are saying:

    1.  That I cannot build a dynamics list of topics AND I cannot directly access the CE D365 Entity for Product (??? is that the case)

    2. That I can build the product family into topics or as optional variables

    3. That I can used those variables to query the Dataverse Product table via Power Automate

    4. That Power Automate then can use the query results to supply text values back the option variables

     

    Am I understanding this correctly?  

  • Pstork1 Profile Picture
    66,477 Most Valuable Professional on at
    Re: Has anyone wired up the PVA to the Dataverse core Product entity?

    I think you'll need to build topics around the product families since there is no way to do dynamic topics in PVA yet.  Then use a Power Automate flow to retrieve the content from Dataverse and format it for display in the bot.

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

Quick Links

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Leaderboard > Copilot Studio - General

#1
Romain The Low-Code Bearded Bear Profile Picture

Romain The Low-Code... 76

#2
Pablo Roldan Profile Picture

Pablo Roldan 61

#3
stampcoin Profile Picture

stampcoin 10

Overall leaderboard