We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see ourdocumentation.
There was an error while loading.Please reload this page.
1 parentd2436f9 commit77cd41aCopy full SHA for 77cd41a
MISC/Move-Lists.ps1
@@ -139,6 +139,20 @@ if ($MigrationType -eq "Export") {
139
}
140
141
142
+# Fix Formula nodes - replace [{fieldtitle:FieldName}] with just FieldName
143
+$formulaNodes=$xml.SelectNodes("//Formula")
144
+if ($formulaNodes-ne$null-and$formulaNodes.Count-gt0) {
145
+Write-Host"Processing Formula nodes:"$formulaNodes.Count
146
+foreach ($formulaNodein$formulaNodes) {
147
+if ($formulaNode.InnerText-match'\[\{fieldtitle:([^}]+)\}\]') {
148
+$originalFormula=$formulaNode.InnerText
149
+$updatedFormula=$originalFormula-replace'\[\{fieldtitle:([^}]+)\}\]','$1'
150
+$formulaNode.InnerText=$updatedFormula
151
+Write-Host"Updated formula:$originalFormula ->$updatedFormula"
152
+ }
153
154
155
+
156
# Get all 'Field' nodes with attribute Hidden='TRUE'
157
$hiddenFields=$xml.SelectNodes("//Field[@Hidden='TRUE']")
158
if ($null-ne$hiddenFields) {