Entities Attribute Changes, where would the ModifiedOn be logged?

[pompousROB]

Unique Circumstance here, trying to extract Dataverse Metadata to document our Environments on a reoccurring basis.

Wanting to pull Entity Metadata and their Attribute Metadata (Logical, Schema, Collection Name(s) etc.) to document and track changes.

After the initial run, I would like this flow to only run and update on Entities that have been edited. (Table Columns dropped, renamed, added etc.)

To do this, I need to sort the Entities by their ModifiedOn date. The ModifiedOn date for an Entity displayed in the Modern interface appears to be the same as what can be retrieved from the WebAPI (..../api/data/v9.0/EntityDefinitions).

The Problem here is that this ModifiedOn date only seems to update or change when the Properties of the Entity are edited (Such as Change Tracking Enabled, Audit Enabled, Searchable etc.) and doesn't appear to change/update when Attributes are renamed or edited, added or deleted.

I also attempted to query all the attributes thinking I could sort them by their ModifiedOn value, and then extract the parent table and find my changes that way. It doesnt appear to return a ModifiedOn date for an Attribute nor the parent Entity value.

(..../api/data/v9.0/attributes)

Where and how are modifications to a Table's structure logged and documented in the Metadata? There are many default entity related tables but I cannot seem to find a way to view when Table Columns are edited. (Ex: msdyn_entityconfiguration, msdyn_entitydeltachange, msdyn_entityconfig )

Please note, I am not interested in changes to the RECORDs, just the Entities.

Thanks in advance.

[cchannon]

What you're looking for is the RetrieveMetadataChanges API Mesage: Query schema definitions (Microsoft Dataverse) - Power Apps | Microsoft Learn

[pompousROB]

Thanks for the reply cchannon,

I gave the RetrieveMetadataChanges API a try, even when I pull in All the Properties I don't get any different data regarding the Entities ModifiedOn date than what I was able to get through the EntityDefinitions query.

It is nice in that it pulls the Entity-Metadata and its Attribute-Metadata in one query, and it does show the ModifiedOn date for an Attribute (Which isnt available in when querying the list of Attributes), but its still not quite what I was hoping for.

The ModifiedOn date for the Entity doesn't reflect any changes to the Entity's Attributes if they are added, dropped, or renamed. 

I suppose I could try to use the Attribute ModifiedOn date and update my data tables for any Attributes: where ModifiedOn > [dateOfLastRun] but it still leaves me sorting through the entirety of my Environments Attributes each time the flow runs, which is a order of Magnitude more than checking a date when each Table was Modified and only updating those modified tables.

This seems odd that there isnt anything tracking when a Table in Dataverse has a Column added/dropped/renamed so Im convinced I am just missing it.

[Fubar]

Historically many metadata changes where not available - You possibly may find it in the Office 365 Compliance Center audit tracking (probably called something else now) as some extra info used to get logged there.