How to bulk change main forms header density using Cloud Flows ?

As announced by Microsoft, the low-density header option will be deprecated on October 2021. As an impact, any current form that is configured as “low-density” will be automatically updated to render in a high-density with flyout mode in a model driven app.

I will present on this blog a way to change in bulk the “high-density” option on all account main forms using power automate cloud flows.

Cloud Flow summary:

How does it work ?

All form configurations are stored in the SystemForm Table, precisely in the formXml field, which stands for the Xml representation of the form. Low header density option is represented by the snippet XML below:

High-density Only option is represented by the snippet XML below:

High-density with flyout option is represented by the snippet XML below:

The flow that we are creating will update the “headerdensity” property from “Low” to “HighWithControls” for all account main forms. Trust me, it’s possible with Power Automate Cloud Flows !

Cloud Flow Steps in detail:

• Get Account Main Forms:

  

  Filter rows: type eq 2 and objecttypecode eq 'account'
  

• Verify that the form density is Low:

  

  FormXml Contains? headerdensity="Low"
  

• If yes, update the formXml header density property from “Low” to “HighWithControls”

  

  FormXml Expression: replace(items('Apply_to_each')?['formxml'],'headerdensity="Low"','headerdensity="HighWithControls"')
  

• Publish Account table Customizations

  

  ParameterXml: <importexportxml><entities><entity>account</entity></entities></importexportxml>