Skip to main content
Microsoft logo
Power Apps
    • AI Builder
    • Automate processes
    • Azure + Power Apps
    • Build apps
    • Connect data
    • Pages
    • Take a guided tour
  • Pricing
    • Overview
    • Become a Partner
    • Find a Partner
    • Find partner offers
    • Partner GTM Resources
    • Blog
    • Customer stories
    • Developer Plan
    • Documentation
    • For IT Leaders
    • Roadmap
    • Self-paced learning
    • Webinars
    • App development topics
    • Overview
    • Issues
    • Give feedback
    • Overview
    • Forums
    • Galleries
    • Submit ideas
    • User groups
    • Register
    • ·
    • Sign in
    • ·
    • Help
    Go To
    • Power Apps Community
    • Welcome to the Community!
    • News & Announcements
    • Get Help with Power Apps
    • Building Power Apps
    • Microsoft Dataverse
    • AI Builder
    • Power Apps Governance and Administering
    • Power Apps Pro Dev & ISV
    • Power Apps Portals
    • Connector Development
    • Power Query
    • GCC, GCCH, DoD - Federal App Makers (FAM)
    • Power Platform Integration - Better Together!
    • Power Platform Integrations
    • Power Platform and Dynamics 365 Integrations
    • Community Blog
    • Power Apps Community Blog
    • Galleries
    • Community Connections & How-To Videos
    • Community App Samples
    • Webinars and Video Gallery
    • Canvas Apps Components Samples
    • Kid Zone
    • Emergency Response Gallery
    • Events
    • 2021 MSBizAppsSummit Gallery
    • 2020 MSBizAppsSummit Gallery
    • 2019 MSBizAppsSummit Gallery
    • Community Engagement
    • Community Calls Conversations
    • Experimental
    • Error Handling
    • Power Apps Experimental Features
    • Community Support
    • Community Accounts & Registration
    • Using the Community
    • Community Feedback
    cancel
    Turn on suggestions
    Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
    Showing results for 
    Search instead for 
    Did you mean: 
    • Power Apps Community
    • Galleries
    • Community App Samples
    • Power Apps Editable Table (Excel like)

    Power Apps Editable Table (Excel like)

    12-08-2020 08:40 AM - last edited 12-08-2020 09:38 AM

    RezaDorrani
    Community Champion
    10153 Views
    LinkedIn LinkedIn Facebook Facebook Twitter Twitter
    RezaDorrani
    RezaDorrani Community Champion
    Community Champion
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    Power Apps Editable Table (Excel like)

    ‎12-08-2020 08:40 AM

     

    In this video, we will go through a step-by-step tutorial of creating an Excel like Editable table/grid.

    This is like the Quick Edit Mode in SharePoint lists/libraries or the Grid view in Dataverse for Teams or InfoPath repeating tables.

    We will use Power Apps Galleries to create the editable grid and live update our data source.

     

    Video covers the following:
    ✅ Style gallery to look like an editable grid
    ✅ Add a new row or record to the grid
    ✅ Record grid updates in a collection and patch all the changes with a single query (performance boost)
    ✅ Delete a row or record in the grid
    ✅ Put grid in view mode or edit mode
    ✅ Undo grid updates
    ✅ Auto-save grid updates using timer control

     

    Here's a link to download the sample solution:
    https://github.com/rdorrani/PowerApps/blob/master/EditableGrid_1_0_0_2.zip
    Solution includes Dataverse Tables, Choices column and the Power App.
    ***Please note: You need to import the zip file as a solution.***

     

    #PowerApps #EditableTables #EditbaleGrid #InlineEditing

     

    --------------------------------------------------------------------------------
    Thanks,
    Reza Dorrani, MVP
    YouTube
    Twitter

     

    EditableGrid_1_0_0_2.zip
    Labels:
    • Labels:
    • Data connections and mashups
    • Formulas and Controls
    • Galleries and Forms
    Message 1 of 6
    10,153 Views
    10 Kudos
    Reply
    • All forum topics
    • Previous Topic
    • Next Topic
    Samo2005
    Samo2005
    Frequent Visitor
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎01-12-2021 08:30 AM

    Hi Reza,

    I keep getting Something went wrong. Any idea?

     

    Thanks

    Wessam

    Samo2005_0-1610468997955.png

     

    Message 2 of 6
    9,083 Views
    0 Kudos
    Reply
    RezaDorrani
    RezaDorrani Community Champion
    Community Champion
    In response to Samo2005
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎01-12-2021 08:40 AM

    @Samo2005 import as a solution file please.

    Message 3 of 6
    9,080 Views
    0 Kudos
    Reply
    Samo2005
    Samo2005
    Frequent Visitor
    In response to RezaDorrani
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎01-12-2021 08:45 AM

    Thank you very much.

     

     

    Cheers

    W

    Message 4 of 6
    9,077 Views
    2 Kudos
    Reply
    Naresh2
    Naresh2
    New Member
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎02-21-2022 04:51 AM

    When Im Importing the Solution to Power apps Getting this error

    Naresh2_0-1645447687105.png

     

     

    Message 5 of 6
    3,497 Views
    0 Kudos
    Reply
    Taoridi
    Taoridi Advocate II
    Advocate II
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎11-15-2022 03:41 AM

    Nice app and very straightforward instructions, looking forward to trying it

    Message 6 of 6
    1,417 Views
    0 Kudos
    Reply

    Power Platform

    • Overview
    • Power BI
    • Power Apps
    • Power Pages
    • Power Automate
    • Power Virtual Agents

    Browse

    • Sample apps
    • Services

    Downloads

    • Windows
    • iOS
    • Android

    Learn

    • Documentation
    • Support
    • Community
    • Give feedback
    • Blog
    • Partners

    • © 2023 Microsoft
    • Follow Power Apps
    • Privacy & cookies
    • Manage cookies
    • Terms of use
    • Trademarks
    California Consumer Privacy Act (CCPA) Opt-Out Icon Your California Privacy Choices