Basic ComboBox using lookup table from sql tables

[AndyRossco]

Hi,

I have 2 SQL Tables, [dbo].[tblVanJourneyLog] and [dbo].[tblVan_Details]

     I am trying to create a Combo Box which looks up our Van Registration List from a Van Details Table which has primary key as Van_Id, I what user to select from actual Reg Numbers not Van_Id.

Then I want to store Van_Id selected and store in VanID of the [dbo].[tblVanJourneyLog].

I have tried many things with no luck. I would greatly appreciate any help on this.

I have created a basic App using PowerApps auto generated using the  [dbo].[tblVanJourneyLog] table. Then I added the [dbo].[tblVan_Details] table. Any help on this would be very appreciated. Andy

[v-xida-msft · Accepted solution]

Hi @AndyRossco ,

Could you please share a bit more about your scenario?

Do you configure the VanID field as a ComboBox within your Edit form, which references values from the [dbo].[tblVan_Details] table?

Further, do you want the CmboVanSelect box to display selected value when you edit your [dbo].[tblVanJourneyLog] record?

Based on the screenshot that you mentioned, I think there is something with the LookUp formula you used in your CmboVanSelect.

I have made a test on my side, please take a try with the following workaround:

Set the Items property of the CmboVanSelect within the VadID_DataCard2 to following:

'[dbo].[tblVan_Details]'

Set the Primary text property and SearchField property to Reg column.

Set the Update property of the VadID_DataCard2 to following:

CmboVanSelect.Selected.Van_Id

If you want the CmboVanSelect box to display selected value when you edit your [dbo].[tblVanJourneyLog] record, please take a try with the following workaround:

Set the DefaultSelectedItems property of the CmboVanSelect box to following:

{
  Reg: LookUp('[dbo].[tblVan_Details]', Van_Id = ThisItem.VanID, Reg)
}

Please take a try with above solution, check if the issue is solved.

Best regards,

[AndyRossco · Accepted solution]

Thanks, This information has sorted my problem.

🙂