SQL - BisTek

Creating Azure SQL User

This Tutorial is mainly for PowerApps. When you connect your Power Apps to an azure SQL, you should provide limited access specially on which tables they can make changes. Below is an example of give read access to all tables but restricting the user to only edit certain tables. Step 1: On your Master Database: […]

December 17, 2022 0

Power Apps SQL

SQL: Unpivoting Tables

Unpivoting table might be a great way to create filters in PowerApps. Store you r Unpivot it using this code: Store that code to a view to easily retrieve it from your PowerApps.

December 10, 2022

Menu

Category: SQL

Creating Azure SQL User

SQL: Unpivoting Tables