I love checking back on the older videos to learn some of the stuff I may have missed or simply, the way you would do it! It's nice to see how the interface of the editor has evolved and how it was "new" to us at the time. Nice video, as usual!
You asked for a business case for a password screen...I want a group of Sales Reps to only have access to their own data, so I want them to log in to a password screen, be verified, and then have their data results filtered by their user name, which is included in all of the database records. So the app would begin with a login screen. - I am finding your videos to be so helpful! Thanks
The business use case as to why I landed on the page was so I can prevent users from going to the edit screens or adding new records without a password. I can now have my viewers and my editors in the same app managed by these password fields. Thanks for the video.
Fantastic vid Shane thank you so much for all your content. I used this as I have 2 screens that I deep link to for different users, when I go to a machine on another pc I want to get to admin. This gives me that ability. Great work
Thank You Shane, this tutorial is really easy to understand, even for the french guy that I am :) I was searching a solution for "SuperUsers Access" and "Administrators Access" Now creating a quality alert app' for my job, with all the options i need ! Thanks again !
Hi thanks Shane. Another great video. Give me more ideas for doing my next front end app. As you mentioned user can access at the backend excel files or etc. Which save location you prefer to share with everyone in the organization? For now I my use my own onedrive and share to everyone. Is there any other public location that you dont need to do the sharing? I try to use sharepoint list but not easy to work with when there's a lot of column involved. And excel file saved on sharepoint cannot be import as data source. Or it did work for you?
Hey Shane and team, as always, you guys present information that is super easy to understand and gives great confidence to us non-IT folks. I have this working fantastically and super proud of myself. I want to take it one step further and make it so that the O365 user will have a specific PIN to log into each of the apps (will be the same PIN for all Apps I've created but unique to the user). I've stored the data in a SQL table, but for some reason, I cannot get it to connect between the name in the O365 label to the PIN stored in SQL. Any hints? Everyone's PIN will be unique, so I can't set it like in this video. Any guidance would be greatly appreciated!
I would look up their correct Pin based on their email address when the app opens and store it in a variable. Then use that variable in the If to see if they got the code correct.
Hey Shane, would it be possible to assign different passwords to different users? I assume a table with the matching user/pass to perform this would be the best way? - if at all possible, of course.
Loved the video. I am going to use the password screen to authorize and pre-identify the user to limit specific data in a drop down box. Should be possible right?
Thanks for the great video. Have a doubt regarding how can i achieve a password reset screen on first login? If i create a module with another username and password not O365 credentials.. Thanks in Advance 😀
I just created my first app and did it SOLELY based off your tutorials. THANK YOU. I have ONE question. I have a form that a Dr completes to perform a chart audit. When he/she is done, the form is submitted and an email is generated to the NP that is being reviewed. However, one NP may have multiple chart audits done in one day. Is there a way to have PowerApps identify the last record and send an email only after that form is complete?
Yes... what i would think about is have the button that sends have some form of an If statement that checks if your criteria has been met. If it has then send it, if not then wait. YOu might also have the Power App just mark everything as done and then at the end of the day have a Flow run to send out the notifications. A couple of ideas.
Great. How do I compare my username and password fields stored in in an excel file with user input in the inputText on a powerapp?? My problem is that I don't know how to extract excel file data.
Hey Shane, great vid... I just want to say that you done design ugly stuff because I have seen worse. I plan to use this for an Issue app I am creating. There are certain features and screens that only the techs should access, and it will use the Office permissions settings upon login. A little complicated yeah but Your vids have been an amazing help Thx.
Hey Shane, thanks for the amazing videos. So I working on a Vacation Request App and I need help figuring out how to display a user's unique information in regards to the amount of vacation days they have. The challenge is displaying this information based on the user that logins into the app. I've tried using nested if statements, patch function, Lookup function, etc, but so far nothing. Please let know if you can help. Any help would be much appreciated.
Hi guys you are doing great , it's make me easy to understand. Can you tell me how to compare table coloum date cell from Excel (table datasource) to text input (powerapp)in 'if' function. Please it my request Suggest next video: login form using Excel datasource with 'if' statement for different navigate screen Thanks a lot.
I'm not clear on something with this one and I've succeeded with all the previous videos. I understand to make the popup group's visibility to be PopUp but it automatically sets it to be Popup for all the controls within and I'm not sure how to resolve this. I've watched that part over and over and tried different things. And when I play the app, it always starts at the pop up group. I'm wondering if I need to change the visibility of the controls that aren't in that group like the add data and view data. They show up as greyed out. Also, when entering the password, nothing happens. I'm a little lost even though I've followed your video as closely as possible.
Hi, We have multiple users and need to have them sign in to power apps to recognize their credentials. How can I use the company credentials or Microsoft 365 user to log in? 16:41
You would have to do a lookup for a match. This video doesn't show it exactly but will help th-cam.com/video/0MB-z9cyFCQ/w-d-xo.html sorry for the slow reply
Hello sir i want to know if i create an app in power automate for example- login app and in the code - navigate(Home) so here i want it to go to my sharepoint site if user entered correct login details. But it wants to create a new screen shows a pathetic text message watever we set. But i want it to open my site! Can we do it?
Hi. Could you please assist me with what you have said above as I cannot determine how to Lookup user().email against user email in a list. When I try to search via person/group the field is not showing up.
@@ShanesCows I watched but i wanted to pick the users from the active directory and give them the access right. Please I have a side issue that i need your help. I am creating staff leave request application but having difficulty creating a flow that can subtract public holidays from the days automatically and show the days requested and alaso calculate the number of days between the two dates (startdate and enddate) Thank You Sir
Hi Faiz. I am sorry you are having issues. Step 1. Insert a text input control. Step 2 set the mode to password. That should be it. Is that not working?
yup .. already insert the text input + set mode to password but still error.. but the "passwordfield" not appear in that formula for the button "let me in"
@t do I compare my username and password fields stored in in an excel file with user input in the inputText on a powerapp?? My problem is that I don't know how to extract excel file data.
i have question ? if we enter button then i nned to see data which i am responsible or which i have created ..can you please tell me how i need to put that
Hi, I want to use Textinput for employee verification. I created a list named Maintenance Employees with all employees names, ID, position, etc. I'm using the following for the button Verify: If(TextInput1.Text='Maintenance Employees'.ID, Reset(TextInput1); Navigate(BrowseScreen_Maint,ScreenTransition.Cover), UpdateContext ({MessageText:"You are not a Maintenance Employee"}) ) It's not working and the error is in the logical test (=), it says "Invalid argument type" Help, please!
Hi Barbara - Sorry you are having issues. WHat I see is you trying to compare text to a column. You need a way to get a unique item from Maitenance Employees. Here is what comes to mind: If(IsEmpty(Lookup(MaintenaceEmployees, ID = TextInput1.Text)), Reset(TextInput1))
how we can encrypt password. i want to call API to authenticate which takes username and password but i want to pass encrypted password. How we can do?
Is not working.... i made this If(Passwordtext.text = "1833", Reset(Passwordtext); UpdateContext({Popup: false}); Navigate('Admin Menu', ScreenTransition.Cover), UpdateContext({ Messagetext: "Incorrect Password, put the correct password"}); Reset(Passwordtext) ); When i analyze the error i get this message Issue Incompatible types for comparison. These types cant be compared: Error, text. We cant evaluate your formula because the values being compared in the formula arent the same type. Location Enter.OnSelect Please help
![เปิดบ้าน นาราเครปกระเทย 1 ไร่ ขายขาดทุนหลัก10ล้าน เอามาใช้หนี้!!! l [Nickynachat]](http://i.ytimg.com/vi/0jz84VFWVP4/mqdefault.jpg)
I love checking back on the older videos to learn some of the stuff I may have missed or simply, the way you would do it! It's nice to see how the interface of the editor has evolved and how it was "new" to us at the time. Nice video, as usual!
Thanks Bob. It is crazy how much it changes.
!.
You asked for a business case for a password screen...I want a group of Sales Reps to only have access to their own data, so I want them to log in to a password screen, be verified, and then have their data results filtered by their user name, which is included in all of the database records. So the app would begin with a login screen. - I am finding your videos to be so helpful! Thanks
Awesome! Thanks for sharing.
The business use case as to why I landed on the page was so I can prevent users from going to the edit screens or adding new records without a password. I can now have my viewers and my editors in the same app managed by these password fields. Thanks for the video.
Glad to help. 😀
Fantastic vid Shane thank you so much for all your content. I used this as I have 2 screens that I deep link to for different users, when I go to a machine on another pc I want to get to admin. This gives me that ability. Great work
Fantastic!
Thank You Shane, this tutorial is really easy to understand, even for the french guy that I am :)
I was searching a solution for "SuperUsers Access" and "Administrators Access"
Now creating a quality alert app' for my job, with all the options i need !
Thanks again !
Glad it helped!
Hi thanks Shane. Another great video. Give me more ideas for doing my next front end app.
As you mentioned user can access at the backend excel files or etc. Which save location you prefer to share with everyone in the organization?
For now I my use my own onedrive and share to everyone. Is there any other public location that you dont need to do the sharing?
I try to use sharepoint list but not easy to work with when there's a lot of column involved. And excel file saved on sharepoint cannot be import as data source. Or it did work for you?
SharePoint, SQL, or CDS. I never use Excel for real apps.
Hey Shane and team, as always, you guys present information that is super easy to understand and gives great confidence to us non-IT folks. I have this working fantastically and super proud of myself. I want to take it one step further and make it so that the O365 user will have a specific PIN to log into each of the apps (will be the same PIN for all Apps I've created but unique to the user). I've stored the data in a SQL table, but for some reason, I cannot get it to connect between the name in the O365 label to the PIN stored in SQL. Any hints? Everyone's PIN will be unique, so I can't set it like in this video. Any guidance would be greatly appreciated!
I would look up their correct Pin based on their email address when the app opens and store it in a variable. Then use that variable in the If to see if they got the code correct.
Hey Shane, would it be possible to assign different passwords to different users?
I assume a table with the matching user/pass to perform this would be the best way? - if at all possible, of course.
Yep. Put them in a list and then lookup the username and password combo. If the record matches they were correct b
@@ShanesCows I like it! I like it a lot. Thank you 😊
Hi Shane, is it possible to implement Single Sign-On Login in PowerApps?
Power Apps always forces you to login with your Office 365 account.
Great video as usual Shane. Thanks for sharing
Thanks for watching!
Aha! I didn't know the text control had a Password mode.
Crazy all the little details hidden in the product. That is why we have so much fun with it.
Loved the video. I am going to use the password screen to authorize and pre-identify the user to limit specific data in a drop down box. Should be possible right?
Yup
Thanks for the great video. Have a doubt regarding how can i achieve a password reset screen on first login? If i create a module with another username and password not O365 credentials.. Thanks in Advance 😀
I just created my first app and did it SOLELY based off your tutorials. THANK YOU. I have ONE question. I have a form that a Dr completes to perform a chart audit. When he/she is done, the form is submitted and an email is generated to the NP that is being reviewed. However, one NP may have multiple chart audits done in one day. Is there a way to have PowerApps identify the last record and send an email only after that form is complete?
Yes... what i would think about is have the button that sends have some form of an If statement that checks if your criteria has been met. If it has then send it, if not then wait. YOu might also have the Power App just mark everything as done and then at the end of the day have a Flow run to send out the notifications. A couple of ideas.
Great. How do I compare my username and password fields stored in in an excel file with user input in the inputText on a powerapp??
My problem is that I don't know how to extract excel file data.
Look into the lookup function for checking the Excel record.
Hey Shane, great vid... I just want to say that you done design ugly stuff because I have seen worse. I plan to use this for an Issue app I am creating. There are certain features and screens that only the techs should access, and it will use the Office permissions settings upon login. A little complicated yeah but Your vids have been an amazing help Thx.
😻😻😻😻
Hey Shane, thanks for the amazing videos. So I working on a Vacation Request App and I need help figuring out how to display a user's unique information in regards to the amount of vacation days they have. The challenge is displaying this information based on the user that logins into the app. I've tried using nested if statements, patch function, Lookup function, etc, but so far nothing. Please let know if you can help. Any help would be much appreciated.
Hi guys you are doing great , it's make me easy to understand.
Can you tell me how to compare table coloum date cell from Excel (table datasource) to text input (powerapp)in 'if' function.
Please it my request Suggest next video: login form using Excel datasource with 'if' statement for different navigate screen
Thanks a lot.
Thank you! It really help me so much.
Glad it helped!
Very Helpful to me to create my First PowerApp Project.
Awesome
@@ShanesCows now 2nd App on progress subject - Visitor Management
I look forward to your videos now! They are so helpful!
Thanks. Glad to hear it because I love making them.
first tell you, I love your videos! I need to make a login screen that checks with office 365 users. Is this possible? how can I do it?
Not possible. Everyone has to have an account to access the app so you already should know who is in the app with the User() function.
I'm not clear on something with this one and I've succeeded with all the previous videos. I understand to make the popup group's visibility to be PopUp but it automatically sets it to be Popup for all the controls within and I'm not sure how to resolve this. I've watched that part over and over and tried different things. And when I play the app, it always starts at the pop up group. I'm wondering if I need to change the visibility of the controls that aren't in that group like the add data and view data. They show up as greyed out. Also, when entering the password, nothing happens. I'm a little lost even though I've followed your video as closely as possible.
I just started working with PowerApps and these videos assisted a lot, so I just wanted to know how to code the "forgot password" radio button. Thanks
Good question. Maybe sent them an email with the password?
Yes, and thanks for replying.
Hope you keep making videos. You are super helpful!
I will. Thanks!
Hi, We have multiple users and need to have them sign in to power apps to recognize their credentials. How can I use the company credentials or Microsoft 365 user to log in? 16:41
You give them the URL of the app and when the open the URL Power Apps will automatically make them login. Nothing special required from you.
what if i want to use a list of email id's as passwords or logins?
thanks
You would have to do a lookup for a match. This video doesn't show it exactly but will help th-cam.com/video/0MB-z9cyFCQ/w-d-xo.html sorry for the slow reply
Hello sir i want to know if i create an app in power automate for example- login app and in the code - navigate(Home) so here i want it to go to my sharepoint site if user entered correct login details. But it wants to create a new screen shows a pathetic text message watever we set. But i want it to open my site! Can we do it?
Any idea about authentication using Azure
Haven't done it.
Would it possible to have different passwords for individual users?
Sure. Put the user email and password in a list. Then check the list vs the user().email
Hi. Could you please assist me with what you have said above as I cannot determine how to Lookup user().email against user email in a list. When I try to search via person/group the field is not showing up.
Thankyou so much!!!!!
No problem 😊
Hi Shane,
If user forgot the password how to update password... In power apps
Thank you. A big help 😃
Awesome 😎
Very great and educative video thanks. Please how can we create user access levels according the login user ids. Thanks a milliom
Try this video th-cam.com/video/0MB-z9cyFCQ/w-d-xo.html
@@ShanesCows Thanks very much. God bless you
@@ShanesCows I watched but i wanted to pick the users from the active directory and give them the access right. Please I have a side issue that i need your help. I am creating staff leave request application but having difficulty creating a flow that can subtract public holidays from the days automatically and show the days requested and alaso calculate the number of days between the two dates (startdate and enddate) Thank You Sir
but why I can't use PasswordField ??? having some error on button??
or have some step I miss before come to this parts ???
need some clarify
Hi Faiz. I am sorry you are having issues. Step 1. Insert a text input control. Step 2 set the mode to password. That should be it. Is that not working?
yup .. already insert the text input + set mode to password but still error.. but the "passwordfield" not appear in that formula for the button "let me in"
@t do I compare my username and password fields stored in in an excel file with user input in the inputText on a powerapp??
My problem is that I don't know how to extract excel file data.
Replied to the other comment 😀
i have question ? if we enter button then i nned to see data which i am responsible or which i have created ..can you please tell me how i need to put that
Try the User() function. I cover it in this video th-cam.com/video/tNKcsuL72ks/w-d-xo.html
Hi @Shane, how did you make the PopUp Group??
Use ctrl to select the controls then right click and choose group
Hi, I want to use Textinput for employee verification. I created a list named Maintenance Employees with all employees names, ID, position, etc. I'm using the following for the button Verify:
If(TextInput1.Text='Maintenance Employees'.ID,
Reset(TextInput1);
Navigate(BrowseScreen_Maint,ScreenTransition.Cover),
UpdateContext
({MessageText:"You are not a Maintenance Employee"})
)
It's not working and the error is in the logical test (=), it says "Invalid argument type"
Help, please!
Hi Barbara - Sorry you are having issues. WHat I see is you trying to compare text to a column. You need a way to get a unique item from Maitenance Employees. Here is what comes to mind:
If(IsEmpty(Lookup(MaintenaceEmployees, ID = TextInput1.Text)), Reset(TextInput1))
It worked!! Thanks!!
I don't understand the point of this when a user has access to the backend data anyway?
There are things you can do to lockdown the back end data. Something like this for example. th-cam.com/video/_Qnz4YeHses/w-d-xo.html
how we can encrypt password. i want to call API to authenticate which takes username and password but i want to pass encrypted password. How we can do?
@shane your videos are awesome. Plz reply to my comment
I don’t think there is a way to encrypt the password. Nothing that I know of. Sorry
@@ShanesCows thanks for your reply but is there any workaround? I dont want to see plain password in the flow api request?
Is not working.... i made this
If(Passwordtext.text = "1833",
Reset(Passwordtext);
UpdateContext({Popup: false});
Navigate('Admin Menu', ScreenTransition.Cover),
UpdateContext({ Messagetext: "Incorrect Password, put the correct password"});
Reset(Passwordtext)
);
When i analyze the error i get this message
Issue
Incompatible types for comparison. These types cant be compared: Error, text.
We cant evaluate your formula because the values being compared in the formula arent the same type.
Location
Enter.OnSelect
Please help