I am tried many ways to clear the filed in SharePoint list using PowerApps and make it null on the record.
but unfortunately, I could not do that.
## first way I tried:
Set(
BlankPerson,
Table(
{
Claims: Blank(),
DisplayName: Blank(),
Email: Blank(),
Department: Blank(),
Picture: Blank(),
JobTitle: Blank()
}
)
);
Patch(
'InvoicePaymentRequests',
{ID: InvoicesListGallery.Selected.ID},
{SecondApprover: BlankPerson()}
);
**I am getting mismatch data type (Record - Table) **
## Second way I tried
Patch(
'InvoicePaymentRequests',
{ID: InvoicesListGallery.Selected.ID},
{
SecondApprover: {
'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
Claims: Blank(),
DisplayName: Blank(),
Email: Blank(),
Department: Blank(),
Picture: Blank(),
JobTitle: Blank()
}
}
);
Refresh(InvoicePaymentRequests)
**this one it is running but will not clear the field value on the list.**
## Third way
Patch(
'InvoicePaymentRequests',
{ID: InvoicesListGallery.Selected.ID},
{
SecondApprover: Blank()
}
);
**also did not work**
any suggestions?
thanks and best regards
