Caluclated column to get Current year form Created by column



=IF([Created]="","",""&YEAR([Created]))


Caluclated colum dosent support Clauclated type better type of the clauctaed colum is text

<Where>
<Contains>
<FieldRef Name='FullName' />
<Value Type='Calculated'>Rafael</Value>
</Contains>
</Where>



<Where> This is correct
<Contains>
<FieldRef Name='FullName' />
<Value Type='Text'>Rafael</Value>
</Contains>
</Where>

Comments

Popular posts from this blog

SP People Picker Validation

Create multiple web parts in one SPFx Solution

SPFX With Graph API To Pull Azure Active Directory Group Users