With(
{
_User1: Office365Users.UserProfileV2(DataCardValue116.Value).value,
_User2: Office365Users.UserProfileV2(DataCardValue79.Value).value,
_Mode2: ApprovalForm5.Mode = 2,
_Status:
LookUp(
ColFinARCData,
ID = Value(DataCardValue102.Value),
Status.Value
),
_Updated:
CountRows(
Filter(
DeptStatusCheck,
Status.Value <> "Updated"
)
)
},
Table(
{
Step: 1,
Name:
If(
_Mode2,
_User1.DisplayName,
VarUserDispName
),
Title:
If(
_Mode2,
_User1.JobTitle,
VarUserJobTitle
),
Email:
If(
_Mode2,
_User1.Mail,
UserEmail
),
Status:
Switch(
_Status,
"Submitted",
1,
"Pending",
1,
"Rejected",
1,
"Cancelled",
2,
3
),
Current: ApprovalForm5.Mode = 1
},
{
Step: 2,
Name: DataCardValue96.Value,
Title: "",
Email: "",
Status:
If(
And(
_Mode2,
_Updated = 0
),
1,
3
),
Current:
And(
_Mode2,
_Updated <> 0
)
},
{
Step: 3,
Name: _User2.DisplayName,
Title: _User2.JobTitle,
Email: _User2.Mail,
Status:
Switch(
_Status,
"Pending",
3,
"Approved",
1,
"Rejected",
2,
3
),
Current:
And(
_Mode2,
_Updated = 0,
_Status = "Pending"
)
}
)
)
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.