How to Create Login page in PowerApps using Excel and SharePoint | Step by Step

Подписаться 6 тыс.

Просмотров 54 тыс.

50% 1

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 RU-vid 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

Опубликовано:

20 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 72

@maheshchandrabhatt4289 Год назад

I have started learning MS PowerApps from RU-vid and this is the first video which have cleared my doubts about connections, validations and statements. Thanks for this unmatched video!!!

@ProductivityCentralChannel Год назад

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 😀

@neigevirgilio855 Год назад

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!

@ProductivityCentralChannel Год назад

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 😀

@crystallava5002 Год назад

a PowerApps video on how to use facial recognition, and hoz to use a phone's camera, would be amazing!

@indian8108 2 года назад

Amazing video new few more videos on the power apps 🔥

@ProductivityCentralChannel 2 года назад

Thank you so much! What kind of video of power Apps would you like to see ?

@folashadeolaitan6222 Год назад

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

@ProductivityCentralChannel Год назад

Sure will add this topic to the list of future videos list.

@majettetv Год назад

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?

@bahmamadoutalibe2471 9 месяцев назад

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?

@roxxroxxman 2 года назад

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!

@ProductivityCentralChannel Год назад

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

@emmanuellegoff2331 4 месяца назад

Very good and clear video; thank you.

@ProductivityCentralChannel 4 месяца назад

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

@imotumbokanaka4157 Год назад

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

@moisestatis5418 Год назад

Great video, thanks.

@ProductivityCentralChannel Год назад

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 😀

@sumitghugharwal2150 2 года назад

Thank you fro your video :)

@ProductivityCentralChannel 2 года назад

Thank you for watching!

@AngieLim-hr4mh Месяц назад

Thanks for a great sharing. And besides this, any for login based on Windows login and password?

@giftsefike3085 Год назад

For security purposes, between excel and share point which one is recommended?

@zakariyyabashir8806 Год назад

Hello, Kindly develop an assigned task tracker system with power apps, please.

@syazwansharani8907 Год назад

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!

@giftsefike3085 Год назад

Was this answered?

@pablik01 2 года назад

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)

@vt9769 Год назад

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 ?

@adventureDad1976 Год назад

Do you have to use sharepoint or excel? Could you create a table in a solution for this?

@gametillgrave44 Год назад

Can it navigate to sharepoint site ? Instead of just a screen in power app

@smbasha 2 года назад

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 ..

@ProductivityCentralChannel 2 года назад

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.

@dw1develoweb593 Год назад

How would it be with the sql Server ?

@jeanrichemond8652 Год назад

Very good Video. I can you guys help me, I tried the same code , but don't work for me. what I should change ?

@Emmaxson 3 месяца назад

@ProductivityCentralChannel does this mean the user has to login twice? First using Microsoft PowerApps Login (OAuth) And then in-app login? Correct?

@Land0fAli Год назад

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.

@osamaasif9601 Год назад

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.

@briannawatkins2981 2 года назад

In the backend (excel or sharepoint) does it show when a user successfully logged in and what they did?

@ProductivityCentralChannel 2 года назад

Unfortunately currently that feature is not available. May be in the future.

@furykhim 2 года назад

Hi, I want to integrate our Employee Microsoft Passwords in the Login page. How can I make it happen? Thanks!

@ProductivityCentralChannel 2 года назад

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

@sailochanar3546 Год назад

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.

@PiyushKumar-tv6dr 2 года назад

How can we reset password and Username values like you did through sharepoint but how to do the exact same thing for excel?

@ProductivityCentralChannel 2 года назад

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 😀

@biswajeetmishra345 2 года назад

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.

@rajagnanashekar4643 2 года назад

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

@ProductivityCentralChannel 2 года назад

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 😀

@avi7352 2 года назад

@@ProductivityCentralChannel hi there, was that video added in the playlist, if yes then which one is it?

@seeyou5797 6 месяцев назад

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?

@PhilomineNolasco Год назад

If I'm using a dataverse, is it possible to use the login?

@ProductivityCentralChannel Год назад

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 😀

@victormainza8660 2 года назад

requesting for a project about a helpdesk app with dashboards.

@ProductivityCentralChannel Год назад

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

@averalrenoy3532 2 года назад

Awsome video but what does the title word mean?

@victormainza8660 2 года назад

requesting for a project about a ticketing app with dashboards.

@ProductivityCentralChannel Год назад

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

@swamilekkala4420 Год назад

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

@Kapildevkushwah 2 года назад

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 ❤️

@ProductivityCentralChannel 2 года назад

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 😀

@tojeng76 2 года назад

How to set only admin user can access all screen and other user can access only certain screens after login successfully?

@ProductivityCentralChannel 2 года назад

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.

@Shady-uc3mr 2 месяца назад

i get error when using .Text values it says it cant recognise them

@anelemthembu7012 2 года назад

Where do I get power apps testing

@ProductivityCentralChannel 2 года назад

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/

@jayskylark8692 2 года назад

Can you put a forgot button on the login page and have the user reset their password

@ProductivityCentralChannel 2 года назад

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!

@tharu7783 Год назад

plz send login code

@apuapustaja2063 Год назад

awsome video , subb'd

@ProductivityCentralChannel Год назад

Thank you for watching! Don't forget to like, hit the bell notifications icon to be notified first of any future helpful videos 😀

@apuapustaja2063 Год назад

@@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!

@pritambagchi5350 Год назад

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

@adnanemouwakkat5272 Год назад

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

@adnanemouwakkat5272 Год назад

THE CORRECT SYNTAX AFTER UPDATE If( !IsBlank(LookUp('ADMIN HOME PAGE'; Title = TextInput2.Text && PASSWORD = TextInput1.Text)); Navigate(HOME); Navigate(Screen2) )