PowerApps Autofill Form Data Based on Microsoft Lists Records 

Thank you so much for the video! Your method is able to solve the issue I've been facing for days. I can't thank you enough for this. Please keep up the good work!

Thank you for posting this - really helped me today

Exactly what i was looking for, straight and simple, thanks.

Hi!! Thanks for teaching me how to do this in PowerApps! I really enjoyed it! All the best and keep like that!

I've been looking for this! thanks Rashid!

Amazing Video, thank you so much its been so helpful!

So useful ! Thank you so much

Very good tutorial. Thank you.

Dude you saved my ass at work with this tutorial hahahahaha 1000 Thanks for you!

Thank you So Much, Great Video

Hello! This is great and helpful! May I ask you a question? I used your approach but when it is on EDITMODE, all the data fields that were auto-populated went missing? I need to re-select the dropdown again to make it visible.

Thank you for the lesson. I have a question on for you. My auto-populate source is Department then from department it will populate the list of staffname. for the part Onchange, Set(xxxVar....) which one should i select?

Hi! Thank you for the advice, you helped me a lot! I still have a question for you. What if I wanted to have more than a few text inputs. If I was doing it like this, there's only a limited amount of text fields I can fit into one screen, and without using Gallery or Table (you are able to have as many records as you want on one screen and you can SCROLL down in that one screen to access the ones that are lower on the page), I can't see a way of putting more text fields into one screen. Is there a workaround? Is there maybe a way to put more text fields into that one screen and being able to scroll through them like I would be able if I used gallery? Thank you!

Hi, hope you’re doing great amigo, I’m from Mexico and your videos help me so much to learn about power apps and now I’m making my own test with your videos as a guide. I have doubts about this process, how you created the variable to get all the data. I hope you could help me, have a great day amigo.

Great, really helpful👍

Just what I wanted. Thank you so much. Can we also populate attachments present in sharepoint list?

Hello ,Thankyou Sir. The video was quite helpful. I have one question here. Here we use different controls instead of a form,right. And we set the items of the drop-down to the list and it's email as its value. So how do I make my drop-down as appear to be as blank when a user lands on the screen from other screen? Also, how to do validation of all these fields and display error messages if any ?

Thank you for the video.. can I replace the table with office365 user

many many thanks

Hi Rashid, Thanks a lot for this video. However I have another question like here you are selecting the email address and according to that populating the fields but if you are logging in and without selecting the field and you need to get the logged in email I'd like in this video you are logged in by getting the email address and query the list and comparing the email and filtering and then display the Fields. Could you please suggest on that

Very helpful , thanks 👍

Hi, is there a way to only show the email/name of the user logging in or submitting the form? Thank you!

thank you so much, this video is very helpful, just one thing, i have to write "Value" instead of "Result"

hello,Vedio is very Usefull ThankYou And also can u tell how to auto populate radio Buttons. For example based on Email radio button1-Employee Radio button2- Manager we need to select from the list based on email present in the list table

What if I want the dropdown list to have emails of microsoft365 users list?

Thank youuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuu

Hi, is there anyway to search and type into either of the boxes? As I have a list with over 3000 data points? Thanks

if we use number instead of drop down, EmailDDL.Value is this ryt?

Hi Rashid. I have a specific doubt. Please help me clear it. Suppose there is a shared mailbox and I have access to it. There are different folders in that shared mailbox. I want to create a flow that triggers when a SharePoint file is modified and it sends the mail to a specific folder in the shared mailbox. Can we do it ? Sending it to a specific folder in the shared mailbox ?

Hi, please upload a video that shows how to auto populate other columns based on their names without dropdown, just a text input box

Thank you, I have a one question, i have used this functionality in my form but when i hit new form it shows the values i believe this is because of we are setting the variables in default, Any solution for this

How would I be able to sort the Email column by ascending order without messing up the autofill formulas?

please Contactvar , what is this?

How to auto fill based on two different variables example If I select ID and Name it should give me details in other columns also I have to have one option to fill in missing values

Buddy Thank you for the video. It was helpful. I have a question - after the values are auto populated using the above formula, as my field is a choice function, therefore I had to apply the function contactvar on the property default selected items. After the record is created and when I go to create a new form I see my earlier autopopulated fields. I have tried to use reset function on success to clear the values but it will not clear. Can you please help.

Tom cruise didin't answer my call...

🙃🙃🙃I can't believe no one here has asked what the variable ContactVar is, where is this variable defined?