UpdateIf(NameCard,true,{Status:"Pendding",UserName:{
'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
Claims:"i:0#.f|membership|"&Lower(User().Email),
Department:"",
DisplayName:User().FullName,
Email:User().Email,
JobTitle:".",
Picture:"."}
});
People Picker field set default value:
{
'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
Claims:"i:0#.f|membership|"&Lower(LookUp(Employee,Employee_Number=SupervisorPin,Email_Address)),
Department:"",
DisplayName:LookUp(Employee,Employee_Number=SupervisorPin,Employee_Name),
Email:LookUp(Employee,Employee_Number=SupervisorPin,Email_Address),
JobTitle:".",
Picture:"."
}
设置DorpDown list的默认值为空:
ClearCollect(DivisionWithBlank,{Title:""}); Collect(DivisionWithBlank,DivisionList)
ClearCollect(DivisionWithBlank,{Title:""}); Collect(DivisionWithBlank,DivisionList)
截取userPin
Left(User().Email,Find("@",User().Email)-1)
Replace(DataCardValue38_1.Selected.Claims,1,18,"")
Left(Replace(DataCardValue38_1.Selected.Claims,1,18,""),Find("@",Replace(DataCardValue38_1.Selected.Claims,1,18,""))-1)