Hi Everyone
I try to create my PO application for various Countries and Departments, i want to be able to filter the Approvers based on Country, Department, Position and Amount they can approve
i have create the below formula
If(
varCountry = "text",
Concat(
LookUp(
Sharepointlist,
'ApprovalLimit (max amount)' > Value(subtotal.Text) And Country = varCountry
).Approvers.Email,
Email,
";"
),
varCountry = "text",
Concat(LookUp(
Sharepoint list,
'ApprovalLimit (max amount)' > Value(subtotal.Text) And Country = varCountry And Department = dddepartment.Selected.Result
).'Sharepoint Field'.Email,Email, ";") , Concat(LookUp(
'EMEA-PO Tool Expense Approvers',
'ApprovalLimit (max amount)' > Value(subtotal.Text) And Country = varCountry And Department = dddepartment.Selected.Result
).'Sharepoint Field'.Email,Email, ";"))
until Red part works find but when the 2nd country i want to filter is also based on the amount for 2nd approver is not working.
Any help pls 😊
