How can I make a field visibele depending on the choice of a different field?

[Foxman_NL]

Hello,

How can I make a field visibele depending on the choice of a different field? These fields are within a form, linked to a Dataverse table. Using a canvas app, not model driven.

As the user makes the choice on the editable form, the other field should appear or dissapear. The form is not saved at that time, it is for a new row in the database.

The field that determins the visibility of the field is called Pasta?

On the form it is Pasta?_Datacard1

It is a Yes/No datatype, but the choice is made using a dropdown menu, not a toggle.

On the field I want to hide I tried many versions of something like this:

If(!'Pasta?_DataCard1' = true; false; true)   This one does not show a error, but there is no functionality.

or

If('Pasta?'.Selected.Value = "Ja", false, true) This gives a error, .selected and .value are not correct. Or on a different version it says the . is not right.

Any way this could be solved?

[LaurensM · Accepted solution]

Hi @Foxman_NL, 😊

The Yes/No field is a Dataverse choice field - in order to compare this via the equals operator you will need to reference the choice list name. For a Yes/No field this will be similar to 'Pasta? (TableName)' but you can double check this by looking at the Pasta? dropdown Items property, the choice list name will be mentioned within the Choices() function. (you can copy-paste this)

Additionally, since you want to change the visibility based on the current Form selection you will have to reference the dropdown (DataCardValue<Number>). The following structure will need to be written in the Visible property of the Datacard you want to hide / display dynamically:

//Visible property Datacard
//Adjust DatacardValue1 to the correct Pasta? dropdown name & change 'Pasta? (TableName)' to the correct choice list name

!(DatacardValue1.Selected.Value = 'Pasta? (TableName)'.Yes)

//Please note that you may have to use 'Pasta? (TableName)'.Ja instead of .Yes depending on your browser language settings.

If this solves your question, would you be so kind as to accept it as a solution & give it a thumbs up.

Thanks!

[Hasrie]

hi @Foxman_NL 

Multiple @choices datacard with Visible control, sample attached, dropdown/combobox Visible depend on - If(DataCardValue10.Selected.Value = "Production Floor & System", true, false)

[Foxman_NL]

Thanks @LaurensM and @Hasrie ,

Both your answers helped. Mainly the explenation from LaurensM, but Hasrie, the true,false part is important too. Thanks a lot.

I used this formula:

If(DataCardValue1.Selected.Value = 'Pasta? (Polyester artikel)'.Ja;true;false)

The text DataCardValue1.Selected.Value came from the side menu inside the editor; clicking on the datacard that is deciding if the other vield should be visible, then on the side menu clicking on advanced and scrolling down to Update field.

Please note, my formula is set for my Dutch version. So i'm using ; instead of ,  and Ja in English is Yes