cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
RayC
Frequent Visitor

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

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?  

1 ACCEPTED SOLUTION

Accepted Solutions

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.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

View solution in original post

5 REPLIES 5
Pstork1
Dual Super User
Dual Super User

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.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
RayC
Frequent Visitor

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?  

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.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
RayC
Frequent Visitor

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.   

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



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Users online (1,139)