Filtering Choice Field Values Based on currentValue in Power Apps

(3) Share

Report

Posted on by Bambula

169

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,

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

v-jefferni Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @Bambula ,

Do you have four choices in a Choice column, and would like to set three from the four as selections in the Combo box based on which variable is 0? Is it possible that there are more than 1 variables are not 0? I think the more propriate method is removing a value if corresponding variable is not 0. Please try below formula instead:

With( { wChoices:Choices([@employee_requests_list].requestType }, With( {wLD: If( currentLD != 0, Filter( wChoices, Value != "Learning & development" ), wChoices }, With( {wEQ: If( currentEQ != 0, Filter( wLD, Value != "Non-standard equipment" ), wLD) }, With( {wPS: If( currentPS != 0, Filter( wEQ, Value != "Psychological support" ), wEQ) }, If( currentCG != 0, Filter( wEQ, Value != "Gift for child" ), wEQ ) ) ) ) )

Best regards,

Was this reply helpful? Yes No
Verified answer

Bambula 169 on at

Like (1)

Report
Copy link

Link copied!
Hi @v-jefferni
Thank you for your kind response. However, in the meantime, I have found a solution, and it is working well.

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

Was this reply helpful? Yes No