In this video I'll walk you through a canvas app I had to build using SharePoint lists as the backend data source. The app was used to give a coupon that was made available for the company employees by a vendor. Since the coupons were in limited quantity it was a first-come-first-serve basis and hence they wanted a way to automate this process and also keep track of who got what. This involved customized SharePoint list permissions so that users can only see what they need to.
In this video I'll walk you through a real-world scenario of how the app was built originally but it didn't work as planned due to the behavior of the Power Apps permissions. Hence some of the functionality had to be moved to Power Automate.