Filter combobox on gallery but displaying a custom lookup field

[Lars1990]

Hi all,

I filtered a combobox based on a gallery and that works:

Filter(Delistings, DelistingID in BrowseGallery3.AllItems.DelistingID

When I display DelistingID it works

When I want to display a lookup column product it does not work. Anyone who knows why?

Kind regards,

Lars

[v-chenzhi · Accepted solution]

Hi @Lars1990 ,

Do you want to display the value of the lookup column in the ComboBox?

Could you please tell me what's your datasource?

I assume you have this in SharePoint and have a test on my side, please try the following workaround.

Set the items property of ComboBox to:

AddColumns(
    Filter(
        ListName,
        ID in Gallery.AllItems.ID
    ),
    "ColA",
    ThisRecord.TTlookup.Value
)

Best Regards,

Zhi Chen

[Lars1990]

You are a genius, it works. Can you explain what AddColumns does to make this work?

[v-chenzhi]

Hi @Lars1990 ,

Lookup is a complex column, combobox only supports simple columns.

The structure of lookup is id and value.

Created a new column 'ColA' with AddColumns to save the value of lookup, so colA is a simple column.

Please refer to this article for the use of this function:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-table-shaping

Best Regards,

Zhi Chen