Create Login Page in PowerApps using SharePoint List

In this PowerApps tutorial, we will see how to create a login page or screen in PowerApps using SharePoint List.

Here I have created a SharePoint Online List where I am storing user credentials. When User login, it will check, the user exists or not from the SharePoint List. If the user exists then it will successfully log in and redirect to the home page otherwise, it will show an error.

PowerApps Create Login Screen or Page

Now, let us see how to create a login screen or page in PowerApps from SharePoint Online list.

Step 1: Login to the PowerApps -> Create a canvas app using Mobile or tablet view.

Step 2: In your New screen, design a page with below controls

• User Name (Textbox)
• Password (TextBox)
• Login ( Button )

Step 3: Next go to your SharePoint Online site and create a SharePoint list with two-column called User ID and Password.

Step 4: Next go to your PowerApps -> Data -> Connection -> New connection with SharePoint -> Add that list under your connection.

Step 5: Next click on the Login button and go to the onSelect property and dd the below formula.

If(CountRows(Filter('User Login',And(txtUserName.Text=Title,txtPassword.Text=Password)))=1,Navigate(Dashboard,None),Notify("Incorrect Login Details",NotificationType.Error));
Reset(txtUserName);
Reset(txtPassword);

Step 6: Next I am entering the correct user id and password so I am able to redirect to the dashboard page after successful login.

Step 7: Here I am entering wrong user id and password so I am getting error as below.

This is all about to Login Control in PowerApps using SharePoint List.

You may like following PowerApps tutorials:

• How to create a custom calendar in PowerApps
• PowerApps Chart Control – How to Use
• How to build multilingual apps in PowerApps
• Automatically scroll Gallery control in PowerApps
• PowerApps notify function- How to use
• Share PowerApps to external users or guest users

In this tutorial, we learned how to create a login screen or page in PowerApps using SharePoint Online list.