(In)Visible based on result of conditional formula

[IvenSch]

Hey dears,

following problem:

I have a Combobox with a conditional IF formula in. 

Now, I`d like to make another Dropdown field visible or invisible, based on the result of the Combobox.

With the usual DataCardValueXX.Selected.Value = "example" it doesn`t work.

Anybody an idea?

[IvenSch]

Good morning again 🙂

I now changed the DataCardValue5 manually to a table:

["Material / Hardware (Non-R&D)";"Software Licenses / IT Software  (Non-R&D)";"R&D All requirements (D-XXXXXX)";"Services (Non-R&D)";"Other Cost Center related expenses (e.g. trainings, offsite)"]

Problem remains the same.

Any ideal left?

[AmínAA]

Hi there @IvenSch!

It's not quite the same error, since now it is saying that the error is that you're trying to compare a table (DataCardValue2.SelectedItems) with text. So you could now try to use DataCardValue2.Selected.Value / DataCardValue2.Selected.DisplayText!

[IvenSch]

😫

[AmínAA]

I am dumbfounded to be honest . . . I have no Idea whatsoever with why that's happening . . . If you put a label, and point it's texto to DataCardValue2.Selected.Value still gives error, or it works there?

[IvenSch]

Unfortunately, yes...

[AmínAA]

I am literally out of ideas . . . I literally have the same same code as you in my enviroment and it works just fine . .  Just as a Hail Mary, can you try using a smaller table? Something like ["TEST1";"TEST2"] . . .

[IvenSch]

I now added a manual table to items property of DataCardValue2

[ "R&D Project";"Internal Project (I-XXXXXX)";"Cost Center";"Sales Order"]

and OnChange

UpdateContext({varCostCenterVisible: false; varInternalProjectVisible: false; varProjectNameVisible: false; varWBSVisible: false; varSalesOrderVisible: false});; 

Switch(
    DataCardValue2.Selected.Value;"Cost Center";              
     UpdateContext(                                 
        {
            varCostCenterVisible: true;             
            varSalesOrderVisible: false;            
            varInternalProjectVisible : false;
            varProjectNameVisible : false;
            varWBSVisible: false    
        }
        );
    "Internal Project (I-XXXXXX)";
        UpdateContext(
            {
            varCostCenterVisible: false;            
            varSalesOrderVisible: false;
            varInternalProjectVisible: true;
            varProjectNameVisible : false;
            varWBSVisible: false        
            }
            );
    "Sales Order";          
        UpdateContext(
            {
            varCostCenterVisible: false;            
            varSalesOrderVisible: true;             
            varInternalProjectVisible : false;
            varProjectNameVisible : false;
            varWBSVisible: false        
            }
            );
        "R&D Project";          
        UpdateContext(
            {
            varCostCenterVisible: false;            
            varSalesOrderVisible: false;            
            varInternalProjectVisible : false;
            varProjectNameVisible: true;
            varWBSVisible: true         
            }
            )
    

    )

With this it works.

But therefore I loose the functionality of the pre-selection.

[AmínAA]

Can you make a small If Statement, with just some simple comparisons that return one or two things? Also, make sure that the default table, displays a N/A instead of nothing, that may or may not cause some problems. If we build up slowly to the full functionallity, we can find the problem

[IvenSch]

That`s really strange. I know made just one IF statement in DataCardValue2 items property:

If(DataCardValue5.Selected.Value="Material / Hardware (Non-R&D)";
    ["Cost Center"; "Sales Order"; "Internal Project (I-XXXXXX)"];
    []
)

 And again the Textbox isn`t able to give back the value:

[AmínAA]

Try changing the [] for a [Blank()] or either [""]