PowerApps set default value based on another field from a dropdown

Sometimes you want to set the default value of a field, a group of fields, or a form control based off the selected record from a dropdown. In this video you will learn exactly that. You will create a dropdown and when your user selects a record you will then populate a text input, a different dropdown, a combo box, a collection, and even a people picker. This video has come from the common question of how do I set default values based on a dropdown that have come from many viewers. We also answer two related questions from Twitter and customize a form. The primary data sources shown are SharePoint and Office 365 Users but everything should be applicable to other data sources like SQL and Dataverse.

00:00 Start
01:34 Demo of the problems we solve with dropdowns
04:01 Using a dropdown to set the default values of a text input, drop down, and a label
09:37 Setup a gallery, a form, unlock some cards, and populate fields based on data from a different table data source
17:19 Look at how to set a combo box from the selection in a dropdown control used for a people picker and Office365Users.SearchUserv2
19:09 Use the chosen record in a Power Apps Dropdown to populate a collection by filter another data source thanks to OnChange property

[ryang]

Absolutely loving your channel. Recently started to learn PowerApps and these videos are at exactly the right pace. Thank you!

[cmacdhon]

Shane, I was thinking... You are essentially doing my job for me. I'm really just a guy who watches your videos, and clicks his mouse all day. I should send you a W-9 to fill out.
I cannot express my gratitude enough for all that you do. My boss would too, if he only knew.

[JennyJenn]

Thank you for being you and bringing serenity to my workday. :) Another wasted 2 hours spent PRIOR to just coming to one of your videos and learning how to do something in less than 3 minutes! Who's better than you?!? NOBODY!

[TechieManufacturer]

For days i struggle with how to do this, now your video just made me cross the hurdle with this project, thank you so much

[_achilles__]

Thanks Shane. Stuck with this Issue for a long time until I watched your Video! Your videos really help me a lot.

[MesVser]

Shane you are an amazing resource! I spent hours trying to figure out how to have an Edit form field autofill based on another field in the form. 5 minutes of watching this video and Edit form is now working as expected.

[wendymeyer]

Can't even find the words to express how immensely grateful I am for your videos! 🙌

[marieferguson]

Thanks Shane! Really appreciate the response and the walkthrough for the people picker field!

[jamesbuchanan]

Got what I needed in the first 5 minutes. Thanks.

[TessAlmond]

I've tried and tried and this isn't working for me. I think the Distinct on the 2 dropdowns, doesn't allow the 3rd field (text label) to see the 3rd value. I have a lookup table with 3 columns, Office, System and Approvers. On the form I have have dropdowns for the Office and System field with Items set to Distinct(SystemLkp, Office) and Distinct(SystemLkp, System) and a text label that i want populated with Approvers based on both dropdown selections. I tried a lookup and failed.

[kumnegerholdings]

Thank you Shane. Question, I have a dropdown that is a choices field from SharePoint. Based on the value selected from the dropdown, want to default a "Assign to " column (person data type). I have a lookup table where choices are mapped to names. How do I go about this? TIA

[steegbj]

Thanks for answering my question, Shane. Not sure if that is exactly what I meant, but on the upside, I've got a collection named after me! :-)

[stephl]

Shane, first time caller....long time fan... ;-)

Question: Have you ever thought of doing a video that does:
**Pulls information for drop down fields from an external source,
**Where a VPN login is needed to keep the field options up to date? (not a LDAP source but does have an API available with the date)

[LylyMing]

4:25 - I'm not able to see the field I'm looking for. Do you have any idea why? Thanks.

[edinbrgt]

Hi Shane I really like your material and the way you teach, sincerely thanks, I am so happy learning with your videos, I was able to perfom a portal and most of my queries found an answer within your videos. Thanks a lot once again.

[Parwitch]

I did link dropdown to dropdown like you demonstrate but there is an error. It said "the property of this control expects Record values. The rule produces Text values which are incompatible"

[kellyliu]

Great video examples thank you! Hope you can do the similar video with custom page(Canvas style) for Model-Driven, particular dropdown that not come with Insert Input box.

[KingShort]

If I want to select more columns from my sharepoint list like: Name, Address, Zipcode to display it in the Text field based on the Dropdown. How can I do that?

[kabax]

Do you know how a choice field can set a default value based on two other choice fields? Field 1 has choices A or B. Field 2 has choices C or D. Field 3 has choices W, X, Y, Z. I want Field 3 to equal W if A+1, X if A+2, Y if B+1, and Z if B+2.

[JohnJoe]

for me when I submit a form all the values from the combobbox disappear and save blanks into the sharepoint. I think it's because the .selected loses focus and returns blanks but idk how this happens only for me