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:

Building Power Apps

PowerApp issue.png

I have the same question (1)

All responses (5)

Answers (1)

Verified answer

mmbr1606 14,605 Super User 2025 Season 2 on at

Like (1)

Report
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

Was this reply helpful? Yes No
Suggested answer

Nandit 1,568 Moderator on at

Like (1)

Report
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!

Was this reply helpful? Yes No
Nandit 1,568 Moderator on at

Like (0)

Report

Hi Rick_B,

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

Kind regards,

Nandit

Was this reply helpful? Yes No
Rick_B 14 on at

Like (0)

Report

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!

1 people found this reply helpful.

Was this reply helpful? Yes No
ProPosia 54 on at

Like (0)

Report
The solution provided by @mmbr1606 , might work for user who is using classic combobox control. Because classic combobox control has
DisplayFields = ["DisplayName"] SearchFields = ["DisplayName","Email"]

But If I am using Modern Form which has modern combo box then I do not get those peroperties to select.

I am seeing this for the person column fetched from SharePoint list.
Can anyone suggest something to show display name in modern combo box here,

Thanks

Was this reply helpful? Yes No