Notifications
Announcements
As a Power Platform admin, where or how can I find the details on which user created a custom table?
Hi @Karen_H,
Unfortunately you can't directly find out who created a table. That said, system views are created along with every table and you can determine from the SavedQueries table. You can use the Dataverse Web API to find this information. Make sure to specify the name (not Display Name) of your table.
https://<environmentUrl>/api/data/v9.0/savedqueries?$filter=returnedtypecode eq 'account'&$select=returnedtypecode,createdon&$expand=createdby($select=fullname)&$top=1
---Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.
I am not clear on the recommendation. Is there a way to do this using a Power shell cmdlet?
Basically what @ChrisPiasecki is saying is there is not a way to pickup on the Entity/Table itself - however when a new Entity/Table is created there are half a dozen out of the box Views that are always created at the same time as the Entity - these Views do capture the user creating them (i.e. user that created the entity = user that created the out of the box views).
So basically you can query the CreatedBy user (and CreatedOn date) on one of the out of the box Views.
Chris provided the basic oData query that you can just paste into your browser after substituting in your environments name (you can also get it via Advanced Find).
You can use PowerShell
The second link has a FetchXml query on it, you would construct a fetchXML query on the SavedQueries table (e.g. use Advanced Find to construct the query and download its FetchXML). Believe there may also be a way to do oData rather than FetchXml (but its not something I do so can't provide a lot more detail).
The easiest way is the trick that @ChrisPiasecki shared. It is possible with the modern DevOps tools by leveraging Solution Packager to deconstruct a solution into XML files and commit to source control (e.g. Git). There are Azure DevOps and GitHub build tools to facilitate this: https://docs.microsoft.com/power-platform/alm/devops-build-tools
The idea is once you have the solution details and they're committed into Git, you can leverage all the Git capabilities to analyze the files and can easily determine who created/updates entities/tables. Suggest to have a look at that, it is very helpful!
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
In our never-ending quest to improve we are simplifying the forum hierarchy…
We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 802 Most Valuable Professional
Michael E. Gernaey 332 Super User 2025 Season 2
Power Platform 1919 273
