Different types of Power Apps users

#powerapps #PowerPlatform #CanvasApps #ModelDriven

In this Power Apps tutorial, I dive into the different ways to get user information. There are four main methods I explore: the user function, Office 365 users, SharePoint person column, and the Dataverse users table. Understanding the differences between these methods and how they can't necessarily be used interchangeably without some work is crucial.

I start by demonstrating how to use the user function to retrieve the email, full name, and image of the current logged-in user. Then, I show how to add the Office 365 users connection and use it to get the display name. Next, I will explain how to use the Dataverse users table and the SharePoint person field to get user information.

One of the challenges I highlight is the case sensitivity problem with email addresses, which can cause issues when trying to match users. I also demonstrate how to patch a SharePoint list and a Dataverse table with user information, emphasizing the need to connect the dots between different types of users.

Whether you're working with SharePoint, Dataverse, or Office 365, this tutorial will help you understand how to handle user information in Power Apps effectively. If you want to learn more about Power Apps and related technologies, don't miss out on this video!
Up your Power Apps Skills Today!

Need some help on something you are working on, contact us!

0:00 Different types of Power Apps users
0:49 User Function
1:10 Office 365 Users
1:51 Dataverse Users
2:47 SharePoint Person Column
5:27 Different ways to get the Email or Mail property
8:17 Connecting the dots between different user types
10:14 Linking Office 365 Users to SharePoint person field
14:41 Linking Office 365 Users to Dataverse User table

PowerApps911

Let's connect on social!

[mrbababo]

There’s a difference between the two emails due to how Microsoft admin Center handles email addresses

Email would be the external facing email where people know
The other is actually called the User Principal Name (UPN) where the users log into

Most companies use a different string for both to prevent anyone from trying to brute forcing it.

Excellent video nonetheless. Always had to guess which one to use to lookup. Was having issues when using power automate to create a share point person column due to this.

[JumpUpJumpUpandPowerPlatform]

Thanks Shane. Love the 'dataverse users gets populated based on blah blah blah' haha.

Ive been pondering writing a blog on what youve gotta do to actually populate users into that table! Another complex users topic!

Keep up the good work!

[TheKermit]

Just catching up on your last couple months of videos bud, this one is incredibly useful! Thanks

[oluwatobipaul]

Thanks. I had a similar issue with the user field few months back. Thanks for explaining in details

[rihabhamila]

Amazing content, as usual...but I miss your intro:"But first here is my

[solota]

Very good tutorial. It canbe confusing topic. Thanks!
Do you know maybe the way to filter users but NOT by name but by other fields, like location, job title, department etc.? This is something many users asked on Internet and lately I also tried to accomplish but failed.

[atehaa]

That is a good topic and great details. Thanks!

[sacc]

Hi! I think that it would be a good idea to make a comparison between SPFx and Power Platform solutions. I've just started using Sharepoint Framework and I've noticed many adventages, but a discussion about this topic could be interesting, when does a platform fit better a requirment 😁

[nicoim]

Hey Shane,
great video as always!
I have a question about one of your old videos where you built a calendar in PowerApps.
I'm a bit late, but I wanted to ask how you managed to make it possible to edit and view the entries afterwards. I'm a student and I'm writing a term paper on this right now and I'm not really getting anywhere :(
Maybe you could help me or make a short video about it. Thanks a lot and keep up the good work!
Greetings Nico

[SimonB]

Hello!
When looking at the table in the powerapps editor, the people fields only show "[Record]" where the video shows the email adresses. The rest of the table (Text and date columns) shows like expected. What might the reason for this be?

[jameshathaway]

Hi Shane,
Do you perhaps also want to talk about the difference between "Full Name", "Fullname" and "DisplayName"...
I have a feeling that the User().FullName is NOT the same as

I think the User() function takes "FirstName LastName", but MyProfileV2 uses the Office 365 "DisplayName"
So if you've manually set an Office 365 User DisplayName to "John J Smith" (To distinguish between 2 "John Smith"'s in the organisation), it will not match the User().Fullname function.

[carlosvelvers]

Hello Shane! I am a huge fan, thank you for all the great content! I have been scrolling through your videos to see if there is a solution to embed an iframe in an App. The closest one I found is the google static map you made a few years ago but I want to use the embed map api instead... Do you have any suggestions?

[paumason]

I had that problem so many times, but the lower function is not delegable, could be?. I think that was de biggest problem

[Morlyst]

Here I was hoping it was a video about different kinds of end users.. How can we understand them??

Anyway, great video Shane!

[paolovr]

Thanks Shane 🙏🙏🙏, how a can check a new login office 365 user check password too on Power App ?
Because table on production sometimes are without Presidium of the operator and I would like the user to reconfirm the user and password after an interruption before continuing, preventing a passing user from using the app with the user's login Previous. Can I check s correct login password?

[nievatiupatrickm.]

Hi Can you help me I made an Data search Engine And I want every data has a Button that bring you to another table and can be edited from time to time

[eyoborelvis]

Hi Sir, do you have a video on parsejson

[fredbarnes]

The dataverse user table confuses me. Why would you expect some dog Walker be in that user table? Isn’t it just a table of people who have used the app?