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
Solved! Go to 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
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
You are a genius, it works. Can you explain what AddColumns does to make this work?
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