News and Announcements icon

Power Platform CommunityForums Power Apps - Building Power Apps Auto populate Person C...

Power Apps - Building Power Apps

Answered

Auto populate Person Column(based on user login) in canvas app error

Like (0) Share

Report

Report

Posted on 3 Jun 2024 15:14:20 by MTNK

798 Super User 2025 Season 2

I am using an EditForm control
The Inspector People field in your SharePoint list is configured to single-select
The Items property of that ComboBox control inside the DataCard for the Inspector field contains something along the lines of:

I did two test Test 3 and Test 0044. Please look into that.

Update Property

DataCardValue2.Selected

DisplayMode

Parent.DisplayMode

DefaultSelectedItems

Coalesce(

Parent.Default,

{

Claims: "i:0#.f|membership|" & User().Email,

Department: "",

DisplayName: User().FullName,

Email: User().Email,

JobTitle: "",

Picture: ""

}

)

DisplayFields

["DisplayName"]

SearchFields

["DisplayName","Email","Picture"]

Items

Choices([@'Walk Through Inspection Checklist 2024'].Inspector)

I did two test Test 3 and Test 0044.

Test 3 - Does not show Inspector name in SharePoint(added image for reference).

Test 0044 - Does show Inspector name in SharePoint, also showing error in Power apps records(added image for reference).

What could be the error.

Update Property

DataCardValue2.Selected

DisplayMode

Parent.DisplayMode

DefaultSelectedItems

Coalesce(

Parent.Default,

{

Claims: "i:0#.f|membership|" & User().Email,

Department: "",

DisplayName: User().FullName,

Email: User().Email,

JobTitle: "",

Picture: ""

}

)

DisplayFields

["DisplayName"]

SearchFields

["DisplayName","Email","Picture"]

Items

Choices([@'Walk Through Inspection Checklist 2024'].Inspector)

Categories:

Connecting to Data

All responses Img

All responses (5)

Answers Img

Answers (1)

Verified answer

Ami K 15,665 Super User 2024 Season 1 on 04 Jun 2024 at 19:54:20

Like (1)

Report

Re: Auto populate Person Column(based on user login) in canvas app error

FYI @Cr1t - duplicate poster

https://powerusers.microsoft.com/t5/Building-Power-Apps/Auto-populate-Person-Column-based-on-user-login-in-canvas-app/m-p/2787724

https://powerusers.microsoft.com/t5/Building-Power-Apps/Auto-populate-Person-Column-based-on-user-lo...

https://powerusers.microsoft.com/t5/Building-Power-Apps/Auto-populate-person-name-column-error-while...
MTNK 798 Super User 2025 Season 2 on 04 Jun 2024 at 15:47:59

Like (0)

Report

Re: Auto populate Person Column(based on user login) in canvas app error

@Cr1t I tried the person column menthod.

It gives me same error in the records(added image as reference) while i am testing the app.
Cr1t 555 on 04 Jun 2024 at 15:29:31

Like (0)

Report
Re: Auto populate Person Column(based on user login) in canvas app error

@mtsts

Could you please provide me more info so i can help you better? Is it a Person column or have you used a combobox connected to office 365 connector?

If it is a person column please follow these steps:
Items property:

Choices([@'Walk Through Inspection Checklist 2024'].Inspector)

Default property:

{ '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser", DisplayName: User().FullName, Claims: "i:0#.f|membership|" & Lower(User().Email), Department: "", Email: User().Email, JobTitle: "", Picture: "" }

DefaultSelectedItems:

{ '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser", DisplayName:User().FullName, Claims:"i:0#.f|membership|" & Lower(User().Email), Department:"", Email:User().Email, JobTitle:"", Picture:"" }

DisplayFields:

["DisplayName"]

If you are using office 365 connector for combobox then please follow the below steps:
Items property of combobox:

Office365Users.SearchUserV2( { searchTerm: yourcombobox.SearchText, top: 50, isSearchTermRequired: false } )

DisplayFields property:

["DisplayName","Mail"]

SearchFields property:

["DisplayName","Mail"]

Update property of the people picker card:

{ '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser", Claims: "i:0#.f|membership|"&yourcombobox.Selected.Mail, Department: "", DisplayName: yourcombobox.Selected.DisplayName, Email: yourcombobox.Selected.Mail, JobTitle: "", Picture: "" }

Please let me know if this works for you.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
MTNK 798 Super User 2025 Season 2 on 03 Jun 2024 at 15:42:01

Like (0)

Report

Re: Auto populate Person Column(based on user login) in canvas app error

@Cr1t Thanks much for helping.

I am using Office365Users as a connector.
Cr1t 555 on 03 Jun 2024 at 15:36:00

Like (0)

Report
Re: Auto populate Person Column(based on user login) in canvas app error

@mtsts

I have create a sharepoint list with 2 columns Text and Submitted by,

Select the people picker datacard and set the Default and DefaultSelectedItems property as

{ '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser", DisplayName: User().FullName, Claims: "i:0#.f|membership|" & Lower(User().Email), Department: "", Email: User().Email, JobTitle: "", Picture: "" }

The person column should display the user name

No the right hand side click edit on fields .

Please set the primary text and search field to DisplayName.

Save and preview the app.

Please let me know if this works for you.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.