Status change based on drop down list box - not working as expected

[BradAugustene]

Hi,

I am trying to change label status text based on two drop down list box and it is not working as expected.

When a user selects any items from Vehicle drop-down and Decision drop-down then status should change accordingly.

If (IsBlank(DDLBDecision.Selected.Value) And (Text(DDLBVehicle.Selected.Value)<>“Aeroplane”)), “Purchase decision not done”, “Ask for ticket Prices”

||

((!IsBlank(DDLBDecision.Selected.Value) And (Text(DDLBVehicle.Selected.Value)<> “Aeroplane”)), “Buy it”, “Status Unknown”

)

I get three overall status and was unable to get forth overall status using above code.

Any suggestions or ideas on modifying or rewriting the code is welcome.

[poweractivate]

@BradAugustene 

I noticed a potential problem in your formula.

It seems to me that there might be an issue with your logic.

You have two conditions separated by an 'OR' operator ('||'), and within each condition,

you're evaluating whether the decision is blank and whether the selected vehicle is not an aeroplane.

Let's revise the formula, making sure that it covers all the cases you want:

If(
    IsBlank(DDLBDecision.Selected.Value) && Text(DDLBVehicle.Selected.Value) <> "Aeroplane", 
    "Purchase decision not done",
    !IsBlank(DDLBDecision.Selected.Value) && Text(DDLBVehicle.Selected.Value) <> "Aeroplane", 
    "Buy it",
    Text(DDLBVehicle.Selected.Value) = "Aeroplane", 
    "Ask for ticket Prices",
    "Status Unknown"
)

In this formula, we're using the If function, which evaluates a series of conditions and returns a value corresponding to the first true condition. Here's what it's doing:

- First, it checks if the decision has not been made (i.e., DDLBDecision is blank) and the vehicle is not an aeroplane. If this is true, it returns "Purchase decision not done".
- If the first condition is not met, it checks if a decision has been made and the vehicle is not an aeroplane. If this is true, it returns "Buy it".
- If neither of the first two conditions is met, it checks if the vehicle is an aeroplane. If this is true, it returns "Ask for ticket Prices".
- If none of the conditions is met, it returns "Status Unknown".

This formula should hopefully cover all your scenarios.

Please try to substitute this formula in your Power App and see if this helps @BradAugustene 

[WarrenBelz · Accepted solution]

Hi @BradAugustene ,

Based on your posted requirements

If(
   DDLBVehicle.Selected.Value = “Aeroplane”,
   If(
      Len(DDLBDecision.Selected.Value) = 0,
      “Status Unknown”,
      “Ask for ticket Prices”
   ),
   If(
      Len(DDLBDecision.Selected.Value) = 0,
      “Purchase decision not done”,
      “Buy it”
   )
)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications)   Visit my blog Practical Power Apps

[BradAugustene]

Hi Warren Belz

Your code snippet works perfectly and code design is very crisp.
THANK YOU  so much for your simple, short and crisp code.

Appreciate your help.

I may need to expand your code further for similar OVERALL STATUS for additional DDLBs.

Further code expansion may includes : DDLB-1 is replaced by other 3 additional DDLB . And DDLB-2 remaining constant.

Any ideas or suggestions for code design for below table is appreciated.

DDLB 1 - Motor Fuel Vehicles	DDLB 2- Decision	Overall Status
AAA	XXX	AX
BBB	YYY	BY
AAA	YYY	AY
BBB	XXX	BZ
DDLB-3- Electric vehicles	DDLB 2 - Decision
AAAEV	XXX	AEV1
BBBEV	YYY	AEV2
AAAEV	YYY	AEV3
BBBEV	XXX	AEV4
DDLB-4-Solar Vehicles	DDLB 2 - Decision
AAASol	XXX	ASol1
BBBSol	YYY	BSol2
AAASol	YYY	ASol3
BBBSol	XXX	BSol4
DDLB-5-Other Vehcles	DDLB 2 - Decision
AAAOth	XXX	AOth1
BBBOth	YYY	BOth2
AAAOth	YYY	COth3
BBBOth	XXX	DOth4