Hi there, I have an if function that is to move items through a workflow path. there is a spot that it needs to evaluate if a multiple person column has an assignment or not and for the life of me... all other patching functions are working perfect except the ones in red.
It passes everything as "Pending Specialty Authorization", even when the table is blank. i have tried !/IsBlank, !/IsEmpty, and i think i tried coalesce but i may have done it wrong. is there a way to pass a multiple person column as a blank from a variable? I have tried the && in the evaluation and the And like it currently is. nothing seems to pass as the multiple person column is blank. I checked the variable itself and its passing it as "table" and when i look at the table its of course... blank. I've attached photos of when there is and isn't a name in the variable.
If(
varApprovalLevel = "L1",
Patch(
'Purchase Approvals',
varFormID,
{
'Approval Path Notes': "L1 Approved by " & varUserInfo.FullName & Char(10) & Now() & Char(10) & DataCardValue17_1.Value & Char(10) & DataCardValue17.Value & Char(10),
'Approval Status': "Pending L2 Authorization",
'Authorization L2': L2Auth_1.Selected,
'Funding Source': DataCardValue9.Selected,
'Estimated Cost': Value(DataCardValue8.Value),
Urgent: DataCardValue2.Checked
}
),
varApprovalLevel = "Spec",
Patch(
'Purchase Approvals',
varFormID,
{
'Approval Path Notes': "Specialty Approved by " & varUserInfo.FullName & Char(10) & Now() & Char(10) & DataCardValue17_1.Value & Char(10) & DataCardValue17.Value & Char(10),
'Approval Status': "Pending Final Authorization",
'Funding Source': DataCardValue9.Selected,
'Estimated Cost': Value(DataCardValue8.Value),
Urgent: DataCardValue2.Checked
}
),
varApprovalLevel = "Fin",
Patch(
'Purchase Approvals',
varFormID,
{
'Approval Path Notes': "Final Approval by " & varUserInfo.FullName & Char(10) & Now() & Char(10) & DataCardValue17_1.Value & Char(10) & DataCardValue17.Value & Char(10),
'Approval Status': "Approved",
'Funding Source': DataCardValue9.Selected,
'Estimated Cost': Value(DataCardValue8.Value),
Urgent: DataCardValue2.Checked
}
),
And(
varApprovalLevel = "L2",
IsEmpty(varFormID.SpecialtyAuthorization)
),
Patch(
'Purchase Approvals',
varFormID,
{
'Approval Path Notes': "L2 Approved by " & varUserInfo.FullName & Char(10) & Now() & Char(10) & DataCardValue17_1.Value & Char(10) & DataCardValue17.Value & Char(10),
'Approval Status': "Pending Final Authorization",
'Funding Source': DataCardValue9.Selected,
'Estimated Cost': Value(DataCardValue8.Value),
Urgent: DataCardValue2.Checked
}
),
And(varApprovalLevel = "L2" , !IsEmpty(varFormID.SpecialtyAuthorization)),
Patch(
'Purchase Approvals',
varFormID,
{
'Approval Path Notes': "L2 Approved by " & varUserInfo.FullName & Char(10) & Now() & Char(10) & DataCardValue17_1.Value & Char(10) & DataCardValue17.Value & Char(10),
'Approval Status': "Pending Specialty Authorization",
'Funding Source': DataCardValue9.Selected,
'Estimated Cost': Value(DataCardValue8.Value),
Urgent: DataCardValue2.Checked
}
)
);
