Skip to main content

Notifications

Power Apps - Building Power Apps
Answered

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

(0) ShareShare
ReportReport
Posted on by 272

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.

 

mtsts_2-1717504698726.png

 

 

 

 

 

 

 

 

 

  • Verified answer
    FnuMeenu Profile Picture
    FnuMeenu 272 on at
    Re: Auto populate Person Column(based on user login) in canvas app record error

    @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

     

     

  • Ami K Profile Picture
    Ami K 15,655 on at
    Re: Auto populate Person Column(based on user login) in canvas app record error

    @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.

  • FnuMeenu Profile Picture
    FnuMeenu 272 on at
    Re: Auto populate Person Column(based on user login) in canvas app record error

    @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)

     

  • SpongYe Profile Picture
    SpongYe 5,411 on at
    Re: Auto populate Person Column(based on user login) in canvas app record error

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

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,580

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,909

Leaderboard