Unanswered

Turn Off Child Grid on Power Apps Grid Control

(1) Share

Report

Posted on by 1sand0s

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:

Building Power Apps

I have the same question (0)

All responses (11)

Answers (1)

BhargavPatel 660 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No
1sand0s 16 on at

Like (0)

Report

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

Was this reply helpful? Yes No
BhargavPatel 660 Moderator on at

Like (0)

Report

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

Was this reply helpful? Yes No
1sand0s 16 on at

Like (0)

Report

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

Was this reply helpful? Yes No
thetakerfan 18 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Em12 11 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
MJC on at

Like (0)

Report

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.

Was this reply helpful? Yes No
MJC on at

Like (1)

Report

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

Was this reply helpful? Yes No
Verified answer

Em12 11 on at

Like (1)

Report

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

Was this reply helpful? Yes No
MJC on at

Like (0)

Report

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.

Was this reply helpful? Yes No