cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jbinder4
Helper II
Helper II

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

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: 

jbinder4_1-1631026006538.png

 

Interface in PowerApps:

jbinder4_0-1631025931554.png

 

 

- Jacob 

1 ACCEPTED SOLUTION

Accepted Solutions

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

 

a.jpga2.jpga3.jpga4.jpg

View solution in original post

11 REPLIES 11
zmansuri
Super User
Super User

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)"

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?

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.

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

 

jbinder4_0-1631029717247.png

 

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

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: 

 

jbinder4_0-1631030198329.png

 

Try Person.DisplayName

I received an error on adding the .DisplayName

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

 

a.jpga2.jpga3.jpga4.jpg

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (5,040)