Skip to main content

Notifications

Community site session details

Community site session details

Session Id : NRh33fY/kDh9r4N9sOIVeV
Power Apps - AI Builder
Unanswered

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

Like (1) ShareShare
ReportReport
Posted on 31 Aug 2024 05:19:21 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:
  • Suggested answer
    Tjan Profile Picture
    1,087 Super User 2025 Season 1 on 03 Sep 2024 at 08:33:04
    Building a Chat Bot for Insights in Power Apps (specifically, a Canvas App)?
    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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

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

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Apps - AI Builder

Overall leaderboard