Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM forum
Suggested answer

How to tell if column is used in form, and what form

Posted on by 65

Hello All -

We are in the process of migrating an on-prem instance of CRM to the cloud, and part of what we are needing to do is identify a lot of the customizations that we've made over the years.  It is easy enough to identify custom columns and tables - and we've written some queries to pull information about these items from the metadata schema, but one thing we have not been able to find in the database is whether or not a custom column is actually used in a form in the application, and if so what form(s) include that column.

If you try to remove a field (column) in CRM and it is used in a form, the application stops you and reports a dependency.  So it seems clear that the data exists somewhere.  What we are hoping to find is a list of all of the columns actually used in forms.

Basically the purpose of this is to get an idea of the level of effort needed to remove obsolete custimizations.

thanks in advance.

  • Suggested answer
    ChadAlt Profile Picture
    ChadAlt 365 User Group Leader on at
    RE: How to tell if column is used in form, and what form

    Hey Craig,

    Bipin mentioned a third-party tool to find dependencies, but you can also do this natively from within a solution. Simply open a solution in the Maker Portal, find and select the column, then click "Advanced" > "Show Dependencies". This will bring up a list of everything using this column, including forms, workflows, business rules, etc. I have noticed that cloud flows do not show up in this list, and JavaScript will only show here if the columns were selected as dependencies. But for sure every form will show here. 

    Hope this helps! 

    pastedimage1660914414102v1.png

    Chad Althaus

    Senior Functional Consultant

    Stoneridge Software

  • Suggested answer
    Bipin D365 Profile Picture
    Bipin D365 28,962 Moderator on at
    RE: How to tell if column is used in form, and what form

    Hi,

    Please check Dependency identifier tool in xrmtoolbox to identify the Dependency .

    www.xrmtoolbox.com/.../

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,537 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,520 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans