[New post] How to show Dataverse security role based screen in Canvas app

soundharya subhash posted: " We have to get the security roles of logged in user, and store in the collection of the app to reuse it across the app and to avoid multiple request to Dataverse To get the security roles of logged in user, write the below Fx function ClearCol" Respond to this post by replying above this line New post on Power Platform Learning How to show Dataverse security role based screen in Canvas app by soundharya subhash We have to get the security roles of logged in user, and store in the collection of the app to reuse it across the app and to avoid multiple request to Dataverse To get the security roles of logged in user, write the below Fx function ClearCollect(UserRoles, (LookUp(Users,domainname = User().Email).'Security Roles (systemuserroles_association)').Name) We have to add this function on the app start, here User().Email gives logged in email address based on that get the security roles associated to the user Click on App and Run On Start to see the collection Now that collection is available in the app, we can use it to validate the required security role If(IsBlank(LookUp(UserRoles,Name="Basic User")),Navigate(ErrorScreen),Navigate(HomeScreen)) If the 'Basic user' is present in User Roles collection then Navigate to Home Screen else Navigate to Error Screen Hope its helpful..! This free site is ad-supported. Learn more ​ soundharya subhash | August 13, 2021 at 8:11 am | Tags: Canvas Apps, dataverse, power apps, security role | Categories: power apps, Security, security role | URL: https://wp.me/p9QrTS-jE Comment    See all comments    Like Unsubscribe to no longer receive posts from Power Platform Learning. Change your email settings at Manage Subscriptions. Trouble clicking? Copy and paste this URL into your browser: https://soundharyasubhash.wordpress.com/2021/08/13/how-to-show-dataverse-security-role-based-screen-in-canvas-app/ Thanks for flying with WordPress.com