Attribute Value Updater

This XrmToolBox tool allows you to bulk update the value of the columns for all or filter certain rows by using filter XML (developed by Bram Colpaert).

Sometimes, there is a requirement to update the value for multiple rows for data patching purpose.
To bulk update the column values, you can use this tool to set the value for the columns, filter the row with <filter> XML and bulk update the values.

This tool is good only for the simple data type columns and not working for (lookup and choices columns). The choice column options are not selectable and the value needs to be entered in the integer value of the option. Only the basic filtering can be done and it cannot link-entity filtering is not supported. There is no option to assign the new owner, change the status/status reason and set null value.  Bulk Data Updater would be a more suitable tool for those advanced options.
  • Tool Information
  • Functionalities
    • Bulk update the column values (Fig. 1, Pt. 2)
      • Filter the rows to be updated with the <filter> section from the FetchXML query (Fig. 1, Pt. 4) (Fig. 2)
    • Additionally, the tool can
      • Run preview to validate the data and calculate the number of rows to be updated (Fig. 1, Pt. 1, 5) (not working at the moment)
      • Filter the table by Display Name or Logical Name (Fig. 1, Pt. 3)
      • Show the number of rows updated, skipped or errored out  (Fig. 1, Pt. 5)
  • Similar Tool

Fig. 1 - Attribute Value Updater with Column Values

Fig. 2 - FetchXML Filter

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