You’re offline. This is a read only version of the page.
Hello,
I have a list of items.
When I open the edit form it only displays the first record to edit.
I have a lookup on the form that a user can make a choice of what record to edit.
The issue is that when the user makes a choice from the dropdown/ lookup the form doesnt refresh to that item, it stays on the first record.
Above you will see that it displays record 21
The lookup dropdown showing is related to a different record from the list.
Clicking on the selection should update the form to display that records metadata.
The form and the data both use the same list items.
Below is the design view.
Maybe I am going about this in the wrong way?
The Text box left of the lookup filters the roles used in the lookup.
Yes. Not only can the same datasource in the dropdown be connected, but it must be selected for the form to work right. The formulas for the connections are shown in red above each control. The Item property of the form has to reference a unique value in the table being referenced by both the dropdown and the form. In the case of my example, a datasource called accounts is used and the field with a unique value is 'Account Number'.
A dropdown control is used to select a single unique record from a datasource. Any field in the record selected in the dropdown can be referenced even though the window shows only one field. So the Account Number can be referenced by the form's Item property Lookup(accounts, 'Account Number'= Dropdown1.Selected.'Account Number' ) even though the Account Name is the one shown in the window of the dropdown.
So the dropdown can still be connected to the datasource outside the form?
Example of the formula would be helpful!
Thanks!
The screenshot shows a dropdown for a sample contact list. The Items property is shown above the dropdown and the DataSource and Item properties for the form are shown above the form. The form shows the values for the entire record selected in the dropdown.
I need to have the dropdown outside the form?
Can you show or explain what that means as I am sort of new at this but getting better every day from people here on the Power Apps forum. 🙂
A form will only display a single record from a datasource. You can select the record using a gallery, a datatable or a dropdown box but it must be outside of the form itself as @C-Papa says. The DataSource of the form must be the same as the gallery, datatable or dropdown. If you are using a dropdown to select the record, then the form should have the Item property like
Lookup(DataSource, ID = Dropdown1.Selected.ID)
Hi, you need to have the dropdown outside of the form, the when an item is selected, you can set the selected item as a variable and use the variable in the Form Items to update the form
#1
WarrenBelz
791
Most Valuable Professional
#2
MS.Ragavendar
410
Super User 2025 Season 2
#3
mmbr1606
275
Super User 2025 Season 2
Share
Report
All responses (
Answers (
