web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Filtering base on vari...
Power Apps
Answered

Filtering base on various fields

(0) ShareShare
ReportReport
Posted on by 60

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 😊

Categories:
I have the same question (0)
  • poweractivate Profile Picture
    11,078 Most Valuable Professional on at

    @DemosCY 

    Duplicate of https://powerusers.microsoft.com/t5/Building-Power-Apps/Filtering-base-on-various-fields/m-p/765552

    Please try to create one post per question.

     

    If you are getting any error, please check the forum and see if it is already there first despite the error.

  • Verified answer
    CU07011146-0 Profile Picture
    60 on at

    @poweractivate  yes i was receiving an error 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
Haque Profile Picture

Haque 85

#2
WarrenBelz Profile Picture

WarrenBelz 76 Most Valuable Professional

#3
Kalathiya Profile Picture

Kalathiya 38 Super User 2026 Season 1

Last 30 days Overall leaderboard