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

(0) Share

Report

Posted on by jbinder4

112

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

Categories:

Building Power Apps

I have the same question (0)

All responses (11)

Answers (1)

Sort by

zmansuri 6,048 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
jbinder4 112 on at

Like
a
(0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
zmansuri 6,048 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
jbinder4 112 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
zmansuri 6,048 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
jbinder4 112 on at

Like
a
(0)

Report
Copy link

Link copied!

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:

Was this reply helpful? Yes No
zmansuri 6,048 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Try Person.DisplayName

Was this reply helpful? Yes No
jbinder4 112 on at

Like
a
(0)

Report
Copy link

Link copied!

I received an error on adding the .DisplayName

Was this reply helpful? Yes No
Verified answer

zmansuri 6,048 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
jbinder4 112 on at

Like
a
(1)

Report
Copy link

Link copied!

This was indeed the correct solution!! Thank you so much. I will go ahead and accept this as my solution.

Was this reply helpful? Yes No