πŸ“Š

Creating Editable Grids in PowerApps

Mar 15, 2025

PowerApps Editable Grid Experience

Introduction

  • Presented by Razza
  • Focus on creating an editable grid in Canvas PowerApps
  • Utilizes gallery control and modern input controls
  • Demonstration using a SharePoint list

Data Source

  • Uses a SharePoint list with various column types:
    • Text
    • Lookup
    • Multi Select Choice
    • Person
    • Single Select Choice

Steps to Create Editable Table

1. Insert Container Control

  • Provides a drop shadow effect

2. Insert Vertical Gallery

  • Set to expand full width and height of the container
  • Layout set to blank initially

3. Adding Controls to the Gallery

  • Text Control:
    • Insert modern text input control
    • Ensure modern controls and themes are enabled in app settings
    • Rename control to dxt work item
    • Connect item’s property to SharePoint list work tracker
    • Set value property to this item.title
  • Lookup Column:
    • Use modern drop-down control
    • Item property: choices from lookup column project
    • Default selected items set to this item.project
    • Rename to dropdown project
  • Multi Select Choice Column:
    • Insert modern combo box control
    • Item property: choices of category
    • Allow multiple selections
    • Rename to combo box category
    • Default selected items to this item.category
  • Person Type Column:
    • Use modern combo box
    • Items property: Office 365 users connector with search user V2
    • Default selected items to this item.assigned to, email field
    • Display name shown in fields
  • Single Select Choice Column:
    • Insert modern drop-down control
    • Items property: choices of progress column
    • Default selected items to this item.progress

4. Save Button

  • Insert modern button control
  • Logic to save data using patch function
  • Collects items in a collection call work items
  • Correct internal names of columns used for patching

Additional Features

  • New Item Creation:
    • Modern button control to add new items
    • Uses patch function with default values
    • Handles required fields like project
  • Sorting & Filtering:
    • Connected directly to data source
    • Filtering/Sorting logic can be applied
  • Bulk Actions:
    • Checkbox experience for multiple selections
    • Ability to delete or copy selected items

Conclusion

  • Demonstrated a complete modern grid experience in PowerApps
  • Encouragement to like, comment, and subscribe
  • Thank you for watching

Note

  • The video emphasizes simplicity and modern UI in PowerApps to create dynamic and user-friendly interfaces.