PowerApps User Function and intro to Office 365 User connector 

i just wasted an hour trying to figure out why one of my permissions wasn't working and after an hour of tinkering i knew it was the case sensitivity issue. God i am so grateful i saw your video a long time ago. I would have wasted even more time. You are the biggest life saver Shane

Shane you just saved me hours and the need to annoy my IT group. Thanks!!!!

Nicely done Shane!! You mentioned that the content was a bit random...I don't know...but I do know that showing logged in user data in forms is a request in 50% or more of the forms I build in InfoPath and now in PowerApps. So I found this video uber helpful.

Hi, Shane. Thank you so much for sharing your knowledge. It has been so beneficial to me learning PowerApps and troubleshooting inherited apps.

Short or long videos, your tutorials are always helpful. :)

Great tutorial! And awesome tidbits on using labels in the development / troubleshooting process!

Thanks again Shane. Great video. Keep them coming :)

Shane John You are the best you just healed my headache now Thanks

I like the new way you point at "Those Guys!"

This video was so much helpful. Thank you Shane...Keep them coming :)

This was great, not random at all, needing it for Office environment

Very Top this video! I loved the idea of the Sum you did at the IF .... I love it when you teach us to think

Nicely explained;Thank you for sharing the information shane🙂

Hey Shane, could you remind me why it why it is better to use the 365 connector to pull back the image vs the user() connection? I can see that one was successful but the other wasn't. Thanks.

I am too late to this video! Thank you so much for sharing this function.

Hi Shane! Thanks, as always, for your great help! I'd like to use the O365 User connection in a repeating table where I have to add the names of multiple people who participated in an event. Any particular advice or heads-up you might have on that -- other than is provided in your repeating tables videos?

Yes my dog has his own browser too LOL (in reference to @10:27) But seriously, your videos are bomb!

This is very cool stuff. I'm not having any trouble getting info for the logged-on user. I’m working on what I thought would be a simple app: Employees nominate colleagues for awards. The person doing the nominating must fill out a Word template that gets attached to a SharePoint list. The only thing I want the nominator to do is select the name of the nominee from a People column and attach the Word file. I have a simple PowerApp that works fine. Then I want PowerApps (or Flow?) to: 1. Find and update the nominator’s department in the SharePoint list. The nominator is the currently logged-in user. 2. Find and update the nominee’s department and manager in the SharePoint list. The nominee is chosen from a SharePoint People column that's in the PowerApp form. 3. Send email to various people, including the nominee’s manager. Teach me, oh wise one.

Great summary on the functionality! Is there a way to capture the User() when records are written? Perhaps using entities? This would be useful in a use case for using a sql server to capture various tenants data - want to segregate by user and perhaps group via AD.

Thank you. Great Video!

Thanks for the videos! This was not a random one like you said :). I have a question, is there a way to do impersonation in PowerApps? This is to test my app as if I was a particular user. In your video, you have access to Chewy's account so it was straightforward :) but I don't have access to other users' accounts. I'll try when my data is ready, but could I temporarily set the User().Email value to my test subject's email address when the app loads or is there a more elegant way to do it?

Great Vid Shane, I have a question. You mentioned having an allowed list but through SharePoint, is there a way you can reference a list in Powerapps, Maybe by using a collection?

Thank you this have been very helpful

Hello Shane, one more nice video, Thanks for sharing! I have a related question to this. In these examples you have used a "Text Label" to add the UserName/Email/etc. But suppose i want to add the values to a People/Group Column (from SP List) then how to add it? The reason, i want to to send emails to the user hence i need a People Column. Thanks in advance.

Thanks Shane, really useful.

These videos are very helpful. Wondering how to set a default value for a field based on other fields. Say a "DisplayName" field based on first name and last name combined. Can the field still be editable? I tried using Set to create the combined value and setting the Default of the field to that variable, but it doesn't seem to work.

Great video again Shane. How would you check if a user is a member of a specific group in Office 365 so that you can hide or show items instead of having to specify the users individually?

Hey Shane, thanks for the video so I have a question: 1. In my form I want to have a button which is only visible to managers and it should show all the approved pending or rejected requests that they have until day.I want them to see what forms they have approved or rejected and the users shouldn't see that. SQL is my backend and I have a Column "ManagerAlias" -they approve the form through flow but can you help me get an idea on this please or a video? Most on the security , permissions in PowerApps?

Shane You Rock! I have a quick question, I'm trying to filter a gallery list (SharePoint) using the O365User connector, only showing items in the list where the people picker email and delegates match. Here's the line Filter(' Goals (POC)', User().Email = 'Name'.Email & delegates = ' Name'.Email) But it's not working properly. Any thoughts? (BTW delegates is a variable which stores the values returned from the screen load. Set(delegates,Office365Users.DirectReports(User().Email))

Love your videos. I read through all the comments, ok skimmed through, and didn't find the question I need answered, so probably I am just missing something here. From the video it looks like you are explaining how to get Current Users information. I have a "Choice" field that the submitter chooses who the software is going to be bought for and it may not be the current user. When the requestor/submitter selects the name in Choice field, I need to pull in email, Location, etc. Do you have info on that?

