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

(0) Share

Report

Posted on by MTNK

819 Super User 2025 Season 2

Good morning!

I built canvas app with SharePoint List and added a code to auto populate a person field/column. It is being updating data for my Power app record added however it is adding something like - i:0#.f|membership|abc@xyz.com (adding this with the record added during testing of the app).

Can anyone help to solve it.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

SpongYe 5,715 Super User 2025 Season 2 on at

Like (1)

Report
Copy link

Link copied!
Hi @mtsts

You looking for somehting like this:

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

Please also check this topic: https://powerusers.microsoft.com/t5/Building-Power-Apps/Auto-populate-user-list-when-other-field-is-populated/m-p/2363770

If you have any questions or feedback, please let me know. Have a great day! 😊

-----------------------
PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube]

I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻

Was this reply helpful? Yes No
MTNK 819 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

@SpongYe Thanks much for helping.

Can you please check my formulas here.
I am using Office365Users and my formulas are -
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)

Was this reply helpful? Yes No
Ami K 15,679 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@mtsts - do not raise duplicate posts.

I have wasted time answering your question not knowing someone else is already helping you with the same question on three different threads.

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

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

https://powerusers.microsoft.com/t5/Building-Power-Apps/Auto-populate-person-name-column-error-while-testing-app/m-p/2788355

That time I have just wasted could have been spent on helping someone else.

Please be mindful that community users are also people, who operate under different time zones and are taking their own personal time to help others for free.

Was this reply helpful? Yes No
Verified answer

MTNK 819 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

@SpongYe Thanks much for helping. Appreciated.

(The only issue/error was - my record during testing the app was adding i:0#.f|membership|abc@xyz.com)

I deleted subtitle from gallery. It solved my issue. Rest all working good.

--------------------------------------------------------------------

Here is the link with the whole solution for the topic -

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

Was this reply helpful? Yes No