How to Create Login page in PowerApps using SharePoint

[Rahman1005]

A login screen acts as a barrier between the content of your application and unauthorized users.

with the help of logging screen, you can have control on access and sensitive information and maintain integrity of application by making users to authenticate them.

Let’s get started with creating a login screen in PowerApps.

Step 1: Create a New App

Log in to PowerApps and navigate to the 'Apps' section.

Click on 'Create an app' and choose the 'Canvas app from blank' option.

Step 2: Design the User Interface

Once the new app is created, you can open the app using PowerApps Studio.

Design the login screen interface by adding two input fields for ‘Email id and ‘Password along with a ‘Login’ and ‘Register’ buttons.

You can add two text labels to text input boxes as shown in below screen.

Step 3: Connect to Data Source

Go to the ‘View’ tab and click on ‘Data sources’ à Add data and search for SharePoint, then click on Add a connection as shown in below screens.

Once connection is added you can able to find data source.

Step 4: Validate User Credentials

Double-click on the ‘Login’ button to open the formula bar.

Use the Lookup function to check if the entered username and password exist in your data source. The formula might look like:

If(!IsBlank(LookUp(EmployeeList, Email= TextInput1.Text And Password=TextInput2.Text).Title),Navigate(View_Screen_1),Navigate(Failed_Screen));

Reset(TextInput1);

Reset(TextInput2);

Step 5: Handle Navigation

If the credentials are valid, navigate user to your app main screen else navigate user to error scree.

 Login error screen :

Login successfully:

Step 9: Publish and Share

Once testing is complete, publish your app.

Hope this article help!

[TheFlowHawk]

But also, storing these passwords in a SharePoint list where they cannot be encrypted is not a good idea. Why not just use the sharing and security of the Power App itself? The security and access of the tools within the app should be managed at the environment level, app level, or through a security group rather than in the interface layer.

[happyume]

Thanks for sharing however it appears that you are storing passwords in SharePoint List as plain text while passwords must always be stored in an encrypted format.

Also will you users will have read access to all rows in the SharePoint List with passwords stored as plain text? If yes, then they will be able to read passwords of all other users too.

You may want to rethink the system design from data privacy and cybersecurity perspective.

[josh_1999]

This is a serious cyber risk and doesn't seem to be well architected.

If you need login control, use the microsoft account assigned to the individual.

If it is access control within the system, use security roles, or sharepoints equivalent - there should be no reason for this.

It is insecure and bloated.