If you don't have table permissions for a specific table, you can still present data from that table on your Power Pages site. By using FetchXml, you can retrieve data from the table and display it to visitors. However, table permissions only apply to the main entity in your FetchXml, so you won't be able to access linked entities unless you use the correct syntax. Instead of using ".propertyname" syntax, use "[“…”]" syntax to access linked table columns. This allows you to retrieve data from linked entities even if you don't have table permissions for them.
Login now to access my digest by 365.Training