Skip to main content

Notifications

Power Apps - Microsoft Dataverse
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

 

  • CNT Profile Picture
    CNT 10,919 on at
    Re: Show/Hide a Form's Datacard based on another Datacard, which is a lookup column in Dataverse for Teams

    @GarryPope Glad to help! Have a great day!

  • CU01081947-0 Profile Picture
    CU01081947-0 716 on at
    Re: Show/Hide a Form's Datacard based on another Datacard, which is a lookup column in Dataverse for Teams

    @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.

     

  • Verified answer
    CNT Profile Picture
    CNT 10,919 on at
    Re: Show/Hide a Form's Datacard based on another Datacard, which is a lookup column in Dataverse for Teams

    @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)

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,508

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,839

Leaderboard

Featured topics