I am working on a client SharePoint online tenant, and they have a column of type Computed, as follow:-
where users' submit answers from a Power app and the field will either show Passed or Failed. here is the field property:-
PS C:\WINDOWS\system32> $columns = Get-PnPField -List "C-19 Self-Assessment App" PS C:\WINDOWS\system32> foreach($column in $columns){ >> >> if($column.InternalName -eq 'LinkTitle') >> { >> Write-Host "Column Title :" $column.Title >> Write-Host "Description :" $column.Description >> Write-Host "Group Name :" $column.Group >> Write-Host "Internal Name :" $column.InternalName >> Write-Host "Static Name :" $column.StaticName >> Write-Host "Scope :" $column.Scope >> Write-Host "Type :" $column.TypeDisplayName >> Write-Host "Schema XML :" $column.SchemaXml >> Write-Host "Is Required? :" $column.Required >> Write-Host "Is read only? :" $column.ReadOnlyField >> Write-Host "Unique? :" $column.EnforceUniqueValues >> Write-Host "Sealed? :" $column.Sealed >> >> >> >> >> } >> >> } Column Title : Result Description : Group Name : Custom Columns Internal Name : LinkTitle Static Name : LinkTitle Scope : /sites/HomeOffice/en-ca/Forms/Lists/C19 SelfAssessment App Type : Computed Schema XML : <Field ID="{82642ec8-ef9b-478f-acf9-31f7d45fbc31}" ReadOnly="TRUE" Type="Computed" Name="LinkTitle" DisplayName="Result" DisplayNameSrcField="Title" ClassInfo="Menu" AuthoringInfo="(linked to item with edit menu)" ListItemMenuAllowed="Required" LinkToItemAllowed="Prohibited" SourceID="http://schemas.microsoft.com/sharepoint/v3" StaticName="LinkTitle" FromBaseType="TRUE" CustomFormatter="{"elmType":"div","style":{"box-sizing":"border-box","padding":"0 2px"},"attributes":{"class":{"operator":":","operands":[{"operator":"==","operands":["[$Results]","Failed"]},"sp-css-backgroundColor-blockingBackground50",""]}},"children":[{"elmType":"span","style":{"line-height":"16px","height":"14px"},"attributes":{"iconName":{"operator":":","operands":[{"operator":"==","operands":["[$Results]","Failed"]},"ErrorBadge",""]}}},{"elmType":"span","style":{"overflow":"hidden","text-overflow":"ellipsis","padding":"0 3px"},"txtContent":"[$Title]","attributes":{"class":{"operator":":","operands":[{"operator":"==","operands":["[$Results]","Failed"]},"",""]}}}],"templateId":"ConditionalColumn"}" Version="3"><FieldRefs><FieldRef Name="Title" /><FieldRef Name="LinkTitleNoMenu" /><FieldRef Name="_EditMenuTableStart2" /><FieldRef Name="_EditMenuTableEnd" /></FieldRefs><DisplayPattern><FieldSwitch><Expr><GetVar Name="FreeForm" /></Expr><Case Value="TRUE"><Field Name="LinkTitleNoMenu" /></Case><Default><HTML><![CDATA[<div class="ms-vb itx" onmouseover="OnItem(this)" CTXName="ctx]]></HTML><Field Name="_EditMenuTableStart2" /><HTML><![CDATA[">]]></HTML><Field Name="LinkTitleNoMenu" /><HTML><![CDATA[</div>]]></HTML><HTML><![CDATA[<div class="s4-ctx" onmouseover="OnChildItem(this.parentNode); return false;">]]></HTML><HTML><![CDATA[<span> </span>]]></HTML><HTML><![CDATA[<a onfocus="OnChildItem(this.parentNode.parentNode); return false;" onclick="PopMenuFromChevron(event); return false;" href="javascript:;" title="Open Menu"></a>]]></HTML><HTML><![CDATA[<span> </span>]]></HTML><HTML><![CDATA[</div>]]></HTML></Default></FieldSwitch></DisplayPattern></Field> Is Required? : False Is read only? : True Unique? : False Sealed? : False
now i want to modify how the field show/calcualte Passed and Failed... so how i can do so? Thanks