Skip to main content

Notifications

Community site session details
Power Apps - Building Power Apps
Answered

Turn Off Child Grid on Power Apps Grid Control

Like (1) ShareShare
ReportReport
Posted on 7 Apr 2024 23:23:45 by 16

I am using the newer Power Apps Grid Control in model driven apps form. It requires that I set a child table, it wont let you save without it. I tried to set it to nothing in the classic view as well.

I would like to the new features of the edit but I don't have a related table that I want to show in this case. 

 

Is there anyway to hide the the expand button or turn off the child subgrid?

Categories:
  • MJC Profile Picture
    on 18 Apr 2024 at 19:42:02
    Re: Turn Off Child Grid on Power Apps Grid Control

    That's not great. This should be built in functionality.  Hopefully they fix it soon.  I've noticed other quirks I'm trying to work around such as locking cells with a business process rule only applies to forms and editable grid but not to child items in a power apps grid control.  I do see this component appears to be regularly updated by Microsoft (last update 5 days ago) so I am hopeful they are working on it regularly at the moment. 

     

    My concern with the workarounds is I dont want them to break in X months when Microsoft fix stuff, but by then I've forgotten what I did, my app is broken in Prod, and I'm scrambling to unpick all the workarounds.

  • Verified answer
    Em12 Profile Picture
    11 on 18 Apr 2024 at 18:08:46
    Re: Turn Off Child Grid on Power Apps Grid Control

    Yes this is definitely a bug. I also submitted a ticket to them and got a a far from satisfactory response. I will list below the steps they suggested that I try. But I managed to find what I think is an easier work around.

     

    I deleted the grid and re-added. Then once I was re-adding I made sure that the child items selected was the same table as the main items being shown on grid. Then in classic editor I was able to remove the child items once I made another change to the grid at same time e.g. enable editing to Yes. This combination of steps allowed me to remove the child items without getting the error. If this doesn't help, the message from Microsoft was;

     

    "To remove child items from the Power Apps grid within the classic editor, if you receive an error message stating "An error has occurred. Please return to the home page".     Follow the troubleshooting steps given below.

    1. Open the Advanced Settings in Power Apps.
    2. Navigate to Settings > Solutions.
    3. Open the existing solution or create a new solution.
    4. Select Entities > Add Existing and choose the entity that the grid is associated with.
    5. Clear Include entity metadata and Add all Assets options.
    6. Save the solution.
    7. Export the solution and extract the .zip file.
    8. Open the customizations.xml file.
    9. Locate the child node `<Entity>` of the entity you want to edit and find its child node `<RibbonDiffXml>`.
    10. Locate the node that represents the child item you want to remove.
    11. Edit the `<RibbonDiffXml>` node and remove the appropriate node for the child item.
    12. Save the customizations.xml file.
    13. Add the modified customizations.xml file back to the solution .zip file.
    14. Import the solution file.
    15. Select Publish All Customizations."

  • MJC Profile Picture
    on 18 Apr 2024 at 16:58:35
    Re: Turn Off Child Grid on Power Apps Grid Control

    I just submitted a support request for this issue to make sure MS are aware of the issue.

  • MJC Profile Picture
    on 18 Apr 2024 at 16:52:17
    Re: Turn Off Child Grid on Power Apps Grid Control

    I think this is a bug too.  It's very annoying as the grid control is great.  You can go into classic editor, and set this control to the entire table (entity), instead of just a view, which works if that is all you need for the entire table.  However, this causes havoc if you enable it on the entire table, but then have individual views configured with the control where you do want the subgrid.  It will switch between the two on every refresh.  Suspect Microsoft have a bug here.

     

    Ihave certain views where I just want to show the optionset colors, but not display the child items, and this is limiting our creativity on designing the UI.

  • Em12 Profile Picture
    11 on 11 Apr 2024 at 15:19:40
    Re: Turn Off Child Grid on Power Apps Grid Control

    I was using this work around also. However as of today when I'm in classic editor and have cleared the value for child items and select 'ok', I keep getting "An error has occurred. Please return to the home page and try again" so I cannot disable the child items at all. Have you also experienced this?

  • thetakerfan Profile Picture
    18 on 09 Apr 2024 at 16:13:05
    Re: Turn Off Child Grid on Power Apps Grid Control

    This is a new issue, I have a few that I had previously added without children with no problems, but as of today trying to add any new ones makes the Done button unclickable without a child table. As a workaround, going in to classic view and editing the control properties there lets you remove the child table selection and save, but have to do that any time you want to modify the control as the modern view won't save without it.

  • 1sand0s Profile Picture
    16 on 08 Apr 2024 at 05:13:39
    Re: Turn Off Child Grid on Power Apps Grid Control

    I did try that before, however the "Done" button disables when you change it to "Select an option"

    ChildItemsSelection2 (Medium).png

  • BhargavPatel Profile Picture
    628 Super User 2025 Season 1 on 08 Apr 2024 at 04:17:00
    Re: Turn Off Child Grid on Power Apps Grid Control

    Click on it and then select "Select an option". That will deselect the child table. 

    BhargavPatel_0-1712549793479.png

     

  • 1sand0s Profile Picture
    16 on 08 Apr 2024 at 04:09:52
    Re: Turn Off Child Grid on Power Apps Grid Control

    Ya that's the one I'm using. It requires a child table and I don't want that in this case

    ChildItemsSelection1.png

  • BhargavPatel Profile Picture
    628 Super User 2025 Season 1 on 08 Apr 2024 at 03:50:19
    Re: Turn Off Child Grid on Power Apps Grid Control

    See if you can do it in a modern view. Click on + Components > Get more components, if you don't see the Power Apps grid control listed under Add component. 

    Snag_233f385.png

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,776 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,093 Most Valuable Professional

Leaderboard