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 / Managed filter for Dat...
Power Apps
Answered

Managed filter for Dataverse tables

(0) ShareShare
ReportReport
Posted on by 4
In a production environment that is managed, finding tables is difficult.  In a sandbox, you can use the custom filter and find your tables easily and more importantly, filter out system tables.  Adding a Managed filter next to custom if the environment is managed and if it is of type production would help creators in finding their tables and filter out system tables.  Currently, the only option is choosing all(includes all system tables) and using a search filter.  Please make this change as it should be easy!
Screenshot 2026-02-01 135851.png
I have the same question (0)
  • Verified answer
    WarrenBelz Profile Picture
    155,838 Most Valuable Professional on at
    This is a User Community Forum - a better place for this post would be in Power Apps Ideas.
     
    Please Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider answering Yes to Was this reply helpful? or give it a Like
    Visit my blog
    Practical Power Apps    LinkedIn  
     
     
  • Suggested answer
    VASANTH KUMAR BALMADI Profile Picture
    322 on at

    You’re absolutely right — this is a real usability gap in managed production environments, and it affects almost everyone working seriously with Dataverse.

    What you’re describing isn’t a lack of knowledge or a missed option — it’s simply missing functionality in the maker experience.

    What’s actually happening today

    In sandbox / unmanaged environments, makers benefit from:

    • Custom tables filter

    • Clear separation between:

      • system tables

      • custom tables

    • A manageable table list

    In production + managed environments:

    • The Custom filter is either missing or ineffective

    • Makers are forced to use All

    • System tables flood the list

    • Search becomes the only workaround

    • Discoverability drops sharply as the environment grows

    This is especially painful in tenants with:

    • Dynamics apps installed

    • Industry accelerators

    • Multiple managed solutions

    • Hundreds of system tables

    Why this is a problem (beyond annoyance)

    This isn’t just cosmetic — it has real impact:

    • ❌ Slower development and support work

    • ❌ Higher risk of selecting the wrong table

    • ❌ Harder onboarding for new makers

    • ❌ Poor experience in production support scenarios

    • ❌ Increased reliance on tribal knowledge (“search the schema name”)

    Sandbox productivity ≠ Production productivity, which is backwards.

    Why “search” is not a real solution

    Relying on search alone assumes:

    • you already know the table name

    • you know whether it’s custom or system

    • naming is consistent

    • prefixes are predictable

    In real production environments, none of that is guaranteed.

    Filtering is fundamentally different from searching.

    The feature you’re proposing makes sense

    Adding a Managed / Unmanaged / System filter alongside Custom would immediately solve this.

    For example:

    • ✔ Custom (unmanaged)

    • ✔ Custom (managed)

    • ✔ System

    • ✔ All

    Or even just:

    • ✔ Hide system tables

    • ✔ Show only solution tables

    This would align with how makers actually work in production.

    Important point: this is already solvable technically

    Dataverse already knows:

    • whether a table is system or custom

    • whether it’s managed

    • which solution it belongs to

    This is purely a UX decision, not a platform limitation.

    Current (imperfect) workarounds

    Until Microsoft addresses this, people resort to:

    • remembering schema prefixes

    • exporting solution lists

    • using Advanced Find / solution explorer

    • building in sandbox and “guessing” in prod

    None of these are good UX.

    Where to raise this so it has impact

    This is exactly the kind of feedback Microsoft does act on if it gains traction.

    Power Platform Ideas portal
    https://ideas.powerplatform.microsoft.com

    Suggested title (something like):

    “Add Managed / System table filters in production environments”

    This is not a niche request — it affects:

    • ALM

    • support

    • governance

    • enterprise-scale Dataverse usage

    Bottom line

    You’re correct on all counts:

    • Sandbox has better table discoverability than production

    • Managed environments are unnecessarily hard to navigate

    • Filtering out system tables should be first-class

    • Search is not an adequate replacement

    • A Managed/System filter would significantly improve productivity

    This is a valid, well-justified usability request, not a nice-to-have.

    If Microsoft wants makers to work confidently in production environments, this is one of those small UX changes that would have an outsized positive impact.

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

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Valantis Profile Picture

Valantis 424

#2
WarrenBelz Profile Picture

WarrenBelz 355 Most Valuable Professional

#3
11manish Profile Picture

11manish 290

Last 30 days Overall leaderboard