PowerApps Sort & Filter A Data Table (When SQL Is Your Source) – Bansal Blogs – Dynamics 365, PowerApps, Microsoft Flows, Power BI

I have rendered a SQL view in PowerApps in the form of a data table. The table itself, is pretty simple – four columns and multiple rows. The business problem I wanted to fix was as follows:

1. I only want to show rows where a count of a field for a given row is equal to zero
2. I want to filter the table using a toggle switch (the filter is on a “type” field that I have created)
3. I want…