Skip to main content
Community site session details

Community site session details

Session Id : 51sScdARDrHELG64U1c1yC
Power Apps - Building Power Apps
Answered

can user name in canvas app be auto populated for person column field

Like (0) ShareShare
ReportReport
Posted on 21 May 2024 12:50:35 by 798

Good Morning!

I need to auto populate Inspector(person column name) field based on User Login on canvas app.

(I made the canvas app with my SharePoint List.)

 

  • Verified answer
    MTNK Profile Picture
    798 on 15 Apr 2025 at 14:41:19
    can user name in canvas app be auto populated for person column field
    Thanks everyone for helping. 
    It worked for me!
     
    DefaultSelectedItems
     
    Coalesce(
    Parent.Default,{
    Claims:"i:0#.f|membership|" & Lower(User().Email),
    DisplayName:User().FullName
    })
     
    ____________________
    DisplayMode 
     
    DisplayMode.View
     
    ________________
     
    Items Property
     
    Choices([@'SPlist name'].Column Name)
     
    _________________
     
    DisplayFields
     
    ["DisplayName"]
     
    ______________________
  • MTNK Profile Picture
    798 on 28 May 2024 at 15:02:33
    Re: can user name in canvas app be auto populated for person column field

    @anandm08  It is working.

     

    however in the records for Test Record it is showing something like in image .

    mtsts_0-1717007382739.png

     

  • anandm08 Profile Picture
    1,936 Super User 2024 Season 2 on 22 May 2024 at 05:41:04
    Re: can user name in canvas app be auto populated for person column field
    {
     '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
     DisplayName: User().FullName,
     Claims: "i:0#.f|membership|" & User().Email,
     Email: User().Email
    }

    try this code in the Default property of the dropdown parent control.

  • MTNK Profile Picture
    798 on 21 May 2024 at 13:23:58
    Re: can user name in canvas app be auto populated for person column field

    @anandm08 

     

    I appreciate your kind help.

     

    My connector is Office365Users 

    I tried the code also it did not work.

     

    Can you please review my code -  

     
    Table({Cliams:"i:0#.f|membership|" & User().Email, DisplayName: var_userGivenName, Email:User().Email})
  • anandm08 Profile Picture
    1,936 Super User 2024 Season 2 on 21 May 2024 at 13:05:01
    Re: can user name in canvas app be auto populated for person column field

    Screenshot_20240521_183406.png

    try this and let me know if you face any issue

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 791 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 410

#3
mmbr1606 Profile Picture

mmbr1606 275 Super User 2025 Season 2

Loading complete