Skip to main content
Community site session details

Community site session details

Session Id : KJRCuCIkRl3/ZgUuILJ8Gd
Power Apps - Building Power Apps
Answered

How to auto populate fields

Like (0) ShareShare
ReportReport
Posted on 31 Aug 2020 16:32:21 by 38

Hi All,

 

I have a created a share point list and from there I have created a default Power App. 

That form contains some fields like "Signum", "First Name", "Last Name", "Line manager", "Email ID" etc....

 

Now I want as soon as user fill "Signum" details than rest of fields should auto filled by importing information from office 365 account.

 

can anybody help me out.

  • Verified answer
    v-xida-msft Profile Picture
    on 02 Sep 2020 at 02:49:21
    Re: How to auto populate fields

    Hi @Negi1984 ,

    Could you please share a bit more about the "Signum"? Could you please share a sample format about it?

    Do you mean that the "Signum" is included in the email address of a user?

     

    If the "Signum" is included in the email address of a user, and the "Signum" is unique for each user. Regarding the needs that you mentioned, I think the Office 365 Users connector could achieve your needs.

     

    Within your Edit form, set the Default property of the First Name field Text Input Box to following:

    First(
     Split(
     First(Office365Users.SearchUserV2({searchTerm: SignumTextInputBox.Text, top:999}).value).DisplayName, 
     " "
     )
     ).Result

    Set the Default property of the Last Name field Text Input Box to following:

    Last(
     Split(
     First(Office365Users.SearchUserV2({searchTerm: SignumTextInputBox.Text, top:999}).value).DisplayName, 
     " "
     )
     ).Result

    Set the Default property of the Email field Text Input Box to following:

    First(Office365Users.SearchUserV2({searchTerm: SignumTextInputBox.Text, top:999}).value).Mail

    Set the Default property of the Manager field Text Input box to following:

    Office365Users.ManagerV2(First(Office365Users.SearchUserV2({searchTerm: SignumTextInputBox.Text, top:999}).value).Mail).displayName

     

    Please try above solution, then check if the issue is solved.

     

    Regards,

  • Negi1984 Profile Picture
    38 on 31 Aug 2020 at 21:03:32
    Re: How to auto populate fields

    Hi Randy,

     

    I am basic user of Power App. Could you please share some screen shot , which functions I need to use to autopopulate fields ?

    "Signum" field is tagged to each email ID. suppose so if we search any user than we can use Signum in email or skype or Team chat. 

  • RandyHayes Profile Picture
    76,287 Super User 2024 Season 1 on 31 Aug 2020 at 17:02:37
    Re: How to auto populate fields

    @Negi1984 

    You will need to change the Default property of the form fields you want to set.

     

    However, the question is - how does signum relate to an Office365 User?

     

     

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

Announcing our 2025 Season 2 Super Users!

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

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!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 791 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 410 Super User 2025 Season 2

#3
mmbr1606 Profile Picture

mmbr1606 275 Super User 2025 Season 2

Loading complete