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

How to extend standard tables for specific lines of business

Like (0) ShareShare
ReportReport
Posted on 31 Jul 2023 13:14:42 by 173

I am new to Dataverse and what is possible, so after some guidance.

 

We are looking to use the Case table as a base and then, for each line of business, want to add specific additional columns that only make sense for them.

 

I was thinking that would be an easy task but it seems not possible. Is it true that if we want to use the Case table (or any for that matter) that we would need to add all the columns required across all lines of business to the original table?

 

I was sort of hoping there was standard behaviour that allowed you to create a new table using a specific table as a template?

 

How do others handle this scenario where multiple business units have almost identical requirements except for a couple of additional columns?

Categories:
I have the same question (0)
  • MarioRing Profile Picture
    541 Super User 2024 Season 1 on 31 Jul 2023 at 19:52:35
    Re: How to extend standard tables for specific lines of business

    An alternative solution is to use the same table of Cases, the same single form, where you put all required fields required by all departments.

     

    Then you create a new drop-down field "Case Type" with values like "A", "B", "C" and so on (of course use your own naming).

     

    Next, you add a business rule to the form, like:


    IF "Case Type" == "A" then show all the fields related to this type of case and hide all the fields which are not

    ELSE IF "Case Type" == "B" then show all the fields related to this type of case and hide all the fields which are not (and so on)...

     

    Then you create additional views for case, like "All Open A-Type Cases", where you put only relevant columns.  

  • Verified answer
    gulshankhurana Profile Picture
    1,395 Moderator on 31 Jul 2023 at 14:58:49
    Re: How to extend standard tables for specific lines of business

    Hi

     

    The base 'case' remains the same with all the fields. You can differentiate by using different forms with relevant fields/columns for different areas and enabling security role based access to those forms. The same could be done for the views (although security roles based access doesn't apply to views). You could create custom model driven apps for the BUs and, in the app designer, you can control which forms and views they'd have access to. You can also control which security roles would have access to which app.

     

    I hope this information helps. Please give it a thumbs up if you like it and please accept it as a solution if it helps resolve your issue.

     

    Kind regards

    Gulshan

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…

MS.Ragavendar – Community Spotlight

We are honored to recognize Ragavendar Swaminatha Subramanian as our September…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 936 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 375 Super User 2025 Season 2

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 330 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Loading complete