web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / MS Dataverse Custom Ta...
Power Apps
Answered

MS Dataverse Custom Table/Entity

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

As a Power Platform admin, where or how can I find the details on which user created a custom table?

I have the same question (0)
  • Verified answer
    ChrisPiasecki Profile Picture
    6,422 Most Valuable Professional on at

    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.

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    I am not clear  on  the recommendation.  Is there a way to do this using a Power shell cmdlet?

     

  • Fubar Profile Picture
    8,487 Super User 2026 Season 1 on at

    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).

  • EricRegnier Profile Picture
    8,720 Most Valuable Professional on at

    Hi @Karen_H,

    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.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 545 Most Valuable Professional

#2
Haque Profile Picture

Haque 314

#3
Kalathiya Profile Picture

Kalathiya 234 Super User 2026 Season 1

Last 30 days Overall leaderboard