Conditioning textbox input for Fail/Pass

(0) Share

Report

Posted on by Virikefe22

302

In the diagram below, Recipe (1) (DataCardValue3_1) Item properties is as below:

Table(
 {Value: "Omo Auto Wash(Add)", Lower: 590, Upper: 670},
 {Value: "Omo Avenger", Lower: 500, Upper: 600},
 {Value: "Omo Sunshine", Lower: 500, Upper: 600},
 {Value: "Radiant", Lower: 350, Upper: 450},
 {Value: "Sunlight Lite", Lower: 500, Upper: 600}
)

The DefaultSelectedItems property of Status (3) combobox is:

With({_val: IfError(Value(DataCardValue4_1.Text), 0)},

 {Value:
 If(_val < DataCardValue3_1.Selected.Lower || _val > DataCardValue3_1.Selected.Upper, "Fail", "Pass")
 }
)

I want that, when I enter values lesser or greater in the BD input combobox, it should change to Fail and when I enter values between the ranges selected in the Recipe, the Status value should change to Pass.

Can anyone help out in this case with the BD conditioning parameters?

Categories:

Building Power Apps

I have the same question (0)

All responses (15)

Answers (1)

RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report

@Virikefe22

We already did this in your other post.

What is the issue you are having now with it? The formula should be providing what you need.

Was this reply helpful? Yes No
Virikefe22 302 on at

Like (0)

Report

No it's not @RandyHayes
When I select anything in the Recipe, the values in the Status changes immediately without entering a value into the BD field.
The case scenario is, when I select anything from the list of the Recipe, and enter a value in the BD field, the Status should change to Fail if what I inputted is less than or greater than the selected Recipe range but should be Pass, if the inputted value is not less than and not greater than the selected Recipe range.

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report

@Virikefe22

I am not getting the distinction.

If someone enters 5 in the BD and then changes the Recipe - it would be a fail with 5.

Is it that you want the BD to clear when the Recipe is changed? And that the status would be nothing until something is entered in the BD?

Trying to understand your logic on it.

Was this reply helpful? Yes No
Virikefe22 302 on at

Like (0)

Report

Exactly, the Status should be nothing until the BD value is entered then it'll change to either pass or fail, checking the values against what is selected in the Recipe ranges.

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,297 Super User 2024 Season 1 on at

Like (1)

Report
@Virikefe22

Very good! Then do the following:

On the Combobox OnChange action, add the following formula:

Reset(DataCardValue4_1)

Then change the DefaultSelectedItems property of your pass fail to:

If(!IsBlank(DataCardValue4_1.Text), With({_val: IfError(Value(DataCardValue4_1.Text), 0)}, {Value: If(_val < DataCardValue3_1.Selected.Lower || _val > DataCardValue3_1.Selected.Upper, "Fail", "Pass") } ) )

Was this reply helpful? Yes No
Virikefe22 302 on at

Like (0)

Report

Thanks @RandyHayes It's working fine as expect with the input change the values from Pass to Fail accordingly. But one more thing. Each time the value is entered, it changes but when I move to the next input or click outside the input field, the values erases from the BD combobox and then the pass or fail clears off too.

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report

@Virikefe22

Do you happen to have a formula in the OnChange action of the input?

Was this reply helpful? Yes No
Virikefe22 302 on at

Like (0)

Report
Yes, which is this you asked me to input first:
Reset(DataCardValue4_1)

Was this reply helpful? Yes No
Virikefe22 302 on at

Like (0)

Report

Ok, I got this now. It's the Status card you mean I should apply both the OnChange and DefaultSelectedItems code to.

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (1)

Report

@Virikefe22

No, the Reset formula should be on the Recipe control DataCardValue3_1

The DSI formula should be on your Status control.

The BD (DataCardValue4_1) control should have no formula in the OnChange.

Was this reply helpful? Yes No