Answered

Help with an If statement

(0) Share

Report

Posted on by Frac

200

Hello, i am building an app wher ei have 4 radio buttons that are used to filter the results. my If statement works for some of the scenarios but not all of them, and i'm trying to figure out why. Each record has 2 boolean fields, Process Confirmed, and Resolved.

my 4 states are;

All Records - No filter applied

Unresolved - Resolved <> true

Resolved but not Completed - Resolved = true, & Process Completed <> true

Completed - Resolved = true & Process Completed = true

Here is my statement;

If(Radio1.SelectedText.Value = "Unresolved",Filter('Defect Tracking',Resolved <> true),
If(Radio1.SelectedText.Value = "Resolved but not Completed",Filter('Defect Tracking',And(Resolved = true, 'Process Confirmed' <> true)),
If(Radio1.SelectedText.Value = "Completed",Filter('Defect Tracking',And('Process Confirmed' = true,Resolved = true)),
'Defect Tracking')))

The completed selection is not working for me. based on my data, only record 1 should show up since both items are true, however, only record 3 shows up. I'm a little confused as to why this is happending, since none of the other unresolved records are showing up.

Any idea how i fix this so this ste will show records where Resolved and Process Confirmed are both true?

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

Verified answer

BCBuizer 22,854 Super User 2026 Season 2 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Frac ,

I recommend to use an Switch function instead of nested If functions for your case because it's easier to keep track of the conditions. Your issues are caused by incorrect nesting of some of the functions.

The below should do the trick:

Switch( Radio1.Selected.Value, "All Records", 'Defect Tracking', "UnResolved", Filter('Defect Tracking', Resolved <> true), "Resolved but not Completed", Filter('Defect Tracking', Resolved = true && 'Process Confirmed' <> true), "Completed", Filter('Defect Tracking', Resolved = true && 'Process Confirmed' = true) )

Notice I replaced Radio1.SelectedText with Radio1.Selected because SelectedText is a deprecated property.
Frac 200 on at

Like
a
(0)

Report
Copy link

Link copied!
@BCBuizer Thanks for cleaning up that formula for me. one followup question;
"UnResolved", Filter('Defect Tracking', Resolved <> true),

this was working in my if statement, but now is returning nothing. is there somehting else that i need to fix here?
Frac 200 on at

Like
a
(0)

Report
Copy link

Link copied!

@BCBuizer Never mind, i fixed it, UnResolved had to change to Unresolved. thanks so much
charlessexton 11 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Is it because of the capital R in unresolved?