Using linked entity columns in Power Pages with Liquid and FetchXML


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.


Article 9m

Login now to access my digest by 365.Training

Learn how my digest works
Features
  • Articles, blogs, podcasts, training, and videos
  • Quick read TL;DRs for each item
  • Advanced filtering to prioritize what you care about
  • Quick views to isolate what you are looking for right now
  • Save your favorite items
  • Share your favorites
  • Snooze items you want to revisit when you have more time