Editable Grid feature in Model-driven apps with Power Apps grid control

  • Infinite scrolling: Users no longer need to navigate through pages to see more records. With infinite scroll, users can keep scrolling to their desired record.
  • Inline editing within views and subgrids: As the name suggests, using this control gives user the ability to edit the records directly from the view.
  • Click on the gear icon at the top right -> Select Advanced Settings.
  • Then go to Settings -> Customizations
  • Next click on Customize the System
  • Now go to Components -> Entities -> Select Account-> Controls tab.
  • Now click on Add Control -> Select Power Apps gridcontrol -> Click on Add.
  • Now enable it for Web, Phone, and Tablet.
  • Add Lookup — This property detects the lookup fields available in the view for the entity on which the control has been configured and then allows us to select a view on which the lookup will get filtered. This can be applied for multiple lookup fields present in the view for the entity on which the control has been configured.
  • Select Add Lookup, which opens the Configure Property “Add Lookup”dialog box.
  • In the Available Views, select the view of the parent entity (which is Account in our case) having a lookup column pointing to a child entity (which is Contact in our case).
  • In Available Columns, select the lookup column to add (for example — Primary Contact).
  • In Default View, select the data source for the lookup field.
  • You can further add filter to the records displayed in the lookup by enabling the checkbox ‘Only show records where’.
  • Once everything is set up, click on OK button.
  • Enable Editing — This is a Boolean property to either make the grid editable or not. If set to Yes, the records in the grid can be edited inline itself.
  • Enable or disable filtering in the grid — The purpose of this property is to enable or disable filtering in the grid.
  • Navigation types allowed — This property comes with 2 options i.e. All, Primary only. If Primary Only is selected then the grid allows the provision of navigating to a record on the primary field of the parent entity. So as per our scenario, the navigation is allowed only on the Account Name field and not on any of the lookup fields.
  • Reflow Behavior:
  • Reflow behavior — Reflow
  • Reflow behavior — Grid Only
  • Reflow behavior — List Only

Conclusion:

Thus, you can how this new feature gives a new way to visualize CRM data while at the same time easing the process of editing and navigating to records which will further save your time.

--

--

Love podcasts or audiobooks? Learn on the go with our new app.

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store