Hi Everyone, I’m currently building a CRM application using Power Apps connected to an Azure SQL database for my company, which has multiple retail stores. The application is designed with the following access needs: - Sales Table: Each store should only see their own sales data (read-only) - Product Table: Viewable by all stores (read-only) - Customer Table: Stores should be able to search, view, add, and edit customer data - Back Office: Full access to add/edit products and customer data. I’ve seen a lot of great content online that shows how to connect Power Apps to Azure SQL at the developer level, but I haven't come across a clear explanation on how to manage user-level or row-level security once the connection is made at the user level. My questions are: 1. Where should user-level and row-level security be managed — in Power Apps or directly in Azure SQL? 2. If it’s best handled in SQL, what’s the recommended way to create and manage security roles for Power Apps users? I would really appreciate any guidance, especially if anyone has faced a similar use case. Thanks in advance!

We are moving to a much more feature rich community! Join now before we shut this one down! If you have any concerns, you may comment below, or email us at support@superpowerlabs.co 📨 🔴 UPDATE 4:10pm EST -- I just want to reassure everyone you will still have access to anything/everything you've purchased in the past. I'll be sure to have everything in Whop before the cut off date. If you're upset about any of the details or have concerns, just email us at support@superpowerlabs.co and we'll make sure you're taken care of. ➡️ Call to Action: ============================= 1. At least click on the 1st link down below which is 100% FREE. 🆓 2. Comment below! 😋👍 ➡️ Why are we moving? ============================= - Skool costs us $500 every month. - I've created separate Skool communities for different purposes and based on the limitations of Skool. It gets complex and confusing having material spread out all over the place. Each of these communities costs me $99 a month. - Even though I have a lot of content and offerings, the structure needs to be simple and straight forward for you guys. - With the new features in Whop, I can serve you guys better and more efficiently. - Don't worry: if you purchased anything, you will retain access to it, but please join the free option below. ➡️ Stay in by clicking on these links: ============================= 1. FREE - https://whop.com/learn-power-apps/ 2. Insiders Group - https://whop.com/super-power-labs/ (50% off Black Friday Deal) 3. Accelerator Program - https://whop.com/power-performance-accelerator/ (join the waiting list if you're interested) ➡️ Black Friday Offer - 50% OFF ============================= - Limited-time offer lasts until December 3rd at midnight! Normal price is $97/mo. - Discounted price is $47/mo. - Promo Code: ➡️ black_friday_2024 ⬅️ - https://whop.com/checkout/plan_yNLZQnjHdiBP9?d2c=true