Hi Shane, can we use sharepoint user group here for filtering and conditioning based on group Thanks

Really cool things. Thanks a ton

Great video Shane, is it possible to have a form where you can autofill user details using the User function but also have a hidden/admin option where specific people can manually fill in user details in a blank form or edit any of the existing forms?

Shane, thank you again for your useful information. I had a question. You showed how to set a control visible based on an email address in your example. Can I set a control based on a SharePoint field, say, user().email = "created by"? I tried, but I had problem to make it working.

Hey @Shane..very helpful video mate. On the same lines, how to verify with office 365, the windows password entered by a user is correct or not for authentication/login

Hi Shane, love your video！ I learned so much from you. May I ask one question, I am modifing the 'Meeting Capture' app from MS team to a meeting room agenda application. We issued each meeting room a MS account and book rooms via outlook. But only met one question that the application can only refresh when loading, I wish to set a refresh button. But the grammer of 'refresh' is 'refresh (datasouce). But I cannot just 'refresh (office365outlook). What should I do? Thank you.

Hi Shane, Love your videos. I want to be able to show a tutorial video to first-time users only. Once the person logs in a second time and beyond the video is not shown to them. Is this possible?

This video helped. Thanks

Hi Shane, you mentioned in the video that you could have a list of users that can be made to have access to the button. how would i go about setting this up? Thanks

Hi Shane! As usual enjoyed the vedio. Thanks a lot. I was wondering, how can we use the same hiding and showing controls features based on if the current user belongs to a certain sharepoint user group?

Can we show both parent and child records in same form ?

Perfect learning material for PowerApps. Easy to understand. Just have a doubt. Have you tried to connect the PowerApp with SharePoint site and get the list of SharePoint groups which the current logged in user belongs too? I am planning to hide the elements on the app based on user permission or groups. Thanks a million!

Hi Shane Young thanks for your tutorial! I already followed your example but may I ask why when I search, not all office365 users is there? I mean only few i can search. is there other code so that I can search all office365 users?

Great 👍🏻👍🏻

Another great video. In my organisation, we use distribution lists to manage RLS in Power BI. Is there some way we could implement the same in powerapps (e.g. if you are in the "administrator" distribution list, you get access to the "edit" button?

Hi Shane, can you do a tutorial on how to add the "User().FullName" to a sharepoint list with a checkbox?..To be used as an accept button.

Is there a way to use FLOW or PowerApps to find the first vice president by looking at the person that is using PowerApps & go up the organization chain to find the first VP of that person's group/organization.

Really enjoyed the videos Shane and have just finished the first 24. I am wondering if you have any suggestions for the following problem: I have a SharePoint list of a couple of hundred users, including a People Picker column and several which I update using a Flow to extract information from the Office 365 user profile - which I guess I don't need if I use the Office365User connector from PowerApps. Now from within PowerApps I open the list in a data table which is then filtered and which I would like to be able to export. Ideally I would be able to hit a button and Excel would be launched with the contents of the filtered data table displayed in a new worksheet. If this can't easily be achieved then an export of the table contents to a CSV would be great. Any advice would be greatly appreciated. Thanks :-)

Very useful videos Can you make a video where we have to shot records only pertaining to logged in user ? Thanks

Hello Shane I enjoy a lot your videos, Question about this video: how can I then send the user to a next Screen?

Hi Shane, can you do one for Cascading drop-down along with SharePoint list?

Hi Shane thank you for the video. I'm struggling with something, a user who's a personal assistant captures on the behalf of the manager, in my case I don't need the information of the capturer but the information of the selected user in the form. I have a control that read O365 user but I'm struggling with using this control to read the rest of the fields. Please help. Thank you.

Very helpful videos and well explained!! Thank you very much! I am trying to make an APP linked to SQL (on azure or local sqlexpress) with two tables (one to many relationship) for example a phone book where one contact can have many numbers. Would be really great if you could make a video on how to do this... I can submit to individual tables but not to relational.. Thank you for your help in advance

Shane young I've follow your channel, thanks to create those content, is there tutorial to create menu drawer like using hamburger menu?

Great video - thanks again. Question: How does PowerApps handle security and access to data? Meaning, do I have to grant access rights to my source data (Excel, SharePoint, SQL Database)? Or can there be an abstraction layer between the users you share the App with and the data sources their have to use? I notice that when using On-premise Data Gateway and Connection, the user don't need to have access to the source SQL database.

What if we want to manage user profiles in and excel in onedrive??? How we will validate users from excel data???

is possible to to create a user outside the office 365 organization? or staff can register an account to be able to login to powerapps for user screen?

How do you fix an email filter if the email address is first name last initial before the @?

Do you have any video that shows how to add a new user and password into a Sharepoint list?

