hi @arpan_mehetre,
Check out this blog by Carlos, should have all the answers you need.
Specifically, the person column section as follows;
Person columns
The idea for setting defaults in Person is similar to the other column types, but for person you need to specify one field that uniquely identifies the user within the Office 365 (and Active Directory) tenant that hosts the SharePoint list - you can have two people with the same name, so that should not be an option. What is used in this case is the 'Claims' property of the person object, which has a not-very-user-friendly format. I've found that the best way to figure out the value that you need to use is to add a label control whose Text property shows the value of that Claims for the selected person:
This format shown above is common for most Person objects in SharePoint, so if you want to set the logged in user as the default value for a Person column, you would use the following expression:
If(
EditForm1.Mode = FormMode.New,
{
DisplayName: myself.FullName,
Claims: "i:0#.f|membership|" & myself.Email
},
Parent.Default)Where myself is defined in the OnVisible property of the screen (or in the OnStart property of the app) as
Set(myself, User())
Notice that there are a few domains where the value of User().Email does not correspond to the user's e-mail (in tenants where the e-mail and the UPN are different), so if this is your case, you can use the Office 365 Users connection with the MyProfileV2 function.
Another issue to be aware: some Person objects also support the usage of groups:
In this case, the common pattern of creating the Claims value based on the e-mail will likely not work, so you'll need to see what is the claims for the group you want to set as a default selection (for example, using the technique shown above to find the pattern) to get the value that is needed for the Claims property.
For Person columns with multiple selection the process is similar, but you need to use a table instead of a single record. If you want to set the default value for the user and their manager, then you can use the Office 365 Users connector to retrieve it: in the initialization (screen's OnVisible or app's OnStart) you'd have this expression:
Set(myself, Office365Users.MyProfileV2());
Set(manager, Office365Users.Manager(myself.id))
And on the DefaultSelectedItems for the combo box control, you can use this expression:
If(
EditForm1.Mode = FormMode.New,
Filter(
Table(
{
DisplayName: myself.displayName,
Claims: "i:0#.f|membership|" & myself.mail
},
{
DisplayName: manager.DisplayName,
Claims: "i:0#.f|membership|" & manager.Mail
}),
Not(IsBlank(DisplayName))),
Parent.Default)The Filter that wraps the Table function is needed in case you have a person with no manager (such as the CEO), and you don't want them to see a selection that is empty.
Hope this helps, and kudos to Carlos for a great blog!
RT
