Announcements
I have been working on this for two days without success. I have a Display Form with a DataSource of "Materials" I also have a ComboBox6 with Items of Materials.MaterialsTitle. The Item for my Display Form is ComboBox6.Selected. I just can not get the other fields to populate in my Display Form by choosing a title from my ComboBox. I've tried the combobocx inside and outside a data card, made sure all the data cards are set to ThisItem.[field name] and DataFields are correct and the values are set to Parent.Default. Nothing I try works! All I'm trying to do is populate a display form with the other fields in a table when I select the title field in the combobox. Any and all help is appreciated! TIA
Hi @gnott,
The combo box should be outside the form and the Item property of the form set to:
LookUp(Materials, MaterialsTitle = ComboBox6.Selected.Value)
The above works if MaterialsTitle is a text type column. If it is a Choice or LookUp type, the formula for the Items property of the form should be:
LookUp(Materials, MaterialsTitle.Value = ComboBox6.Selected.Value)
@gnott
If your datasource is SharePoint, use LookUp(Materials, ID=ComboBox6.Selected.ID) as the Items property of the form. I suggest you make the Items of the combobox Materials and put MaterialsTitle as the field in the window.
@BCBuizer Thank you!! Not exactly what you said (and I'm curious why my eventual solution works) but I played around with it until it did work. The eventual solution is
LookUp(Materials, MaterialTitle=ComboBox6.Selected.MaterialTitle)
Thank you for the assist! MUCH appreciated!
@Drrickryp Thank you! It was the Lookup that put me on the right track. My eventual success was LookUp(Materials, MaterialTitle=ComboBox6.Selected.MaterialTitle), but your comment and @BCBuizer 's led me to the solution.
Hi @gnott ,
Indeed the column title should have been selected as you found out yourself. Glad to read you found a solution.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 358 Most Valuable Professional
11manish 214 Super User 2026 Season 2
Mohsin Ali 185
