Unanswered

Best way to build a canvas app with a javascript datagrid

(0) Share

Report

Posted on by Tooor

Hi everyone,

I'm going to build a simple CRM kind of application. I want to use PowerApps because I believe it's a way for our company to speed up development. I should probably make a canvas app, as it seems to give the most flexibility.

On the front screen of the app, I need to have a high performance datagrid, like ag-grid. It will populate >10,000 rows when the app loads. I was thinking of wrapping it in a PCF component, but I don't have any PCF experience (yet). All my data will be in an SQL Server database, not Dataverse.

Do you have any advice for me as I start to research this?

I guess my first questions would be:

* Is this possible?
* Would the grid stay in memory as the user jumps to another screen, and then back to the front screen? Or does it have to reload.
* Should I load the grid data through PowerApps or is it possible for the PCF component to consume another API. (The reason for using PowerApps is that I want to build many quick screens. But I suspect it's not ideal for loading much data fast.)

Thanks a lot for your advice!

Categories:

Power Apps component framework

All responses (2)

Answers (0)

Tooor 2 on at

Like (0)

Report

Re: Best way to build a canvas app with a javascript datagrid

Thanks a lot, aroudaki! Very good reading. I've also found the canvas based grid sample component, so I have something to start with!
aroudaki Microsoft Employee on at

Like (1)

Report

Re: Best way to build a canvas app with a javascript datagrid

Here are some best practices to build PCF controls
Best practices for code components - Power Apps | Microsoft Docs
Develop 1 Limited Blog | SalesSpark and the Power Apps Component Framework!

Here is some docs on creating a PCF Grid control using Fluent UI Detail List component
It should be pretty similar pattern if you want to use ag-grid
Create a model-driven app dataset component in Microsoft Dataverse - Power Apps | Microsoft Docs

you can also find lots of useful tutorials on youtube