When an Entity List does not show data in Power Pages (formerly Power Apps Portals), it could be due to several reasons ranging from incorrect data permissions to misconfigurations in the Entity List itself. Below is a step-by-step guide to troubleshoot and resolve the issue of an Entity List not displaying data in your Power Pages portal.
Step 1: Verify Entity Permissions
One of the most common causes of an Entity List not showing data is the lack of appropriate permissions for the Entity in Power Pages. Ensure that the entity permissions for the list are correctly set for the intended users or roles.
A. Review Entity Permissions
- Navigate to Portal Management > Entity Permissions.
- Select the relevant Entity Permissions record that corresponds to the Entity List you are working with.
- Ensure that the Entity Permissions settings include the correct Web Role that should have access to the data. If you’re using the Authenticated Users role or any custom web role, verify that it is properly assigned.
- Check if the Permissions (Create, Read, Write, Delete, Append, AppendTo) are set correctly. For an Entity List to show data, the Read permission must be enabled for the relevant web roles.
- If the Anonymous user role is involved, ensure that it also has Read access to the entity, if you intend for public users to view the data.
B. Check the Record Ownership and Access Rights
- Ensure that the records you’re trying to display are not restricted due to ownership or sharing settings. If the data belongs to specific users or requires explicit sharing, you may need to adjust security roles and record sharing settings in Dynamics 365 to allow access for the appropriate users.
Step 2: Check Web Role Permissions for the Portal
Web roles determine which users have access to specific pages, data, or components of your portal. The Entity List should be associated with a web role that grants access to the data.
A. Review Web Role Permissions
- Go to Portal Management > Web Roles.
- Select the relevant web role(s) that should have access to the Entity List.
- Under Web Page Permissions or Entity Permissions, ensure that the correct permissions are set for the Entity List or the entity the list is associated with.
- Ensure that the web role is granted Read permissions for the entity being displayed in the list.
Step 3: Verify the Entity List Settings
The Entity List component itself may not be configured properly, which can prevent data from showing.
A. Check the Entity List Configuration
- Navigate to Power Pages > Portal Management > Entity Lists.
- Select the Entity List you are working with.
- Ensure that the Entity and View associated with the Entity List are correctly selected. The View should have the correct filters and columns to display data.
- Confirm that the Entity List is pointing to the correct Entity and that the list is configured to retrieve and display data properly.
- Ensure that the Display Name, Web Role Permissions, and other configurations are correctly set.
Step 4: Review the Filters and Views
Sometimes the data isn’t showing because of filters or view settings that limit the data returned.
A. Check Filters in Views
- Navigate to Power Pages > Portal Management > Entity Lists > Entity List Views.
- Check the filters applied to the View associated with the Entity List. Ensure that the filters are not too restrictive and that they allow the expected data to be returned.
- If the filters are too specific, try removing them or adjusting them to show more data.
B. Check if Records are Actually Present
Make sure there are records available in the Entity that the Entity List is trying to display. Sometimes the issue can simply be that there is no data in the table that matches the conditions set in the view.
Step 5: Ensure Data is Published
If you have recently made changes to the data or settings of the Entity List, ensure that the changes have been properly published.
A. Publish Changes
- After making changes to Entity Permissions, Web Role Settings, or Entity List Views, ensure that you publish the changes to the portal.
- Navigate to Power Pages > Portal Management and click Publish to apply the changes.
Step 6: Clear Portal Cache
Sometimes changes don’t reflect immediately due to cached data in Power Pages. Clear the portal’s cache to ensure that the latest settings are applied.
A. Clear Cache
- Navigate to Power Platform > Power Pages > Portals.
- Select the relevant portal and go to the Cache tab.
- Click Clear Cache to refresh the portal and apply any recent configuration changes.
- After clearing the cache, check the Entity List again to see if data appears.
Step 7: Review the Portal’s Error Logs
If none of the above steps resolve the issue, you can check the portal’s error logs for any potential issues related to the Entity List or data retrieval.
A. Review the Logs
- Navigate to Power Platform > Portal Management > Audit Logs.
- Review the logs for any errors related to data retrieval or permission issues.
- If there are any errors related to the Entity List, the logs might give you more information about what went wrong and where to look for fixes.
Step 8: Check for JavaScript or Web Resource Errors
If the Entity List is embedded with custom JavaScript or web resources, make sure there are no errors in the console that could be preventing data from displaying.
A. Inspect the Console
- Open the portal in a browser.
- Press F12 to open the browser’s developer tools, then navigate to the Console tab.
- Look for any JavaScript errors or failed network requests that might be preventing the Entity List from retrieving data.
- If there are errors, address them by updating the JavaScript code or checking the web resources being used.
Step 9: Test with Different Users
If you are still having issues with data visibility, test with different users to see if the problem is isolated to a specific user role or permission set.
A. Test Different Web Roles
- Try accessing the portal with a different web role, such as Administrator or System User, to check if the problem is related to user roles or permissions.
- This will help confirm if the issue is tied to role-based access or if it’s a broader issue with the Entity List or portal.