Power Apps update 操作

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)

  

posted @ 2019-02-21 15:15  梁云涛  阅读(567)  评论(0)    收藏  举报