powerapps: populate drop down list from another datasource
I stumbled across Microsoft PowerApps earlier, and though I would have a play with it. I have connected to my SQL Server, and created a template for browsing, viewing and editing a basic application. Now in my database I have the following relationship:
On the add/edit screen this asks the user to enter the "CustomerID". I want to be able to use a drop down menu to search the list of customers.
So far I have:
- Added an additional Datasorce to my table "Customers"
- Changed the control from a text box to a drop down menu
it is at this stage I am stuck and unsure of how to progress further. Currently when debugging, the list shows nothing, nor appears to be searchable.
Answer
I found out how to do it! (with a different example, however the same thing required)
after the 2nd stage above, scroll down until you see the DataCardValue[number].value. its here that you can enter the alternative data source and populate the drop down list with the value you want. This automatically references the ID's and the correct options are shown:
