I have tried six ways to Sunday to get this to work and the most reasonable NON-working solution is this:
2 objects: txtEstimatedImpact (Text Input) and optGrtr5K_50K (Radio)
1 variable: varEstImpact
Screen
OnVisable =
Reset(txtEstimatedImpact)
(varEstImpact,"")
txtEstimatedImpact
Default = ""
OnChange =
If(Value(txtEstimatedImpact.Text)>=50000,UpdateContext( { varEstImpact: ">=$50,000" } ),
If(Value(txtEstimatedImpact.Text)>=5000,UpdateContext( { varEstImpact: ">=$5,000" } ),
UpdateContext( { varEstImpact: "" } )));Reset(optGrtr5K_50K)
optGrtr5K_50K
Items = [">$5,000",">$50,000"]
Default = varEstImpact
In image below, it shows the results I'm looking for.
If manually select one of the two option buttons, then change anything in the text box, the option buttons reset to both unchecked. This is expected on screen entry because the variable is set to "". After entering text though, it seems the variable is never updated (even though it is).
See the design mode image showing the current value in memory.
I also tried not using a variable, but this is also without formula errors, but doesn't work.
If(Value(txtEstimatedImpact.Text)>=50000,">=$50,000",
If(Value(txtEstimatedImpact.Text)>=5000,">=$5,000",
""))
Any help would be greatly appreciated. Thank you.
Solved! Go to Solution.
Unless there is a typo in the information you provided, here is what you said:
But your formula is reading ">=$5,000" and not ">$5,000"
If(Value(txtEstimatedImpact.Text)>=50000,">=$50,000",
If(Value(txtEstimatedImpact.Text)>=5000,">=$5,000",
""))
Unless there is a typo in the information you provided, here is what you said:
But your formula is reading ">=$5,000" and not ">$5,000"
If(Value(txtEstimatedImpact.Text)>=50000,">=$50,000",
If(Value(txtEstimatedImpact.Text)>=5000,">=$5,000",
""))
JR, that was it. How dumb?!! Get the formula correct and mis-reference the object. YIKES!
Thank you so much.
No worries, it happens! A misplaced paren, a missing curly brace or comma, it happens to all of us.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Power Platform release plan for the 2022 release wave 2 describes all new features releasing from October 2022 through March 2023.
User | Count |
---|---|
206 | |
97 | |
60 | |
51 | |
45 |
User | Count |
---|---|
257 | |
158 | |
85 | |
79 | |
58 |