How to Create Login page in PowerApps using Excel and SharePoint | Step by Step
Vložit
- čas přidán 28. 06. 2024
- In this video you will learn How to Create Login Screen in PowerApps. You will also learn How to connect Authentication in PowerApps to SharePoint list and also Excel.
⏱ Timestamps:
0:00 - Intro
0:58 - How to Build Login Screen in power apps
7:15 - How to connect Authentication in PowerApps to SharePoint list
14:50 - How to connect Authentication in PowerApps to Excel
Learn how to Build Cloud Inventory Management App with PowerApps and SharePoint:
• Build Cloud Inventory ...
Canva: bit.ly/3daqNWk
Learn to Build Inventory Management App using Powerapps and Excel: • Build an Inventory Man...
Learn to Build Site Inspection App using Powerapps and SharePoint: • Build Site Inspection ...
Learn to Automate Invoice Processing using Power AUTOMATE and SharePoint: • Power AUTOMATE Tutorial
Learn to Build a Dashboard in Power BI: • Power BI Beginner Tuto...
Learn to Build a Dashboard in Excel: • Excel Dashboard Beginn...
Get started with Power Apps if you don't have Office Account:
Microsoft 365 Business Standard: bit.ly/3HIFYEb
Microsoft 365 Apps for Business: bit.ly/3FxhJHh
Website: www.productivitycentral.ca/
Medium: / officesuitessimplified
✅ Subscribe now: / @productivitycentralch...
My Favorite CZcams SEO Tool: bit.ly/3oe96f4
⚖ As full disclosure, I use affiliate links above. Purchasing through these links gives me a small commission to support videos on this channel -- the price to you is the same.
#loginscreen #powerapps #powerappstutorial
I have started learning MS PowerApps from CZcams and this is the first video which have cleared my doubts about connections, validations and statements. Thanks for this unmatched video!!!
Thank you for watching! Don't forget to like, subscribe and hit the bell notifications icon to be notified first of any future helpful videos 😀
a PowerApps video on how to use facial recognition, and hoz to use a phone's camera, would be amazing!
you should have way more subscribers than you have right now, I always come back to your videos because I know I'm going to find something very helpful, also you're a great teacher and it's so easy to follow along with you on your videos. Keep the good work up, you're a lifesaver!
Thank you for the kind words. Appreciate that! Don't forget to like, subscribe and hit the bell notifications icon to be notified first of any future helpful videos 😀
Very good and clear video; thank you.
Thank you for watching! Don't forget to like, subscribe and hit the bell notifications icon to be notified first of any future helpful videos 😀 Do comment if you want a specific topic video to be made in the future
Amazing video new few more videos on the power apps 🔥
Thank you so much! What kind of video of power Apps would you like to see ?
Great video, thanks.
Thank you for watching! Don't forget to like, subscribe and hit the bell notifications icon to be notified first of any future helpful videos 😀
Thank you fro your video :)
Thank you for watching!
Thank you for the wonderful video. I am a first timer on your channel and i'm already getting so much value. I would like to see a video on password reset and registration for new users. Thank you
Sure will add this topic to the list of future videos list.
Thank you for this!!!!! I need to build an app that multiple people can enter daily data like time and attendance, equipment inventory management, and other data. Example:two administrative assistants log in and enter everyone present and the equipment that they are using at the same time. The dashboard then shows the percent of staff present and equipment used. How do I create this kind of daily data entry app? And where should the data be stored?
Thanks for a great sharing. And besides this, any for login based on Windows login and password?
Incredible video and explanation, this has helped me so much! If you are still accepting content requests, I wanted to see if you could show this process using a combo box. I would like to know how to navigate to different screens with the access based on the department an employee is in, using data from a sharepoint list. The combo box is comprised of data from a sharepoint list that has a column for employee names and another column for their respective department. For example "Kevin" works as an inspector, when Kevin's name is selected from the combo box, the app should be able to navigate to a screen to start or edit an inspection form. If "Robert" is a manager, and Robert's name is selected from the combo box, the app should navigate to a screen listing the history of inspection forms submitted. I would really appreciate this, thank you!
Thank you for watching! Don't forget to like, subscribe and hit the bell notifications icon to be notified first of any future helpful videos 😀
Thank you for the suggestion. Interesting topic. Will add it to the list of future videos
Bonjour, C'est très bien vos cours. well done. I want to know how to make a form like forms with phone. there are not way to create p.App forms for desktop like microsoft access forms. can we able to create general menu for multiple forms from more Excel files?
great video, if they create a record, will it the created by having the user1 name or the username assigned to the license in power apps or user 1 will be different license in powerapps
For security purposes, between excel and share point which one is recommended?
@ProductivityCentralChannel does this mean the user has to login twice?
First using Microsoft PowerApps Login (OAuth)
And then in-app login?
Correct?
I dont know why but for me it always moves to the screen with access denied, even though the entered data is correct (excel tabel)
Amazing video it help me lot, one doubt how to reset or change password if user forgot the password ...so, please make a video it's help me alot ..pls ..
Happy to hear that. Thank you for watching. Dont forget to like and subscribe.
In this case user sends the request to Admin to reset the password and Admin can change it directly in the list or excel file.
Hi Great video, just one thing right now in this solution if we enter any username and password which is present in the Admin Home Page sharepoint list it logs in successfully. How can we match the corresponding username and passwords ?
Hello, Kindly develop an assigned task tracker system with power apps, please.
hi, is it possible to define different user groups based on login? For example, if an admin logs in they will see a more complete homepage while if a normal user logs in they will see a filtered homepage with minor functions. Thanks!
Was this answered?
Can it navigate to sharepoint site ? Instead of just a screen in power app
Hi, i have a problem with my login page.
If I use the version with Sharepoint, I have the problem that everyone needs access, i.e. at least Read rights, to the Sharepoint list and then the login no longer makes sense because everyone can see the list with the passwords. Do you have a solution for this?
Do you have to use sharepoint or excel? Could you create a table in a solution for this?
Very good Video. I can you guys help me, I tried the same code , but don't work for me. what I should change ?
How would it be with the sql Server ?
The application currently pulls all the data into the App then it does a lookup. Is there any other way to retrieve only one row for validation like we do use SQL where clause.
No i not like the vedio infact I love the vedio,,,, I just started to learn powerapps but not able to learn anything but come across this vedio and now I am motivated thanks buddy ❤️
Thank you for watching! Appreciate the kind words. Don't forget to like, subscribe and hit the bell notifications icon to be notified first of any future helpful videos 😀
Is it possible to create the login page for access to a SharePoint page? And if so, can it check for paid memberships? I’d like to only have paid members to access my SharePoint site.
how to connect database ,I did'nt found SharePoint website to create n connect data to login page. please can u share link or any appropriate suggestion.
i get error when using .Text values it says it cant recognise them
How to create an app which will take username (check unique username) and password (2 fields to ensure passwords match) and create a new record in Excel.
In the backend (excel or sharepoint) does it show when a user successfully logged in and what they did?
Unfortunately currently that feature is not available. May be in the future.
Awsome video but what does the title word mean?
Hi... i have created power app. i want user to login the app using their PKI card or mailid and password from our office365 group...pls provide the video link for this.. Thanks in advance
requesting for a project about a ticketing
app with dashboards.
Thank you for watching! Don't forget to like, subscribe and hit the bell notifications icon to be notified first of any future helpful videos 😀
Will add this topic to the list of future videos
requesting for a project about a helpdesk app with dashboards.
Thank you for watching! Don't forget to like, subscribe and hit the bell notifications icon to be notified first of any future helpful videos 😀
Will add this topic to the list of future videos
How can we reset password and Username values like you did through sharepoint but how to do the exact same thing for excel?
As shown in the end of the video, I explain the process for excel. Just change the corresponding password in the excel sheet and it will be reset right away. Hope this helps!
Thank you for watching! Don't forget to like, subscribe and hit the bell notifications icon to be notified first of any future helpful videos 😀
I wanted to create app for my team members to update their daily productivity count in excel which is saved in share drive. Each team member have separate file. App needs to navigate to respective file based on login credentials. Can you show some example. Thanks in advance
Sure will add it to the list of future videos. Thank you for watching! Don't forget to like, subscribe and hit the bell notifications icon to be notified first of any future helpful videos 😀
@@ProductivityCentralChannel hi there, was that video added in the playlist, if yes then which one is it?
Hi, I want to integrate our Employee Microsoft Passwords in the Login page. How can I make it happen? Thanks!
Thank you for watching! Don't forget to like, subscribe and hit the bell notifications icon to be notified first of any future helpful videos 😀
Unfortunately that functionality is not available fully yet. If it does I will test it out and let you know
If I'm using a dataverse, is it possible to use the login?
Yes you can. Thank you for watching! Don't forget to like, subscribe and hit the bell notifications icon to be notified first of any future helpful videos 😀
How to set only admin user can access all screen and other user can access only certain screens after login successfully?
Just set admin users to SharePoint list as shown in the video and other users can directed to for example only Dashboard screen.
Just duplicate the Dashboard screen and remove back navigation from it.
And you are all set.
Hope it helps.
Can you put a forgot button on the login page and have the user reset their password
Thank you for watching! Don't forget to like, subscribe and hit the bell notifications icon to be notified first of any future helpful videos 😀
Thank you for the ide. Will add it to the list of new features for future videos!
awsome video , subb'd
Thank you for watching! Don't forget to like, hit the bell notifications icon to be notified first of any future helpful videos 😀
@@ProductivityCentralChannel
already did.
Bro do you have a tele whatsapp or anything i can contact you through?
I'm a Computer engineering student, making an App right now, any help will be MUCH appreciated.
Xoxo!
Where do I get power apps testing
Thank you for watching! Don't forget to like, subscribe and hit the bell notifications icon to be notified first of any future helpful videos 😀
You can sign up with your work email and start using their trail version:
powerapps.microsoft.com/en-us/
plz send login code
If(IsBlank(LookUp('Power App Test', Title=TextInput1.Text And Password=TextInput2.Text),Navigate(Screen2) ;
Reset(TextInput1);
Reset(TextInput2);
This command is not works for me kindly help
If(
IsBlank(
LookUp(
'ADMIN HOME PAGE';
Title = TextInput1.Text && PASSWORD = TextInput2.Text
)
);
Navigate(Screen2);
Reset(TextInput1); Reset(TextInput2)
)
VERIVT THE CAPITALE LETTRE AND YOUR DB AND YOUR INPUT
THE CORRECT SYNTAX AFTER UPDATE
If(
!IsBlank(LookUp('ADMIN HOME PAGE'; Title = TextInput2.Text && PASSWORD = TextInput1.Text));
Navigate(HOME);
Navigate(Screen2)
)