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 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.
Rajkiran is currently working as a SharePoint Consultant in India . Rajkiran having 7+ years of experience in Microsoft Technologies such as SharePoint 2019/2016/2013/2010, MOSS 2007,WSS 3.0, Migration, Asp.Net, C#.Net, Sql Server, Ajax, jQuery etc.He is C#Corner MVP (2 Times).