Unanswered

Powerapps Dropdown fed from one list but pulls current value and writes to main list.

(0) Share

Report

Posted on by AntEm

Hello and thank you for any help that can be provided in advance.

I currently have a SP List that feeds a gallery form with the current values.

I need to have the current value from the SP List called "Band" feed into a dropdown list on the PA form, but then the user can select from the dropdown to change the value. Everything is setup perfect on the form, but this dropdown and I cannot figure it out.

If I can explain further; I have a preexisting list in SP with a column called "Band" and a value of 200 in one of the lines. In the PA form, I need the dropdown to show the current value of 200, but then allow the user to select the dropdown if they want to change it to another value like 300, or 400. Any help would be appreciated. TYIA.

Categories:

Building Power Apps

All responses (4)

Answers (0)

Sort by

BCBuizer 22,854 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @AntEm ,

Can you please share what the type of the Band column is?
v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @AntEm,

Do you want to set the default value of the Dropdown control as 200?

Could you please tell me if this Band column is Text or Choice?

If the Band is Text type, you could set the dropdown control Items property as below:

Distinct(ListName,Band)

Set the Default property(I assume it is a Dropdown box instead of ComboBox, if it is ComboBox, you should set DefaultSelectedItems property😞

"200"

Update property of the data card including the dropdown box:

Dropdown.Selected.Value
AntEm 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi BCBuizer,

Thank you for the follow-up.
The band is a text input in the main SP list.

Here is some more detail: The band lookup is in a separate list (because there is a cascading element after this).

So the band list is like: 200, 300, 400, 500, 600. And then in the main SP list their could be a current row with 200. When the form is opened, I want the dropdown to default/show the current value of 200 from the main SP List. I then want the user to be able to change the value from the dropdown to say, 300 or 400 from the Band list. I hope I explained the scenario well. I have everything working in the form except this dropdown flow.
BCBuizer 22,854 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @AntEm ,

Try setting the Default item to:

LookUp( ListName, Band = Parent.Default )

A few things to note:

- ListName is the name of the list that has all possible Band values

- Band is the name of the column of ListName that has the possible values

- Parent.Default is the reference to the DataCard in which the dropdown is present (I assume it is, since you mentioned PA form).

- The Default property of the DataCard should be set to ThisItem.Band, which refers to the Band column in the list that captures the user input.