Unanswered

How to autofill a form and save to SP list

(0) Share

Report

Posted on by suridup1

Hi Community,

In my powerapp, I have added a combo box and created a people picker. I have connected this to O365. This is working fine, however, I now want to prepopulate a form with the info from the O365 user account. For example: John Williams has selected his name from the people picker, then just below on the app there is a "registration form" with Title, Name, Lastname, Email. I want these fields to automatically populate once he selects his name on the people picker. Then it must be saved under a sharepoint list I already created.

How can I achieve this? Screenshot 2022-02-25 152116.png

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

JR-BejeweledOne 5,836 Moderator on at

Like (0)

Report
Copy link

Link copied!

Is your expectation that people will only be selecting their own names?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi

Not sure if this is what you want but I did it like this:
Create a dropdown and in the Item property I put Office365Users.SearchUser(), in the Value option choose DisplayName:
Now for each field you can put the Dropdown value in the default and choose what type of variable you want to populate with:

Was this reply helpful? Yes No
suridup1 4 on at

Like (0)

Report
Copy link

Link copied!

Yes, a person will only choose his/her own name.

Was this reply helpful? Yes No
BCBuizer 22,638 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @suridup1,

In case this is about the user of the app, may I suggest you use the Office 365 Users connector:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/connections/connection-office365-users

If you add that connector to your app, you can set the default values in your form as per below:

First Name: Office365Users.MyProfile().GivenName
Surname: Office365Users.MyProfile().Surname
Email: Office365Users.MyProfile().Mail

Was this reply helpful? Yes No
JR-BejeweledOne 5,836 Moderator on at

Like (0)

Report
Copy link

Link copied!
A person doesn't need to select their name from the list. You can use the Office365Users.MyProfileV2() connector to auto-populate the fields with the information for the current user.

Like this:

FirstName Text Property:

Office365Users.MyProfileV2().givenname

Surname Text Property:

Office365Users.MyProfileV2().surname

Email Text Property:

Office365Users.MyProfileV2().mail

Was this reply helpful? Yes No