cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Amira07
Frequent Visitor

Right access permission in power apps

Hi, I have a User page from which I can add users with roles and rights. For example, if I have the organization view right I wouldn't be able to see a certain page from the menu,  if I have the organization modify right as a user I can read edit delete from the organization page. I am not sure how to set those permissions I am using a SQL server. Please help me to find that out. Thank you. 

 

4 REPLIES 4
AhmedSalih
Solution Sage
Solution Sage

@Amira07 , Hello Amira, I would recommend that you share some screenshots and elaborate a little bit more. Are you using PowerApps Canvas Apps, or Pages (Previously known as Portal)? 

 

 

Amira07
Frequent Visitor

I am using a canvas app. I have a menu that displays different pages and a User page from which I can add and set right for the user.  if I am login as User x I have certain rights ( exp edit, delete, update) certain pages and only view certain pages How can I set that permission in power apps? I am using a SQL server.

Amira07
Frequent Visitor

Does anyone have an idea?

@Amira07, Using SQL server connector with PowerApps can be through 4 methods. Two are explicit where users of the application must authenticate to SQL Server with their own explicit credentials, and two are implicit under which users implicitly uses the credentials of the account that the app maker used to connect and authenticate to the data source during while creating the app.

 

For more information: https://docs.microsoft.com/en-us/power-apps/maker/canvas-apps/connections/sql-server-security

 

So, depend on whether you have on-prem SQL or Azure SQL, I would recommend that you authenticate your PowerApps SQL connector as Azure AD Integrated (Azure SQL) or Windows Authentication (non-shared) (On-Prem SQL). Then for your App users, you should have their permissions set on the SQL DB level as needed. 

 

 

Regards,
Ahmed
If my reply helped you, please give a 👍. And if it has solved your issue, please consider Accept it as the Solution to help other members in the community find it more.

Helpful resources

Announcements
Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on August 17, 2022 at 8am PDT.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Users online (1,696)