web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Show/Hide a Form's Dat...
Power Apps
Answered

Show/Hide a Form's Datacard based on another Datacard, which is a lookup column in Dataverse for Teams

(0) ShareShare
ReportReport
Posted on by 716

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

 

I have the same question (0)
  • Verified answer
    CNT Profile Picture
    10,921 Super User 2024 Season 1 on at

    @GarryPope Try this (please replace control & column names as required),

     

    If(PlatformTeamComboBox.Selected.'Column Name'=LookUp('Enterprise Platform Team', 'Column Name'="Hot").'Column Name', Disabled, Edit)
  • CU01081947-0 Profile Picture
    716 on at

    @CNT , woohoo! That worked great. I just had to swap out Disabled, Edit with true, false.

    Thanks so much for your quick reply and great answer.

     

  • CNT Profile Picture
    10,921 Super User 2024 Season 1 on at

    @GarryPope Glad to help! Have a great day!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
wolenberg_ Profile Picture

wolenberg_ 119 Super User 2026 Season 1

#2
WarrenBelz Profile Picture

WarrenBelz 107 Most Valuable Professional

#3
Haque Profile Picture

Haque 103

Last 30 days Overall leaderboard