cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
james_hathaway
Advocate IV
Advocate IV

Dropdown Items Formula not being correctly rendered in the control

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:

 

james_hathaway_0-1646053887893.png

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

james_hathaway_1-1646053960554.png

 

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?

 

 

0 REPLIES 0

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (3,249)