Jan '24 • Stuck or Need Help
Combo Box NOT displaying default data from SQL
I am trying to use a Combo Box and it is not displaying the "DefaultSelectedItems" data as desire. Here is a summary:
1) The Combo box "Items" are coming from the "Planning" table.
2) Prior to getting to this screen, the Project number was selected from the "gal_Contracts" in which the Project is selected.
3) The Combo box needs to display the "Business Name" from the "Contacts" table.
4) There are 3 SQL tables used here: "Planning", "ContractsGeneral", and "Contacts"
5) The contact for the "ContractsGeneral" is different than the contact for the "Planning" table. Hence, do not confuse the duplicative Contact_fk fields in both tables. That is just the way I keep up with foreign keys.
As seen in the below screen shots, the foreign key is displayed from the GRAY box which is looking at the "ContractsGeneral" table. Hence, the foreign key data is there.
This is the "Default" setting in the Gray box.
I tried this in the "DefaultSelectedItems" of the Combo Box and can see table records, but can retrieve the data I want to display.
I tried this in the "DefaultSelectedItems" of the Combo Box and just gives me an error.
See screen shots to help.
2
3 comments
Combo Box NOT displaying default data from SQL
skool.com/learn-power-apps
A community of people who are enthusiastic about and trying to learn about Microsoft's Power Apps!
Leaderboard (30-day)
1
+12
2
+9
3
+4
4
+4
5
+3
Powered by