Answered

Populating Form Fields From a Collection Based on the Selected Item in a Dropdown Menu

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I am building a canvas app and my dropdown includes a list of client names populated from a collection, colCollFormResponsesAll. The collection is populated from a SP List data source that contains a list of responses to questions. The left-hand image shows how the Client Name is populated from the collection. You can also see I could populate the dropdown with the Title field (right-hand image) or any field in the collection. So using the olCollFormResponsesAll.ClientName works great to populate the dropdown.
DD controls ITEMS property.PNG

What I need help with is how to set the form's Item property such that I can populate the form fields per the selected Client's Title field which is the unique ID.
pwrApps Form Item property - needs a solution.PNG

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

WarrenBelz 156,714 Most Valuable Professional on at

Like
a
(2)

Report
Copy link

Link copied!
Hi @Anonymous ,

You simply need to lookup your list (where the collection is sourced from)

LookUp( ListName, Title = DropDownName.Selected.Title )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
This happens sometimes right after I post, I find the solution. In this case I set the form's Item property to:
LookUp( colCollFormResponsesAll, ClientName = DDSelectClientForm.SelectedText.Value )
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
@WarrenBelz - We just posted seconds apart lol. After plugging in all the values, your solution works as well, so thanks so much for your response!
LookUp( colCollFormResponsesAll, ClientName = DDSelectClientForm.Selected.ClientName )