Support requested to allow filtering on lookup columns from virtual tables to virtual tables, addressing a current limitation due to foreign key restrictions.

Limitation documented through: Get started with virtual tables (entities) (Microsoft Dataverse) - Power Apps | Microsoft Learn.

The existing constraint that prevents filtering and sorting based on virtual table lookup columns restricts users' ability to effectively manage and analyze data through grids and other UI views. By enabling this functionality, users will be able to streamline their data management processes and retrieve relevant information with greater ease and accuracy.

This functionality would significantly improve the operational efficiency of customers who rely on virtual tables for their complex data structures. Enabling filtering on lookup columns from a virtual table to a virtual table will allow users to quickly locate and analyze specific subsets of data, thereby improving decision-making processes and reducing the time spent on manual data sorting and filtering.

The available workarounds might involve extra configuration and may not be as seamless as direct filtering on lookups, they can provide a temporary solution to improve data accessibility and management. However, the support for this functionality included in the standard solution would enable a better experience through the daily operation with the system.