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
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
User | Count |
---|---|
198 | |
71 | |
48 | |
42 | |
30 |
User | Count |
---|---|
263 | |
121 | |
94 | |
89 | |
85 |