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.