Power Platform Community Forum Thread Details

I have a dropdown where you can select your country. It's filled as follows:

Sort(Distinct(PurchaseOrderTable,Country_Column1), Ascending)

The PurchaseOrderTable is the table on the canvas. The Country column in that table is filled like this:

Sort(
 Filter(
 AddColumns(
 PurchaseOrderHeadersV2,
 "Country", 
 LookUp(
 VendorsV3, 
 VendorAccountNumber = 'Vendor account'
 ).AddressCountryRegionId
 ),
 (
 IsBlank(TextPOSearch.Text) || 
 (
 TextPOSearch.Text in 'Purchase order' || 
 TextPOSearch.Text in 'Vendor name' || 
 TextPOSearch.Text in 'Vendor account'
 )
 ) && Country = DropdownVendorsCountry_1.Selected.Result
 ),
 'Purchase order',
 Descending
)

Now there is this error on the dropdown: "Warning: The columns produced by this rule are all nested tables and/or records, however the property expects at least some columns of simple values"

How can I reference the Country column in the table, without having this error?

Categories:

Building Power Apps