Attribute Bulk Updater

This XrmToolBox tool allows you to bulk update the properties of multiple columns within a table (developed by Tanguy Touzard).

Most of the time, columns are created with the default setting for the properties. If those properties need to be changed later in the project, there would be a lot of columns to be changed and updating one by one would be time-consuming.
To update the properties of multiple columns with a few clicks, you can use this tool to select the table, select the columns and update the properties (Searchable, Enable auditing, Enable column security, Requirement level).
  • Tool Information
  • Documentation
  • Video Tutorial (from 36:50), Video Tutorial 2 (from 14:15)
  • Functionalities
    • Update the column properties (Fig. 1, Pt. 5) and save the changes (Fig. 1, Pt. 2)
      • Check individual column manually (Fig. 1, Pt. 6)
      • Check columns used on the form (Fig. 1, Pt. 7)
      • Check all/clear all columns (Fig. 1, Pt. 8)
      • Invert selection (Fig. 1, Pt. 9)
      • Reset the check to the original state (only check the columns enabled for selected properties) (Fig. 1, Pt. 10)
    • Additionally, the tool can
      • Load the list of tables (Fig. 1, Pt. 1) and show Display Name and Schema Name (Fig. 1, Pt. 4)
      • Publish the selected table (Fig. 1, Pt. 3)
      • Load the list of columns for the selected table (Fig. 1, Pt. 1) and show Display Name, Logical Name, Changeable, Customizable, Used on Form, Requirement Level (Fig. 1, Pt. 11)

Fig. 1 - Bulk Update Column Properties from Selected Table

This is part of the #TooLDR series where I test and review the tools for Power Platform. You can check out the information for the other tools on this page.

Comments

Popular Posts