Announcements
Hi folks,
We have one Account Entity having 200 fields. I want to know how i can know that which fields are not in use so that instead
of creating new fields we can reuse the unused fields.
Thanks
On the Field definition click the Show Dependencies button - if it is referenced in a Workflow, in a view, on a Form, or part of the trigger for a plugin they will be listed in the dependencies list.
Do an Advanced Find on the Entity and filter the field on contains data (will tell give you no results if the field is empty)
Hi windyMill,
If you mean fields that are not added to any component, such as being added to a form, in a view, or in a workflow, then you can only edit the fields one by one in the solution and click Show Dependencies to see if there are any Dependent components.
If you mean fields that do not contain data in all records, you can use Attribute Usage Inspector of XrmToolBox.
Thanks for your reply but I was looking solution to check if i have around 200 columns.
Hi Lu,
Thanks for your reply. I was looking the same kind of thing something automated because I have around 200 columns. Well same i achieved from SQL query.
But using XRM tool box seems to be very clean i will try this and let you know.
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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 107 Super User 2026 Season 2
Daniyal Khaleel 64 Most Valuable Professional
ParthPatel249 62