In my previous post, I explained how to display images from a Dataverse Rich Text field in Power Pages using Liquid.
However, this method enables read access to all records in the Rich Text Attachments (msdyn_richtextfiles) table, which might not be ideal in case the Dataverse environment has other functionalities that have private information stored in that table and should not be available in a Power Pages site.
However, we can create a custom table to store the images, targeting to store only those used by Power Pages sites, for example. And we enable read access to only this table instead of the Rich Text Attachments table in our portal.
Table structure needed
The following fields beyond the standard name/id fields are required for this functionality:
Image File: Image field, to store the image contents
Parent Entity ID: Text-only field (it stores the ID of the record where this image is used but it is not actually a LookUp field)
Custom configuration for…
Source link
More About This Author
SharePoint and Office 365 Consultant/Developer always trying to get the best from Microsoft stack (Microsoft 365/Azure/Power Platform and related stuff).
Living in Ireland since 2018, I had previously worked in Brazil as a consultant/developer for Office 365, SharePoint and related technologies for almost 10 years.
