Hi all, I found a way to clear Person/People picker fields that doesn't rely on experimental features, nor a Flow, so I thought I'd surface it here. I'm not yet sure if the same approach will work for DateField, LookUp or Group Picker, but hopefully!
My current understanding of my approach makes a few assumptions (I'm not certain whether they are integral to its use):
-You are treating this like a "Complex" data update and are therefore using Patch statements to merge into the existing SP List item
-Your app has a way to detect when the person-picking control was left blank so that you can conditionally change which Patch statement is being executed
-You are using the out-of-the-box people picker or can otherwise tweak my approach to match a "valueless" Person record
All I've done is prep a "BlankPerson" "BlankPeople" variable that is manually shaped as a single tabular, blanked-out Person People record for the SP PersonPeople/Group (multiple selection) field, as follows:
Set(BlankPerson,Table({'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",Claims:Blank(),DisplayName:Blank(),Email:Blank(),Department:Blank(),Picture:Blank(),JobTitle:Blank()}))
Set(
BlankPeople,
Table(
{
Claims: Blank(),
DisplayName: Blank(),
Email: Blank(),
Department: Blank(),
Picture: Blank(),
JobTitle: Blank()
}
)
);
When Patching with this as my payload when the People picker control is left blank, I've been able to Clear the corresponding field on my SP List item.
Hope this helps someone!
Josh
