Unanswered

Dynamically update depending form fields after changing item of dropdown

(0) Share

Report

Posted on by Lutz

Hi,

I've created a form based on a SharePoint-List. After changing the item dropdown menu I want to update the corresponding field of the same row from this list. How can this be done?

Thank you in advance.

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Lutz

Can you describe a little more about what you are trying to accomplish?

Describe your list columns and what the purpose of the dropdown is for.

Was this reply helpful? Yes No
alaabitar 1,503 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hello,

To do that you have to edit the default property of the corresponding field to something like
If(dropdownserialnumber.selected = "15110170","Model 15110170","Not Model 15110170")

Best regards,
Alaa

Was this reply helpful? Yes No
Lutz 9 on at

Like (0)

Report
Copy link

Link copied!

Hi @RandyHayes ,
I have a SharePoint list with e.g. 2 columns: Column1 = Serialnumber, Column2 = Model
In the PowerApps form is a dropdown menu for serialnumber and a readonly datafield for model. After selecting a serialnumber from the dropdown menu, datafield model should show the chosen model of the same line of the list.

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Lutz
So then your Dropdown Items property should be the name of your SharePoint list (the datasource).

And you did not specify what kind of control you want this in for the model, but I am assuming a label because you mentioned the column should be read-only, so, if it is a Label, then set the Text property to: yourDropdown.Selected.Model

Was this reply helpful? Yes No
Lutz 9 on at

Like (0)

Report
Copy link

Link copied!

When I use yourDropdown.Selected. as text for the Label, I can only choose between Value and ID.
Actually, I use Choices([@SharePointTable].Model) - but this doesn't get updated after selecting a new value from dropdown.

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Lutz

I thought your dropdown was the Serial Numbers? (from your picture)

But, right, that is why I mentioned that you will need to use your Datasource as the Items property of the dropdown.

If you use Choices, then are you stating that the Model column is a Choices column or a Lookup column in your list? I am going to assume that it is a lookup since you see both Value and Id.

So, if it is a lookup and you want to show the referenced column of the looked up list, then you would choose Value.

If you could provide more details on your data list and the column types and what you expect to see in your app and in what kind of control, that would help get to a solution faster.

Was this reply helpful? Yes No
Lutz 9 on at

Like (0)

Report
Copy link

Link copied!

Yes, the dropdown is the serialnumber = datasource "Cocices([@SharePointTable].Serialnumber)"
Model label text = datasource "Choices([@SharePointTable].Model)"
Both fields are lookups to another SharePoint list which stores the serial numbers and models.

The goal is to have a form to create a new entry by choosing a serial number (lookup database with serial numbers and model). When I choose a serial number from the dropdown I want to see in the label field what the model of the chosen serial number is.

Thank you Randy.

Was this reply helpful? Yes No