Power Platform Community Forum Thread Details

Hi.

I'm trying to determine who created a specific Column in a Table, and when it was done. We're using Dataverse (with a M365 subscription).

I found an old thread that asks something similar, about a Table instead of a Column.

https://powerusers.microsoft.com/t5/Microsoft-Dataverse/Dataverse-Table-Creation-Details/m-p/1274100#M14221

Do you think I could use the same tools suggested in the above thread? I've used XrmToolbox in the past, to do translations in a model-driven app, so I have a little bit of experience with that. I have never used FetchXml or FetchXml Builder though.

Categories:

Microsoft Dataverse with Power Apps

A possible way to find out who created a column in a Dataverse table is to query the creator of the views that are generated when creating a table. You can use FetchXml with the FetchXml Builder tool of the XrmToolBox to do this. Here is an example of the FetchXml code:

You need to replace the with the actual code of the table you want to check. <entity type code>

You must use the XRM ToolBox and the Fetch Builder tool.
The table is savedquery

<fetch top="50">
 <entity name="savedquery">
 <attribute name="createdby" />
 <filter>
 <condition attribute="returnedtypecode" operator="eq" value="entity type code" />
 </filter>
 <link-entity name="systemuser" from="systemuserid" to="createdby" alias="Propietario">
 <attribute name="fullname" />
 </link-entity>
 </entity>
</fetch>

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
You can accept more than one post as a solution

@IvanRad