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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Building a Chat Bot fo...
Power Apps
Suggested Answer

Building a Chat Bot for Insights in Power Apps (specifically, a Canvas App)?

(1) ShareShare
ReportReport
Posted on by 124

Hi fellow experts!

I’m currently working on an exciting project at our startup, where we’re developing a leadership app using Power Apps (specifically, a Canvas App). Our data source of choice is Dataverse, which provides a robust foundation for our app. However, we recently hit a roadblock while trying to incorporate AI-driven insights into our solution.

Our initial approach involved experimenting with AI Builder, Microsoft’s tool for creating machine learning models within the Power Platform. Unfortunately, we quickly discovered that AI Builder has some limitations:

  1. AI Builder restricts us to using only one table for model training. This posed a significant challenge because our app relies on multiple critical tables.
  2. Even when working with just one table, the performance of our AI models wasn’t up to par. We needed a more robust solution.

To get an understanding of what we want to achieve, Imagine this scenario: A user interacts with our app’s chat bot and asks, “What were the top 10 selling cars at Dealership XYZ last month, and who were the customers that purchased them?” Achieving this requires combining data from multiple tables (Car Brand, Dealership, and Customer).

The reason I want to use the AI Builder is to create new records in Dataverse table depending on the response. For example I want to take the list of top 10 selling cars and create an approval to increase the inventory for dealership by pressing a button. And this all needs to happen within the app.

Categories:
I have the same question (0)
  • Suggested answer
    TYL Profile Picture
    1,091 Super User 2024 Season 2 on at
    From what I read, I think Copilot Studio would be a much better solution for your use-case. It can do exactly what you want, but almost natively. For instance, you can easily connect it to different datasource tables (as 'knowledge sources'). Afterwards you can use actions (or Power Automate flows) to create new records in Dataverse. 
     
    PowerApps has actually no real use-case in your scenario since you are only interested in the chatbot part. And that's exactly what Copilot Studio is good for! it might be worth it for you to look into Copilot Studio.

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 711 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 319 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard