PowerApps Canvas通过当前审批状态控制只允许审批人编辑

发布时间 2023-11-02 10:11:58作者: 随乄风

在DetailScreen的OnVisible事件中创建变量varIsApprovalUser判断登录人是否为当前节点的审批人:

Set(myself, User());
If(!varSelectedParent,UpdateContext({varIsApprovalUser:true}),
Switch(varSelectedRecord.'Order Status状态'.Value,
"待审批",If(User().Email=varSelectedRecord.Applicant申请用户.Email,UpdateContext({varIsApprovalUser:true}),UpdateContext({varIsApprovalUser:false})),
"CQTechnician",If(User().Email=varSelectedRecord.CQTechnician.Email,UpdateContext({varIsApprovalUser:true}),UpdateContext({varIsApprovalUser:false})),
"SQ",If(User().Email=varSelectedRecord.SQ.Email,UpdateContext({varIsApprovalUser:true}),UpdateContext({varIsApprovalUser:false})),
"CQE Approval",If(User().Email=varSelectedRecord.CQE.Email,UpdateContext({varIsApprovalUser:true}),UpdateContext({varIsApprovalUser:false})),
"PR SAP",If(User().Email=varSelectedRecord.PRSAP.Email,UpdateContext({varIsApprovalUser:true}),UpdateContext({varIsApprovalUser:false}))
));