Pre-populate Fields in PowerApps 

I cannot thank you enough for this video. You saved me in a time of need. You have a clear and succinct style that makes it easier to understand. Thank you April!

Once again, I STAN your succinct and incredibly informative videos! Lol...The setting that "current user" variable tip is so helpful because we have a huge user-base and performance will be an issue. Keep that brilliance shining for us all!

Thank you April! After watching your video I realized I left a flaw in one of the forms I customized. I'm glad I was enlightened

Hi April, One additional clear, straight to the point and very informative video. I love it and was able to finish the v2 of an app to report occupational health and safety risks. Thanks a lot!

Thank you April. Follow up question: Do you have an example on setting a Managed Metadata field from a parameter?

Thank you so much, April. You have explained the process of getting the current logged in user in a very clean and simple manner. This method worked like a charm in one of my lists but does not work in a second list in the same SP site. I get an error saying 'Invalid argument type(Table). Expecting a record value instead'. Both lists (and people columns) are exactly the same. any thoughts why the code works in the first list but not in the second ?

Thank you April! This is what I needed!

I'm trying to have a rich text field pull from the previous entry as the default value for the data card when creating a new form - is this possible?

Hi APril, Thanks for this video... How do you populate multiple users in that people field? Lets say you want to populate the field with 3 users instead of 1 as shown in your example.

Great tutorial, April. I tried to implement this method for a requirement but wasn't successful. 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 corresponding values for SysAKA and SysName fields should auto-populated. Any assistance would be much appreciated.

Thank for the video! Can we autofill a users manager and still keep the drop down? Any tips?

Hello Dunnam! I need guidance on using delegable functions to popularize a combo box. I need to extract data from a List Sharepoint, column ID2 (numeric), to fill a combobox, I am using this function: ClearCollect (arrID; Filter (Cadastro_Inspecao; ID2> = IDInicial && ID2

Thanks for such a useful video , Knowledge is the best tool a person can possess & its best donation also , In our country , knowledges is considered as a form of light .

Thanks April... Nice and very informative video... i love powerapps

I have a scenario where the User A fills 3 forms in 3 different screens and one of the field is a people picker field and its something like : Qa reviwer . once the details are filled all this data sits in SP list and trigger and email to the QA reviewer . The main thing comes here : QA reviewer needs to click the link and go to screen number 4 and 5 where he needs to perform his duties and should have only view access to entire record filled by the user . the 3 screen filled by user A should be view mode and screen 4 and 5 in edit . What i the best way to achieve this? how would i prepopulate the items from SP ? in powerapps ? please advice

Great Content April! Quick question: I have two columns numerical data type. I want to have the third column in the gallery to immediately show the multiplication of the two columns prior to saving. How can i do that?

Hi April, great video thank you for sharing! I would like to default a field to be an employee's manager. How do I set the person/group field to be someone other than the current user, specifically a manager? Thank you!

Hi, I had a question maybe you can solve it. If I have an excel file as the data source and I create an app. When the user adds his id he must be able to see only his data(specific fields, not all the fields say if I have 5 fields name, surname, id, course, class, and school. when the user inputs his id he would see only his name and surname ) a. How can I do this using powerapps? It would be great if you teach us this.

Hi can we prepopulate the multiple people picker column

Hi April, Thank you for this so pragmatic tuturial... as usual ;-) I would just have a "conceptual" question: You are working on the Default/DefauldDate/SlectedDefaults property of each component. and it's work ;-) But as we have a Card (as a container), why couldn't we directly update the Default property of the CARD ITSSELF . and continue to use Parent.Default inside the card. From my conceptual point of view, it would be cleaner . But I'm facing some issue I can figure out. For a choice column I will set Choice_DataCard1.Default = If( Parent.Mode = FormMode.New, {Value:"Default"}, ThisItem.Choice ) But for some reason, when I try to access Parent.Default.Value within a component of my card, it says that Value is not recognized. This is like the Parent.Record did'nt get a "correct" data definition type Did I miss something ?

Thank you soo much for the help!

I tried adding the form mode if and i'm not able to get the prepopulated person field to submit to the list. I'm using a SharePoint List Integration.

Thank you for excellent tutorial. Please do similar tutorial for creating cross site lookup field, thanks again

Great video, nice strat on the wall!

how can i prepopulate date ,when the dropdown column status we change ( not started, in progress, Completed).. user will use same record every time for edititng?

Is it possible, while launching the PowerApp from Excel, to use a cell value from the Excel file to prepopulate a field(s) in the PowerApp?

New subscriber here, wonderful content! Question: say I have 2 data sources (d1 = PBIIntegration, d2 = List), what I want to do is > search / filter d1 >> select a record >> pre-populate it to a form > edit / submit form as a new record for d2. It's similar to your video, I got step 1~2 covered, but not sure about step 3 (prepopulate form), would you please kindly comment?

Really appreciate April.. First thing is app layout... I'm using Tablet layout but I can not get like you it's coming very small area(content page) .. Where I can see your screen The layout itself is bigger and right side and left side there still space between properties tab and datacard tabs (1:36).. Can you help me how can I get such bigger layout.. reply please

How can i use text input control to automatic navigate to next screen when the value is correct. Example. Staff number is correct and same with your data source it will automatic open the next screen. Please help

Thanks so much April as always! Is it possible to go straight to the form with pre-populate fields with one click? It seems like the url with parameter takes you to the home page of the app and the new form icon click takes you a pre-populated new form. I'm looking for a link that takes you to the new pre-populated form. Thank you :)

Great Video April. Is it possible to this on a field that is not a dropdown list.

I see that they are all DataCards but one is set as DatePicker etc. Can you please let me know how do you change the property of a data card.

Thank You April

Thanks for another informational video April. Please correct me if I am wrong here but the query string parsing inside Powerapp will work only if this Powerapp is run in browser. It won't work if I view Powerapp on a mobile device.

Thank You for the great video! How to Implement the same when source is SQL Server...how to create choices column in SQL?

Dear ma'ma I have a query. I have one share point list in this list I won't to set specific words base view For user group Unit's base view ( if it's possible how?)

I set my Global Variable accordingly as you showed but still its not recognized when I call it (currentUser) in the Default section, Please Assist. Thank you. All in all everything else was clear and easy to understand

Thanks April 🙏🙏🙏 😊

cool stuff :D but what happens when i do this in EditForm ? Is it possible to do this in EditForm ?

How to insert a table in the Description text field?

Excellent and brilliant

Is it possible to do the same on Model Driven App ?

I need that t-shirt.

Is it possible to generate fields dynamically in Powerapps?

this was a great explanation, but totally useless to me. I need to set a default who is not the user. I want to be able to have the form fill in the name of the VP, who is sadly not me and not likely to be the person using the form.