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!
