Power Apps grid control feedback

[jasongre]

The new Power Apps grid control in model-driven apps is officially in public preview! This control can be used for both read-only and editable scenarios, supports infinite scrolling for a modern browsing experience, and allows pro-dev makers to customize the appearance of cells. A new blog post and documentation for this should be available soon! 

As you try out and use this new grid control, we'd love to hear your feedback! What went well and what didn't? What additional features do you want or need from the grid? This community post will be used to consolidate feedback on the Power Apps grid control. Thanks in advance for your comments! 

[jasongre]

@sofiang Are you trying to edit the values in the designer? The visual of the grid suggest it is in edit mode (the vertical and horizontal lines between rows and columns). Can you edit those fields in a form?  

[jasongre]

@ThomasRathCGIDK Thanks for reporting this (and apologies for not responding sooner). We are actively looking into this. 

[jasongre]

@eugacc with the cell customizer, you should have full control over the behavior of the cell. Your particular scenario of opening a side panel instead of navigating away from the grid is a scenario we are looking to support OOB without needing any customized cells.  

With regards to the filtering issue, can you provide a specific use case that isn't working (including which filter mechanism you are attempting)? Thanks! 

[jasongre]

Thanks for the feedback, @devlinl. We are looking into this. My apologies for not responding sooner to your message. 

[jasongre]

@bgad We are still working on cleaning up some items for the grid and will GA the grid after that is complete. 

[jasongre]

Hey @MichelH my apologies for not responding sooner. I do not believe sufficient APIs exist for Excel to allow it to be used as a replacement for the product grid. You can copy data from Excel into the Power Apps grid, however. 

[jasongre]

Hey @MattVizor my apologies for not responding sooner. Would the nested grid feature solve your issue, since both the parent and nested grid could be editable and would not require you to click into any individual record to make updates? 

[jasongre]

Thanks for your feedback @DKassian I assume you do not have the same issue with the lookup control (in forms) since you can select the view with the required fields to differentiate records? 

[jasongre]

@Schera can you provide specific repro steps so that we can take a look? Thanks for reporting this! 

[eugacc]

That would be really nice, and ideally to have open side panel only on primary entity link click and still able editing rest of grid directly inline. Then Most quick edits can be done directly in grid in "Excel" style and detailed updates in a side panel in form. Additionally, with infinite scrolling option ON, if you navigate away from grid then you go back to beginning, loosing scrolled positon, which is quite annoying for users to scroll back and find requred line again, as they work line by line to process orders.

For filtering, it seems that issue related to Grid filter option scenario. After switching to Quick find behavior in Environment settings (Option "Use quick find view of an entity for searching on grids and sub-grids" is ON) 

Quick find works fine. Switching OFF to grid filter not working correctly. 

if I had JumpBar ON we had issue where after scrolling down will jump up again for some reason. After swithcing settings as Jump Bar in "Auto" it seems helped, no more jumps.

As you can see per attached screenshot, most often I would have * (star) in View name, which normally indicating that view is customized and required to save. And eventually after switching different views I would get blank screen, as per second screen attached, (despite number of records in that view). Refresh whole page will show all records again and without star sign. Possibly its related to saving Filter configuration issue. I go Edit Filter, change condition, hit Apply, grid refresh bot nothing changed. Go back to Edit filter, its same settings as before, not updated. 

I can share screen recording of summary issues with grid behavior.