Solved: Turn Off Child Grid on Power Apps Grid Control

1sand0s · ‎04-07-2024

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?

Em12

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."

View solution in original post

BhargavPatel · ‎04-07-2024

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.

1sand0s · ‎04-07-2024

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

BhargavPatel · ‎04-07-2024

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

1sand0s · ‎04-07-2024

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

thetakerfan · ‎04-09-2024

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.

Em12 · ‎04-11-2024

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?

MJC

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.

MJC

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

Em12

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."