Power Platform Community Forum Thread Details

Hi @cwebb365

My scenario is that I have two SharePoint lists:

List 1 is a reference table which contains list of all the countries: ex. CountryRef

Title CountryID

USA 101

Canada 102

List 2 is the main table where I'm patching all the values to, for ex. MainTable

ID PersonFname PersonLname Country CountryID

1 Joe John USA 101

2 Jane Jim Canada 102

In my app, I'm displaying the countries in a combox box since I want the user to be able to SEARCH and I have the multi select off. I'm successfully able to patch the country selection in List 2.

Issue: The issue I'm having is that it is NOT displaying the user's selection when I click on the record in the app. The code I have is as follows on the combo box:

Items- Distinct(CountryRef, Title )

DefaultSelectedItem- Filter( CountryRef, ID in Filter('MainTable', ID = Gallery.Selected.ID).CountryID )

The combo box is NOT displaying any values and neither is it showing any errors.

Please help! Thank you so much in advance!

Categories:

Building Power Apps