Auto Fill SharePoint List Form Fields using MS PowerApps

This video explain how to auto fill SharePoint List Form fields using MS Power apps. Below is the code to auto fill person field to the current logged-in user when a user open new form to add record.

Code:
{
DisplayName:User().FullName,
Claims:"i:0#.f|membership|" & Lower(User().Email),
Email: User().Email,
Picture:""
}

[Naburazz]

Thank you for taking time to make these great tutorials. I tried to implement this method for a requirement but wasn't successful. Any assistance would be much appreciated.
I have two SharePoint lists and their columns are detailed below.

List name: IDIODB
Columns:
ID = Text field
SysAKA: Text field
SysName: Text field

List name: IDIORequestForm
Columns:
ID = LookUp field
SysAKA = LookUp field
SysName = LookUp field
NewIDIO = Person field


In IDIORequestForm list, If I select an ID, the SysAKA and SysName fields should auto-populate.

[levisublett]

Hello, awesome video! I was wondering what to enter in the formula bar for a title, that will always be the same? Thanks

[teresaagustin]

Thank you for making this helpful video! Would you mind recording one that shows how to automatically populate a text and person field based on what is selected from a drop down menu? Example: when a project number is selected from a drop down down, populate the project name in a text field and the associated project manager in a person field. I haven’t found any other YouTube videos that cover this, so I believe you would be the first.

[golfnutt]

Hello, Thanks for posting this! Very helpful!
Is it possible to make the default for the field Blank or Empty based on a Yes/No field?

[avaniejain]

Thank you for this. I tried to do the same thing but for me, I am not getting the option "Customized forms" while clicking on PowerApps. I can only see "See All Apps". Please suggest

[prashantstar]

Thanks for the info. I hve a question : if I need to update the column in existing excel file using MS Forms.

[projectmanagementmethodolo]

Great! I need to display the department of the user. Could you help me please ? Can only find email and picture

[rockabillyron]

Thank you very much! This is very helpfull. I have one question: I work with lists a lot. I want to auto fill the item as 'Monday a week ago', no matter what today is. Is there an option? Thanks!

[sahilshah]

Great work,
Is there a way I can auto-populate the field based on the answer of previous question, for eg I have a drop down list of names I select one name and his company department, company Id, etc fills automatically in the next field

[danielyong]

Hi amazing video! Have a question here. I have saved files in SharePoint using the following file naming format : yyyy-mm-dd file subject. Any idea how I can auto-populate the field (date) by having SharePoint extract the date from the file name?

[monael-feki]

Hello, amazing video and efforts, but just wanted to ask plz now everything is applied and working on the power apps but whenever I open the Sharepoint again the list doesn’t seem to reflect the changes that ive made. Any suggestions?

[diyachattaraj]

Thank you for making this video but can you please help me with this..If I have a auto populated field in a form how can I enter that default populated value in my final table using patch function in powerapps

[haueproduction]

Nice well explained, is it also possible to pre-fill the data according to the previous data entry ?

[juanpabloacostalopez]

Great video ¡ thanks a lot... I have one question: Is it possible to retrieve data from an excel spreadsheet inside a library ? I know theres a function to export data from a spreadsheet to a Sharepoint list, but I cant find how to retrieve data from a spreadsheet automatically...I want to fill in some rows in the list whenever a user saves a document in a library, for example a co-worker saves a sale receipt inside a library...I would like to retrieve automatically the value of the sale (inside the cell "B10") and to retrieve the person that saved the documen (something similar to User().fullname but for the person that saved the document) thanks a lot again ¡


Edit: I already subscribed

[theroadviper]

Great Video indeed ! But i have one requirement whre i need to autopopulate email field (in my case its now a text field) based on login info ? Can you please guide me here?

[amardeepyaduvanshi]

Hi. Is it possible to show all the names in my organisation in the 'Person Name' drop down and as the user selects any name the 'Email header' populates with the selected Person's mail id ?
If it is possible can you please share the code/steps to do it.

[jeganjeyabaskaran]

Thanks for the video !. Is it possible to do auto populate dropdowns in power Apps ?

[learninghub]

Hi thanks for the video. How can I Prepopulate with the Manager's name for the user ? What will be the code ?

[ahmadyamout]

Dear Mr. Aziz thank you for your videos . If i would like to generate an automative invoice number incremented and it is locked so no one can modify it . How can I do that? please help

[sundrapillay]

Thanks How can you pre -populate field from existing item in SharePoint list with power apps