Re: Showing Audit History of each fields in Custom Entities in Canvas App Screens
You can filter on "Record Id" with the current entity/table record/row ID (guid). That will give you the changes for that entity, then ThisItem.'Changed Field', ThisItem.'Changed By', ThisItem.'Changed Date' are self-explanatory. The only items missing are Old and New Value, which is a little more tricky to get. You'll need to perform an API call to retrieve those details. The query is something like this:
https://<org>.api.crm<num>.dynamics.com/api/data/v9.2/RetrieveRecordChangeHistory(Target=@Target)?@Target={<entityid>:
"<guid>","@odata.type":"Microsoft.Dynamics.CRM.<entityname>"}
Where entityid is the ID physical field name (e.g. accountid) and entityname is the physical entity name (e.g. account).
To access those Dataverse API functionalities, you'll need to create a custom connector. More info: https://powerapps.microsoft.com/blog/register-and-use-custom-apis-in-powerapps/
Another way is to have a hyperlink directly to the out-of-the-box audit history page for access the details: the format of the URL is:
https://<org>.crm<num>.dynamics.com/userdefined/areas.aspx?oId=<guid>&oType=1&rof=true&security=852023&tabSet=areaAudit
Where oId is he entity record/row ID.
Hope this helps!
