Text field/drop-down needs to be pre-populated by previous drop-down selected value (Sharepoint list Soource)

[jbinder4]

Hello all, 

I have been having problems getting a text field or a drop-down box to pre-populate and filter the value shown based on the previous drop-down a user would select. This is all coming from a sharepoint list. I have tried using this formula to get the cascading drop-downs to work: "Filter('Executive Sponsors - Tyler Dev', BusinessDomain = BusinessUnit_Dropdown.Selected.Value)"

The source has columns of people and BusinessDomain where each row in people belong to a business domain(Clinical, Administrative, Academic). What I am looking for is to have the Business Domain value selected by the user on the form auto-populate the Executive sponsor field which comes from the person column in SP. 

Any help on this would be truly appreciated. Thank you! 

Screenshots: 

Source Columns: 

Interface in PowerApps:

- Jacob 

[zmansuri]

if business domain is choice type column in sharepoint then

Filter('Executive Sponsors - Tyler Dev', BusinessDomain.Value = BusinessUnit_Dropdown.Selected.Value)

Also you may need to mention the column you want to display

Filter('Executive Sponsors - Tyler Dev'.ColumnName, BusinessDomain.Value = BusinessUnit_Dropdown.Selected.Value)"

[jbinder4]

Hello, 

Thank you so much for your input on this! Your first function got mine to run error free, but not give any output. The second function given created errors for my function. Could this issue be because the column within my sharepoint is a people/group based column?

[zmansuri]

Are you using DropDown or ComboBox?

Filter('Executive Sponsors - Tyler Dev', BusinessDomain.Value = BusinessUnit_Dropdown.Selected.Value)

If the above code is working for you. Try looking for the output in the formula bar. Attach a picture if you can.

[jbinder4]

I am using a drop-down. Here below is what I believe you are asking for: 

[zmansuri]

Filter('Executive Sponsors - Tyler Dev', BusinessDomain.Value = BusinessUnit_Dropdown.Selected.Value).ColumnNameThatYouWantToDisplayInDropDown

[jbinder4]

I am still not quite receiving the correct output. I apologize that this is not turning out to be an easy fix. 

Here is my output with that code: 

[zmansuri]

Try Person.DisplayName

[jbinder4]

I received an error on adding the .DisplayName

[zmansuri · Accepted solution]

Ok. I got it. I created the same scenario:

Item property of your dropdown will be

Distinct(Filter('Executive Sponsors - Tyler Dev', BusinessDomain.Value = BusinessUnit_Dropdown.Selected.Value),Person.DisplayName).Result