In this article we will demonstrate how to use conditional logic to hide and show a question based on the answer to a SharePoint drop-down menu. In our example, we have a drop-down menu that contains a list of countries from an Excel Online document. If the chosen country is Australia we need to display a textbox to enter an Australian Business Number (ABN).
From the image above we can see that each column of the data source is stored in its own field under the countries object. Therefore in our conditional formula we need to reference down to the specific column/field as show below.
show = date['countries']['Countries] === 'Australia'
Simply open the component settings for the field you want to hide/show, navigate to the conditional tab and write an expression in the Advanced Conditions setting.