I have a SQL table that has two rows in it which are choice options for a drop-down list in a fairly huge SQL database. I'm also using that table in a Power Apps application I'm creating which is meant to add records to that database. The data type in SQL of the column I'm referencing is varchar.
In the PA application I created a drop-down list which shows the column from the SQL table. In PA it says the the data type is Text. I want some input text fields in PA to be visible or not depending on which value the user chooses in the PA drop-down list.
If they choose "Person", fields for first, middle and last name should appear. If they choose "Organization", one text field will appear for the organization name.
On the "Visible" property of the PAs person text fields I used the formula:
If(drpPartyType.Selected.Value = "Person", true, false)
I would use similar logic if "Organization" was chosen, the other text input field would appear.
drpPartyType is the drop-down in PA.
When I put the formula in, PA it's telling me it doesn't like the word "Value" (it has the red underline).
The message reads:
Name isn't valid. 'Value' isn't recognized. Incompatible types for comparison. These types can't be compared: Error, Text.
I'm not sure if the issue is the word "Value" or what. I've tried a few different solutions but haven't had any luck. Any assistance would be greatly appreciated.
