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

Community site session details

Session Id :
Microsoft Dynamics 365 | Integration, Dataverse...
Answered

Hide columns on a form in a model-driven app

(2) ShareShare
ReportReport
Posted on by 38
I'm building a model-drive app with custom tables, what is the best way to hide columns on a form in a model-driven app based on user responses.
I have the same question (0)
  • Verified answer
    Mansi Soni Profile Picture
    8,776 Super User 2025 Season 2 on at
    Hide columns on a form in a model-driven app
    Hello,

    If you have around 20 columns with different visibility conditions, using Business Rules is still the best approach for managing form-level logic in a model-driven app. While it might seem repetitive, you’ll need to create individual Business Rules for each field that has a unique condition. However, if multiple fields share the same condition, you can group them into a single rule with multiple actions to reduce redundancy.

    Regarding classic workflows, they aren't suitable for controlling field visibility on forms. Workflows run in the background and can't interact with the form’s UI in real-time, so they won’t help with showing or hiding fields based on user responses.

    Business Rules, on the other hand, work directly on the form and respond immediately to user input, making them the most effective and maintainable solution for this use case.

    Regards,
    Mansi Soni
     
  • LA-30040116-0 Profile Picture
    38 on at
    Hide columns on a form in a model-driven app
    I have about 20 columns, and some of them are not dependent on others.
    Should I create individual business rules for each column?
    What are your thoughts on using classic workflows compared to Business Rules?
    I’d really thank you for taking the time to share your insights.
  • Verified answer
    Mansi Soni Profile Picture
    8,776 Super User 2025 Season 2 on at
    Hide columns on a form in a model-driven app
    Hello, 

    As per my understanding, when building a model-driven app using custom tables, the best and most straightforward way to hide columns on a form based on user responses is by using Business Rules. Business Rules offer a no-code solution that allows you to define conditional logic to control field behavior directly within the Power Apps maker portal. This method is especially useful for scenarios where the visibility of one field depends on the value entered in another field on the same form.

    To implement this, you first create a new Business Rule for the relevant table. Within the rule, you set up a condition—for example, if the user selects No in a Yes/No field like Has Discount?. Then, you add an action to the rule to set visibility for another field, such as hiding the “Discount Amount” column when the condition is met. You can apply this logic to multiple fields if needed. After defining the rule, make sure it is scoped to the correct form or all forms, and then activate it.

    Business Rules automatically apply the logic at runtime on the form without requiring any coding, making them an ideal choice for functional consultants and app makers. They also help keep the app easy to maintain and modify, especially when the logic involves simple visibility toggling based on user input.

    Hope this will help you!

    Regards,
    Mansi Soni

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Leaderboard > Microsoft Dynamics 365 | Integration, Dataverse, and general topics

#1
Sahan Hasitha Profile Picture

Sahan Hasitha 225

#2
Abhilash Warrier Profile Picture

Abhilash Warrier 129 Super User 2025 Season 2

#3
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 123 Super User 2025 Season 2

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans