Hello Power Apps community,
I hope you can help please.
I have a Dataverse for Teams table called "Enterprise Platform Team".
It has a child table called "Metrics".
On the "Metrics" table it has a lookup column called "Platform Team" that looks up to the parent table "Enterprise Platform Team".
I am creating a canvas app.
It has a form where I can add data into a record for the "Metrics" table.
On the form I have many columns.
One column is the lookup "Platform Team" column.
I want to be able to hide certain columns depending on the value in the "Platform Team" column.
So if the "Platform Team" datacard value is "Hot" as an example, I want to hide a datacard called "Cost"
I tried to do this on the Visible property of the "Cost" datacard , but can never get the formula right.
Any help would be greatly appreciated. It must be something to do with the column being a lookup.
@RandyHayes hope you don't mind me tagging you in, but you're the man when it comes to forms.
Thanks very much,
Garry
