Unable to get the autopopulated items based on a dropdown selection

(0) Share

Report

Posted on by Teresa24486

611

Hi,

I have list A with look up field Fac. On powerapps, I need to prepopulate 2 fields based on the selection of the dropdown lookup field.

Eg: when Lookup field from List A- Fac (dropdown) is selected; two fields (Department and Manager) related to the column should auto-populate on my Canvas app.

Please assist anyone?

Thank you

Categories:

General Questions

All responses (2)

Answers (0)

SanmeshG 1,938 Super User 2025 Season 1 on at

Like (0)

Report
Re: Unable to get the autopopulated items based on a dropdown selection

Hi @Teresa24486 ,

I am assuming that Manager is a Person or Group type of column(I am assuming SP is your data source here) and Department is a choice column.
Set the default selected Item property of the Manager Combo box to the below.

{ DisplayName: LookUp( Department, Department = Dropdown1.Selected.Value ).Manager.DisplayName, Claims: "i:0#.f|membership|" & LookUp( Department, Department = Dropdown1.Selected.Value ).Manager.Email, Department: "", Email: LookUp( Department, Department = Dropdown1.Selected.Value ).Manager.Email, JobTitle: "", Picture: "" }

For Department the formula is similar. Now it depends what type of column is Department in your list. For text you can use the below in the default property of your text control.

LookUp( Department, Department = Dropdown1.Selected.Value ).Department

If Its choice then you can use below formula in your default selected Items property of your combo box

{ Value: LookUp( Department, Department = Dropdown1.Selected.Value ).Department }

Hope this helps!
Ami K 15,665 Super User 2024 Season 1 on at

Like (0)

Report
Re: Unable to get the autopopulated items based on a dropdown selection

@Teresa24486 could you share more information.

What is your data source
What are the control types for Department and Manager? Are they text fields?
What are the field types for Department and Manager in your data source? Are they single line text fields/choices fields?
How are these two fields related to your "Fac" Lookup field?