A nested grid doesn't display data in a Power Apps model-driven app
This article provides troubleshooting steps for an issue where a nested grid doesn't display any data in a Power Apps model-driven app.
Cause
The most common reason is using an incorrect relationship or applying an incorrect view.
Troubleshooting checklist
Make sure the nested grid is configured with the correct relationship.
The Child Items Parent Id parameter must be set to a lookup type field from the entity assigned to the parent grid (bound to Accounts entity as shown in the following screenshot). The lookup field should point to the nested grid entity. Make sure it's a standard lookup type with a standard N:1 (many-to-one) relationship.
Check if the view assigned to the nested grid (the My Active Accounts in step 1) contains any unexpected filters.
Use the Power Apps Monitor tool to inspect the data for the nested grid.
Note
The
childRecordsCount
attribute should display the number of records in the nested dataset. If that attribute shows0
, it's a strong indication of an incorrect relationship specified, the presence of extra filters in the nested grid view, or no records in the nested dataset (ChildItems
). If that number shows a value greater than zero, and your nested grid still doesn't display any records, the issue is most likely with the extra filtering in the nested grid view or there being no records related to the row expanded from the parent grid. Check thechildViewFetchXML
andChildViewFields
and make sure all the filters are correct and that all the column definitions match those specified in thechildViewFetchXML
.