Hi Shane, i have a dropdown on my form with 365 users email addresses. If I select one i would then like to populate a textbox with their displayName, I have tried using Office365Users.SearchUser({searchTerm:ddMail.SelectedText).Displayname but the text box error says it returns a record not a text. What am i doing wrong please?

Hi Shane, I am trying to add the searchUser() Office365Users function for one of the fields in Sharepoint list form that's customised in PowerApps. Could you please suggest if this is even possible?

Can you please make a video on Auto filling the values from SharePoint list to the specific field ( without using Office365Users). It will be helpful

this is awesome thank you so much for this. by any chance could you show how to extract the email address using the FROM id of the email? ive embedded the powerapps link into a email, so the user click on the link and it opens powerapps, but now i need to pull the email address of the person whom sent the email and not the one receiving it?... if that makes sense..

hello Shane, I have used Office365Users.UserPhoto(User().Email). Am getting error Office365user.Userphoto failed error { code : 502 ...............} If i use user().Image am getting sample image not my profile picture. I have uploaded my profile pic in office 365 two days ago.

i dont understand where to put this condition to navigate to the screen when approver is current user f(DataCardValue3.Selected.Email=User().Email,Navigate(ApproverScreen,ScreenTransition.None),Navigate(FormScreen1,ScreenTransition.None)) 1. sharepointIntegration 2. FormScreen1 where first screen come first here i want to navigate approver form when DataCardValue3.Selected.Email=User().Email is true otherwise come to the first screen Thanks in Advance

Hi Shane I displayed current user name in a text box, I have one manager field, how can I display current user manager name? Got the solution from your another video Thank you Soooo much

Is there a way to pull groups of user or even if the security groups has email address to be able to show or hide the button.

is it possible to pull an user's AD username from some connector? didn't find it in office365users.

Hi Shane, I tried to match the Department with a dropdown control using: Office365Users.UserProfileV2(User().Email)).department = Dropdown3.Selected This gets an error: "Invalid argument type", highlighting in red the "=" sign. Then with this other code: If(Office365Users.UserProfileV2(varUserEmail).department = Dropdown3.Selected, "Yeay", "Buh") I get the following error: "Warning: expecting a true of false value". But this code alone gets the Department with no problem: Office365Users.UserProfileV2(User().Email).department Could you please share your thoughts on what is wrong with me? Thanks

Very good stuff as usual. But still I am waiting for my SQL app with a parent and child relationship with lookups & cascading dropdownd

Hi Shane, this is an awesome video. It truly saved me time trying to figure out how to get the intelleSense to show the Office365….. It works perfectly when I complete my power app but doesn’t work with another office 365 accounts. My button has the following code Onselect. Office365.SendEmail(DataCardValue1.Text,"You have completed survey for ",Dept_Dropdown.Selected.Value) The DataCardValue1 is User().Email and it’s fetching the info correctly. Please advice at your convenience. Thank you!

Hi Shane, probably you are my only hope I'm having a canvas app working with dataverse tables. In the app i hav a simple Gallery to search and select between peopl from the "Contact" table, and everything is fine, only the Photo pushes back a strange error: Although i've implemented an error handling in case of no profile photo uploaded, and it works because it shows a dummy photo : "nophoto", it writes me back that the parameter is not good or no resource found...etc the short line on the photo is the following If(Office365Users.UserPhotoMetadata(ThisItem.Email).HasPhoto=true ,Office365Users.UserPhotoV2(ThisItem.Email) ,nophoto) do you have any idea, suggestion? I'm getting crazy thx in advance!!!!!

Thanks

Let say I have fileds 1.- User selected in people picker (Jonh Doe) 2.- Yes/No filed. I want the filed YES/NO to be show only of the user using the app is the one selected in te filed 1. I´ve tried this, but did not work: If(DataCardValue63.SelectedItems.Email = Lower(User().Email), true, false)

Can we create a Gallery with data source as Office 365 user ?

Shane young could you plz help to get the current user manager and his manager manager details

i want to use email id of my group members as access to the app. how can i do that? any input? thanks a bunch

Thankyou 😭

good video , i want to ask how to create more then one user full name or user email name? thanks

How to show could you please give some clue or if possible plz do one demo video on that also. Plz..

if possible creating a page with login and password of user in office 365?

Based on Power app login credentials can we pull the user details in an excel, working on a project have some more queries too, how can I contact u

Can we see the entire table where User.Fullname() is working? Where is it stored?

Hello Shane, how can i get my managers email address? using office 365 user?

¿How works with several users?

current_users_lower = [user.lower() for user in current_users] Sir can't understand this code Full exercise current_users = ['eric', 'willie', 'admin', 'erin', 'Ever'] new_users = ['sarah', 'Willie', 'PHIL', 'ever', 'Iona'] current_users_lower = [user.lower() for user in current_users] for new_user in new_users: if new_user.lower() in current_users_lower: print("Sorry " + new_user + ", that name is taken.") else: print("Great, " + new_user + " is still available.")

Hi Shane - thank you for the great video. What is the syntax for the User function if wanting to make the button visible to more than one user? I really just need to have a single data card visible for about 5 users.

is it possible to get all users images with Office365 connector onto a gallery?