Skip to main content
Microsoft logo
Power Apps
    • AI Builder
    • Automate processes
    • Azure + Power Apps
    • Build apps
    • Connect data
    • Pages
  • 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
    • Webinars and Video Gallery
    • Responsive Editable Grid in Power Apps from ShareP...

    Responsive Editable Grid in Power Apps from SharePoint List

    09-14-2021 06:26 AM

    Dual Super User RezaDorrani
    Dual Super User
    852 Views
    LinkedIn LinkedIn Facebook Facebook Twitter Twitter
    RezaDorrani
    Dual Super User RezaDorrani
    Dual Super User
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    Responsive Editable Grid in Power Apps from SharePoint List

    ‎09-14-2021 06:26 AM

    Hello,

     

    This video is a Step-by-step tutorial on building Responsive Editable Grid in Power Apps from SharePoint List.
    Topics covered:
    ✅ 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
    ✅ Grid validations
    ✅ Put grid in view mode or edit mode
    ✅ Filter Grid / Gallery data
    ✅ Horizontal Scroll
    ✅ Freeze Pane
    ✅ Undo grid updates

    #PowerPlatform #SharePoint #PowerApps #EditableGrid


    Thanks,
    Reza Dorrani, MVP
    YouTube
    Twitter

    watch?v=wI6SHGQ9ATg

    Labels:
    • Labels:
    • Community Tips & Tricks
    • Connector Series
    • Design Matters UX Tips
    • Friday Function Series
    • General PowerApps
    • PowerApps Hacks
    • SharePoint Magic
    Message 1 of 4
    852 Views
    1 Kudo
    Reply
    • All forum topics
    • Previous Topic
    • Next Topic
    EOS
    EOS
    Frequent Visitor
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎08-08-2022 11:06 AM

    Just removing my post as I got the solution in the open forum. Thanks again for your suggestion to post my query on community platform.

    Message 2 of 4
    261 Views
    0 Kudos
    Reply
    GregMc
    GregMc Advocate I
    Advocate I
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎11-07-2022 08:37 AM

    Reza, per your response on the YouTube video, I am reposting the information here with Screen shots.

    The process I am trying to setup is for a prototype overview. I wish to be able to edit an item either in Grid View or on a form (user will choose one or both) but right now I am just concerned with writing my changes back in order to complete the prototype for the grid view.

    Here are the details:

    1. All my data loads into the grid as expected (uses filter to determine unprocessed items and a correct value of 4 items are returned) based on the SharePoint data:
       
      GregMc_1-1667837537864.png

       

    2. Edit Grid mode is correctly loaded showing the above items as seen in SharePoint (this is displaying a grid called colGridData):
      GregMc_2-1667837698519.png

       

    3. The user then adds some basic text into the Reason Parked field to express next steps for the assigned workers (workers determined by a separate schedule and not a concern for this demo):
      GregMc_3-1667837813503.png

       

    4. user clicks on Exit Grid view. The Grid View button updates the text, screen visibly not in edit mode, the Load Data button flashes, and the screen shows no updates:
      GregMc_5-1667838132986.png

       

    5. Assumptions based on the evidence:
      1. Load Data button works when screen loads:
        ClearCollect(colGridData, Sort(Sort(Filter('Processed Ship Alerts','Business Process Completed'=false),Created,Descending),Group.Value,Ascending))
      2. Grid view appears and seems correct:
        GregMc_6-1667838287146.png

         

      3. pushing the Load Data button does reload the SharePoint data correctly in the grid, anytime it is selected.
      4. Reloading the page either shows a cache or actually reloads the data but it is still unchanged
    6. Here is the process of the Updates:
      1. There are 4 fields that a user can update: Bus proc Cmplt, Group, Reason Parked and .Vendor. Each of the OnChange actions perform the Select(Parent) choice:
        GregMc_7-1667838639112.png

         

      2. The galleryGrid is the Parent and contains, in the OnSelect option GregMc_8-1667838734010.png

         

      3. The Exit Grid View then performs the love of the data to SharePoint:
        GregMc_9-1667838826833.png

    I hope this provides enough detail. It seems straight forward, and I am sure I have just blindly missed an important step or setting. Please advise.

     

    Thanks,

    Greg

    Message 3 of 4
    158 Views
    0 Kudos
    Reply
    GregMc
    GregMc Advocate I
    Advocate I
    In response to GregMc
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎11-09-2022 08:36 AM

    Problem resolved. The If for the editGridView button was backwards. Once the button was correctly tested the reults were written.

    Message 4 of 4
    144 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