SPO People field issue office365users

(0) Share

Report

Posted on by Rick_B

Hi team,

Let me explain what is my problem:

I have a SharePoint list with the 'Requested by' column set up as People.

In Power App, I would have a dropdown to which I add to the Default property the following:

 
If(
    Form1.Mode = FormMode.New;
    {
        '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser";
        Claims: "i:0#.f|membership|" & User().Email;
        Department: "";
        DisplayName: User().FullName;
        Email: User().Email;
        JobTitle: "";
        Picture: ""
    };
    ThisItem.'Requested by'
)Theoretically, this should display the logged-in user in that field. Instead, it shows 'INJECT0' and, if I expand it, a series of numbers. Interestingly, when I submit the form, the username does appear in SharePoint, but I can't manage to display it in the app
 
Any help is welcome
Thanks!
Reuben

Categories:

General Questions

PowerApp issue.png

All responses (4)

Answers (1)

Rick_B 14 on at

Like (0)

Report

SPO People field issue office365users

Thanks @Nandit & @mmbr1606 for your replies.

The problem was on Field properties. I didnt have any Field selected, so when adding Display.Name to the field, it perfectly works.

Thank you very much both for your help!
Nandit 1,563 Super User 2025 Season 1 on at

Like (0)

Report

SPO People field issue office365users

Hi Rick_B,

Just following up to see if you got the chance to try out the method I shared.

Kind regards,

Nandit
Suggested answer

Nandit 1,563 Super User 2025 Season 1 on at

Like (1)

Report
SPO People field issue office365users

Hi Rick_B,

I don't think this will work with the Dropdown. What you need is a Combobox with the following properties.

Items:

Choices([@SPList]. 'Requested by')

DefaultSelectedItems

If( Form1.Mode = FormMode.New; { Claims: "i:0#.f|membership|" & Lower(User().Email), Department: "", DisplayName: Office365Users.UserProfile(User().Email).DisplayName, Email: User().Email, JobTitle: "", Picture: "" }; ThisItem.'Requested by' )

The fields property should be set up like this:

It should then populate the control like this:

Hope this helps.

Kind regards,

Nandit

If this answers your query, please mark this response as the answer.
If its helpful, please leave a like. Thanks!
Verified answer

mmbr1606 11,991 Super User 2025 Season 1 on at

Like (1)

Report
SPO People field issue office365users

hey

which properties did u set in the field settings?

click on the input controls and hit edit next to fields.

that should pop up:

i am using this in default of the whole datacard:

If(Form1.Mode=FormMode.New, { Claims: "i:0#.f|membership|" & User().Email, Department: "", DisplayName: User().FullName, Email: User().Email, JobTitle: "", Picture: "" }, ThisItem.Employee )

if my reply helped please mark as verified answer,

cheers