Power Platform Community Forum Thread Details

So, here I have a situation where the Calculation in the Studio and what the Control actually shows DO NOT MATCH:

I have a Drop-Down, with a semi-complicated formula for the "Items" Property, effectively reducing the available options under certain circumstances:

If I Highlight the Formula in the studio to see the Result - I see what I expect - the Correct List of all available status's:

However, the actual control itself is NOT showing what the result of the formula is:

So the Formula CORRECTLY says that the Items List should be: [New, Awaiting Approval, Submitted, Won, Lost,Approved].

But the Drop-down Control is only showing: [New, Awaiting Approval]

The Formula is:

If(
 (
 Value(DataCardValue14.Text)>=Var_ApprovalThresholdValue // Value over Threshold
 || CountRows(Filter(col_QuoteItems,Left(Title,1)="*"))>0 // Has an Obsolete Product
 || Value(DataCardValue14.Text)=0 // Quote Value = 0
 || IsBlank(First(ComboBox2.SelectedItems)) // No Email Address Selected
 )
 && !Var_isManager, // a Standard User
 If(rec_SelectedQuote.Status.Value ="Approved",
 Filter(Choices(Quotes.Status),Value in ["Approved","Submitted","New"]),
 If(rec_SelectedQuote.Status.Value ="Submitted",
 Filter(Choices(Quotes.Status),Value in ["Won","Lost","New"]),
 Filter(Choices(Quotes.Status),Value in ["Awaiting Approval","New"])
 )
 ),
 Choices(Quotes.Status)
)

I can see in the Studio (by looking at the values of the calculation), that the Condition of the IF statement is definitely FALSE, and is actually showing so in the Formula Bar, but the Items shown in the control is as if the IF statement condition is TRUE.

Anyone have any ideas?

Categories:

Building Power Apps