Hello everyone,
I'm currently working on a Power Apps project, and I have a question regarding the filtering of Choice field values based on a condition. I have a Choice field where I want to display only the options who's corresponding currentValue is greater than or equal to 0.
I have implemented a formula, but it doesn't work as expected. The formula stops at the first logical test and doesn't proceed further. Here's the formula I'm using:

If(
currentLD = 0,
Filter(
Choices([@employee_requests_list].requestType),
Value = "Non-standard equipment" || Value = "Psychological support" || Value = "Gift for child"
),
currentEQ = 0,
Filter(
Choices([@employee_requests_list].requestType),
Value = "Learning & development" || Value = "Psychological support" || Value = "Gift for child"
),
currentPS = 0,
Filter(
Choices([@employee_requests_list].requestType),
Value = "Learning & development" || Value = "Non-standard equipment" || Value = "Gift for child"
),
currentCG = 0,
Filter(
Choices([@employee_requests_list].requestType),
Value = "Learning & development" || Value = "Non-standard equipment" || Value = "Psychological support"
),
Choices([@employee_requests_list].requestType)
)

I would like to know if there is a better solution to display only the choices that have a currentValue greater than or equal to 0. Additionally, at the start of the application, I have created variables currentLD, currentEQ, currentCG, and currentPS using the following formula:
Set(currentLD, LookUp(employee_budgets, Title = User().Email, LD));
Set(currentEQ, LookUp(employee_budgets, Title = User().Email, EQ));
Set(currentCG, LookUp(employee_budgets, Title = User().Email, CG));
Set(currentPS, LookUp(employee_budgets, Title = User().Email, PS));
These variables are used to check if the currentValue is greater than or equal to 0.
If anyone has a more efficient solution or suggestions on how to improve my existing formula, I would greatly appreciate your input.
Thank you in advance for your help!
Best regards,