I want to set a field in a SharePoint List to the current User
Easy enough. You can use the Patch Command to update a record in a SharePoint list so as follows?
Patch('SPList',
LookUp('SPList', ID=varItem.ID),
{ApprovedBy:User()}
);
Nope
Patch('SPList',
LookUp('SPList', ID=varItem.ID),
{ApprovedBy:{
'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
Claims:"i:0#.f|membership|" & Lower(User().Email),
Department:"", DisplayName:User().Email,
Email:User().Email,
JobTitle:".",
Picture:"."
}
}
);
Thanks for the Low Code solution Microsoft!