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
Pstork1
Dual Super User
Dual Super User

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.

Join me at 365 and PWR EduCon in Chicago
EduCon Chicago 2022

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.

Join me at 365 and PWR EduCon in Chicago
EduCon Chicago 2022

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?  

Pstork1
Dual Super User
Dual Super User

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.

Join me at 365 and PWR EduCon in Chicago
EduCon Chicago 2022

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.   

Pstork1
Dual Super User
Dual Super User

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.

Join me at 365 and PWR EduCon in Chicago
EduCon Chicago 2022

Helpful resources

Announcements
Register for a free PVA chatbot creation workshop

Register for a free PVA chatbot creation workshop

Learn how to respond rapidly to your customers and employees at scale, using intelligent conversational chatbots.

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (4,609)